Selecting records by date range not using query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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...
 
Back
Top