Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open by date 1

Status
Not open for further replies.
stephie

stephie

Technical User
May 29, 2002
10
0
0
US
How can I set my report to open by specific dates? I would like a prompted box asking me what dates to and form that will be on report. It has been so long since I have worked in access.
 
Sort by date Sort by votes
Base your report on a query that has your date field in it. Make parameters like [from_date], [to_date]. Your date field will be >= from date and <= to date. You will get prompted for dates when you run the report.
 
Upvote 0 Downvote
Yes you can in ur query in the &quot;CRITERIA&quot; section enter the following [Please enter date] or u can enter anything u want in between the brackets... or if u want to select between a starting date and an end date add this in the &quot;CRITERIA&quot;

Between [Starting Date] And [Ending Date]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
90
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
187
caykamanj1966
caykamanj1966
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
67
sxschech
sxschech
misuser2k7
  • Locked
  • Question
Hide date textboxes on report 1
Replies
4
Views
54
misuser2k7
misuser2k7
integritycare
  • Locked
  • Question
Hi, I need to put the date in the
Replies
11
Views
65
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top