Printing report from a query

  • Thread starter Thread starter Robbie
  • Start date Start date
R

Robbie

I know this may sound like a simple question to you Access
pros, but here goes anyway.

I have created a form for data entry... from that data a
report is generated. Can I had a button to the form to
print via a query(maybe) only selected dates? We are in
the linehual business of furniture and the database keeps
reocrds of how many pcs are shipped and what route they
are on... when we print the report it prints every date
that we have entered so far... we just want to print the
date that we are loading that day. As you might be able
to tell due to the lack on any technical wording we are
not that Access literate so any info that could lead us in
a right direction would be appreciated!

Thanks

Robbie
 
Robbie

One approach would be to add an unbound control to the form. In that
control, you would put a date for which you want the report to run.

Reports can be based on tables (which yours sounds like), and on queries.
You would need to build a query, based on the table, and using a criterion
for the date that "points" back at the newly added control on the form.
When that query is correctly returning the data you want in your report, you
would change the source of your report to be the query, not the table.

Then, when you clicked the button that runs the report, the report would
open, look to the query, which would look to the form for a date, then run.
 
If you put this you can press enter w/o data in the box and it defaults to al of the data

Between Nz([Select Date (Begining Date)],[FieldName]) And Nz([Select Date ( Ending Date)],[FieldName]
 
Back
Top