Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. davesho

    This query works in Access not in SQL server

    My apologies -- my problem is a difference in how MS-Access handles SQL compared to Visual Basic 6.0 (not between Access and SQL Server). Using the same SQL statement (ref. above), in Access I get a recordset returned with 56 or so records, in VB using the same SQL statement, I get EOF and BOF...
  2. davesho

    This query works in Access not in SQL server

    longmatch- Did you solve this anomaly? I'm having the same problem: Here's my SQL statement: SELECT [time stamp], [shrink], [shrink per inch], [part number], [send reason] FROM [Cut Length Adjust Log] WHERE [time stamp] Between #6/28/2003# And #7/29/2003# AND [shrink] Is Not Null AND...
  3. davesho

    one report, two tables (no relationship): how?

    I did try creating a subreport, and that worked. No i need to get a grand total from the subreport list (special charges) and the invoice...
  4. davesho

    one report, two tables (no relationship): how?

    Table 1 (invoice): 20 records Table 2 (special charges): 3 records When i create a relationship between the two tables (uni-join), and create a query with those tables joined, the result is a record set with 80 records. What i really want no the report is the 20 records from the invoice and...
  5. davesho

    one report, two tables (no relationship): how?

    How do i pull information from two tables (that have no relationship)? Table 1: Invoice information (multiple records, usually 10-15 records). Table 2: Special charges (pallet charges, etc., usually 2-3 records). Both tables do have the same "invoice number".

Part and Inventory Search

Back
Top