multiple tables in a report

[Davo78]

Hi All

The sonairio: Return faulty Items and sundry items which are tracked using
Consignment No.

The main report is based on a table "FaultyItems" which relates to table
"Customers" and includes a date field.
I need to run this report and add 2 other tables to it. "Sundry Items" this
also includes a date field and "Consignment No" no date field.

The report is to be generated by date range.

The record source for the main report is based on a query comprising
"Customers" and "FaultyItems" this works fine, but, when I add "SundryItems"
no data is displayed.

Also how can I get "ConsignmentNo" to display in the report when there is no
date to use.

Thanks in Advance
Davo

 

[Jeff Boyce]

Davo

"the report is generated by date range" -- I'm confused, how can you have
items selected from your tables by date range when there's no dates in the
rows?

We aren't there. We can't see your table structure. Since it all starts
with the data, it could be tough offering specific suggestions without more
specific descriptions.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Davo78]

Jeff

The 2 tables "FaultyItems" and "SundryItems" both have date fields.

Table "Consignment" does not have a date field. A date field could be added.

Thanks
Davo

 

[Jeff Boyce]

Sorry, hopefully someone else can infer from your description what your
table structure is like.

And without a look at your SQL statement (of your query), it's not clear
what/how you're collecting together the data for your report.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/