data based on Date

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Helo,
I have report based on Table. The table has records for everday. Wat sould I
Write in Date field on Report so that I get Report for perticular Date?
 
Andy,

You will need to base the report off of a query. Then In the criteria of
your date field type =[Enter a date (mm/dd/yyyy):] I would put the format
there just so Users know how you want the date entered. This will prompt
Users to enter a date and the report should return the results.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Andy said:
Helo,
I have report based on Table. The table has records for everday. Wat sould I
Write in Date field on Report so that I get Report for perticular Date?
Click to expand...

I think there are probably two main ways of doing this.

One is to create a simple form to launch your report. Base your report
on a Query (rather than directly on the table) and include a criterion
in the query which refers to a control (e.g. text box) on your form.
The advantage of this is that you can check for invalid dates before
running your report.

If you want an easier way, try using a "parameter query". Base your
report on a query again, but for the criterion just put
[Enter date here]
in the query builder. When the query runs, it won't recognise that
expression, so will pop up a dialogue box asking for the data. Enter a
date, and you're done! Here's a neat description:

http://www.fontstuff.com/access/acctut01.htm

HTH

Phil, London
 
Helo,
I have report based on Table. The table has records for everday. Wat sould I
Write in Date field on Report so that I get Report for perticular Date?
Click to expand...

You don't write anything in the date field on the report.

Simplest way is to create a query that returns all the fields needed
in the report.
Than as criteria on the date field in the query, write:
[Enter the date in mm/dd/yyyy format]

Make this query the record source for the report.

The user will be prompted to enter the date.
Enter the date like
03/09/2009
 
Back
Top