Data with DateAdd

[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.

 

[Steve]

I aasume your unbound box is on a form and you want to enter 8/26/09 in the
box. Put the following in the criteria of your date field:

Between Forms!MyForm!NameOfUnBoundBox And Forms!MyForm!NameOfUnBoundBox

Actually you don't need the Between And expression for a single date. Just
use the following for your criteria:
Forms!MyForm!NameOfUnBoundBox

Steve
(e-mail address removed)

 

[BruceM]

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]

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?

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

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.