Creating a MS Access Report

[mikepf]

Can an Access Report read a date from a second table or is the query used to create the report the only place to add the date?

 

[genomon]

Wow. Is this a homework assignment? Have a peek at DLookup() in Access help, as well as joins in your queries.

Money can't buy happiness -- but somehow it's more comfortable to cry in a Corvette than in a Yugo.

 

[mikepf]

Interesting about DLookup. But where in Access do you put the statement to get the data?

 

[GingerR]

What exactly are you trying to do that you are having a problem with?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[mikepf]

GingerR
I've got a MS Access report with a file that feeds the query. Now, I want to read a file (only has one row) with beginning and ending date. Is there an easy way to do that rather than change the query (that has counts)?

 

[mikepf]

That DLookup works GREAT!! Thanks!!