Filtering or Querying for Reports

  • Thread starter Thread starter Rick Johnston
  • Start date Start date
R

Rick Johnston

Hi,

I would like to print a report that shows only some of the records in the
database - in this case only records entered in the past week (based on my
"DateEntered" field).

What is the simplest way of going about this?

Thanks in advance.

Rick
 
There are a few ways. One would be to base the report on a
query and in the query's criteria for the "DateEntered"
field put
=[Enter Last Weeks Date]
Click to expand...
This will prompt the user for the date to be entered.

Jim
 
Thanks Jim,

So I already have this report created. After I create the query, how do I
base the report on it - or do I have to create a new report or a duplicate
of the one I have.

Thanks again,

Rick

Jim/Chris said:
There are a few ways. One would be to base the report on a
query and in the query's criteria for the "DateEntered"
field put
=[Enter Last Weeks Date]
Click to expand...
This will prompt the user for the date to be entered.

Jim
-----Original Message-----
Hi,

I would like to print a report that shows only some of the records in the
database - in this case only records entered in the past week (based on my
"DateEntered" field).

What is the simplest way of going about this?

Thanks in advance.

Rick


.
Click to expand...
Click to expand...
 
Run the report with a DoCmd.OpenReport with a WhereCondition clause
containing the criteria you desire. Or, create a complete new SQL string in
code and pick it up in the Report's Open Event and use it to replace the
Report's RecordSource. Both will require some VBA, but not "advanced".

Larry Linson
Microsoft Access MVP

Rick Johnston said:
Thanks Jim,

So I already have this report created. After I create the query, how do I
base the report on it - or do I have to create a new report or a duplicate
of the one I have.

Thanks again,

Rick

Jim/Chris said:
There are a few ways. One would be to base the report on a
query and in the query's criteria for the "DateEntered"
field put
=[Enter Last Weeks Date]
Click to expand...
This will prompt the user for the date to be entered.

Jim
-----Original Message-----
Hi,

I would like to print a report that shows only some of the records in the
database - in this case only records entered in the past week (based on my
"DateEntered" field).

What is the simplest way of going about this?

Thanks in advance.

Rick


.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top