Data with DateAdd

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

Robbie Doo

Is it possible to break the data down to a specific date?

My report is based on a Between...And date criteria. I'm trying to create an
unbound box to show only data for a specific date. Is it possible?

Example: All the "Hours" between the 1st & 15th that range between 2 to 10,
I only want to see the hours for the 9th on my report.
 
It's a little unclear what you are asking, but if you want data just for a
single date you could have the criteria by either a control on a form, as
has been suggested, or a parameter prompt. For instance, as the criteria
for the date field.
[Enter date]

If you are trying to enter a range for the Hours field, likewise you can
reference controls on a form, or use paramter prompts:
Between [Starting Hour] And [Ending Hour]

If these are fixed values:

Between 2 And 10
 
It's a Report with criteria, using Between [Start Date] And [End Date].
On the unbound text box I wanna be able to retrieve a data specific to a
date, for example. I wanna see the data on my Report 3 days from the [Start
Date] in that unbound textbox, what formula do I use?

BruceM said:
It's a little unclear what you are asking, but if you want data just for a
single date you could have the criteria by either a control on a form, as
has been suggested, or a parameter prompt. For instance, as the criteria
for the date field.
[Enter date]

If you are trying to enter a range for the Hours field, likewise you can
reference controls on a form, or use paramter prompts:
Between [Starting Hour] And [Ending Hour]

If these are fixed values:

Between 2 And 10

Robbie Doo said:
Is it possible to break the data down to a specific date?

My report is based on a Between...And date criteria. I'm trying to create
an
unbound box to show only data for a specific date. Is it possible?

Example: All the "Hours" between the 1st & 15th that range between 2 to
10,
I only want to see the hours for the 9th on my report.
Click to expand...
Click to expand...
 
Back
Top