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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Including query dates in report 1
Printing date range on Report 4
filtered form data only 2
Date Range on Crosstab Query to create a Reports 1
Date Range in Header 1
Date Range in Header 1
Strange behavior from append query 2
Generating report which will show only specified range in field (d 7

Back
Top