two table report

[Russ]

If I have two tables - one with the numbers of 0001 to 9999 in them,
and another one with a field that contains some random four digit
numbers, can I generate a report that shows all the numbers in the
first table with the random numbers from the second table highlighted
or indicated somehow?

Russ

 

[Allen Browne]

1. Create a query that has both tables in it.
I will call them Table1 (for the random numbers), and Counting (for the
complete sequence of numbers.)

2. Drag Table1.ID onto your Counting.ID.
Access now shows a line joining the 2 tables.

3. Double-click that line.
Access pops up a dialog with 3 options.
Choose the one that says:
All records from Counting, and any matches from Table1

4. Add the fields you want to the grid.
Save the query.

5. Create a query based on this report.
Like the query, the report now shows all numbers from the counting table,
and the rows where the random number is not blank.

(If you prefer, and you are using Access 2000 or later, you can highlight
them with Conditional Formatting. It's no the Format menu in report design.)

 

[Russ]

Am I missing something with your post Allen? With your link, all I
get is this newsgroup and your message.

Russ

 

[Russ]

Sorry about the previous post Allen. I just got in from a busy
morning and I had my head on backwards.

Russ

 

[Russ]

Sounds simple Allen. I'll give it a try tonight. Thanks.

Russ