Selecting records by date range not using query

H

Heart-of-Dixie

I have a report that is not based on a query but gathers data directly from
several tables. Is there a way to select records based on a range of dates
contained in the SubmitDate field in one of the tables? Thanks!
 
D

Duane Hookom

Why don't you consider this a query? If there are two or more tables in the
record source of the report, I would consider this a query and not a table.

There are many methods for filtering a report based on a date range. I
prefer using the Where Clause in the DoCmd.OpenReport method.

Martin Green has several tutorial type pages at
http://www.fontstuff.com/access/acctut08.htm.
 
H

Heart-of-Dixie

thanks for your help :)

Duane Hookom said:
Why don't you consider this a query? If there are two or more tables in the
record source of the report, I would consider this a query and not a table.

There are many methods for filtering a report based on a date range. I
prefer using the Where Clause in the DoCmd.OpenReport method.

Martin Green has several tutorial type pages at
http://www.fontstuff.com/access/acctut08.htm.
Click to expand...
 
Top