By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,035 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,035 IT Pros & Developers. It's quick & easy.

Report from linked tables.

P: n/a
I have an Access database of two tables. One table is a vehicle inventory
table and the other is a vehicle maintenance table. There is one field
common between both tables and these fields are linked. This field is the
vehicle number. When I query the tables, I get the all the records that fit
the parameters of the query. Up to here, everything works fine. My problem
is I wish to create a report based on a query that will return a single
record from the inventory table and all the records from the maintenance
table. For example I would like the the report to return information from
the inventory table once in the heading of the report, unit number, tag
number, vin numbert etc. and then all the entries from the maintenance table
in the body of the report. Any help appreciated.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"news" <jo**********@worldnet.att.net> wrote in message news:<UC*********************@bgtnsc04-news.ops.worldnet.att.net>...
I have an Access database of two tables. One table is a vehicle inventory
table and the other is a vehicle maintenance table. There is one field
common between both tables and these fields are linked. This field is the
vehicle number. When I query the tables, I get the all the records that fit
the parameters of the query. Up to here, everything works fine. My problem
is I wish to create a report based on a query that will return a single
record from the inventory table and all the records from the maintenance
table. For example I would like the the report to return information from
the inventory table once in the heading of the report, unit number, tag
number, vin numbert etc. and then all the entries from the maintenance table
in the body of the report. Any help appreciated.


Put all the fields you want to see once per vehicle in the summary
section of the report and the rest in the detail section.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.