Access database

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

Guest

I am trying to recreate a database where my employees can track truck rolls.
I have the table all set and the form working. However I want to set it up to
pull reports but a certian day. Is this possible?
 
Hi

Yes it is.

Create a new query and bring in the table(s) you want to run the report from.
I assume there is a date field in the table.
In the query - the date column could prompt users for the date you want to
report on.
Add this the criteria row (of the date field column)

[ Enter date of report ]
You can change the wording if you want

Save the query.
Go into the the report and use this new query as the data source (open the
properties box and you will see the data source in the Data Column)

Now when you run a report from you form the user will be asked for the date
before the report prints/views

Hope this helps
 
Wayne,

That helped some, I am still working on it. I have another question you
might be able to answer. Once I have the database setup the way I want it.
Would there be a way to prevent the form from showing the prior entries.
Maybe as a web page or a window just to enter the information?
 
Wayne,

That helped some, I am still working on it. I have another question you
might be able to answer. Once I have the database setup the way I want it.
Would there be a way to prevent the form from showing the prior entries.
Click to expand...

Setting the form's Data Entry property to True will do just that.

John W. Vinson [MVP]
 
Back
Top