Recent content by davesho

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...

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...

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...

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...

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".