Using date on a form in a report

[jmprescott]

I'm back again.

Of course, when I figure out one part of what I need to do, I need to make it better.

I'm trying to add an option to select a date range to report on, but it's not working how I think it should be.

Here's the peice of SQL that relates for my query.

WHERE (PagesHistory.ReviewStartTime) Between ([Forms]![ReportsForm]![StartDateTXBX]) And ([Forms]![ReportsForm]![EndDateTXBX]))

Did I make an error somewhere?

[ChipR]

Try this:
WHERE PagesHistory.ReviewStartTime BETWEEN
Format ([Forms]![ReportsForm]![StartDateTXBX], "short date") AND
Format ([Forms]![ReportsForm]![EndDateTXBX], "short date")

[jmprescott]

Still getting a "Enter Paramater Value" box for the Start and End Date.

I tried displaying the date fields in a text box on a report, and it came up as "#Name?"

For what it's worth, here's the entire query:

SELECT Roles.LastName, PagesHistory.ReviewStartTime, PagesHistory.ReviewEndTime, DateDiff("s",[PagesHistory.ReviewStartTime],[PagesHistory.ReviewEndTime]) AS TimeSpent
FROM PagesHistory INNER JOIN Roles ON PagesHistory.RoleID = Roles.ID
WHERE (((PagesHistory.ReviewStartTime) Between Format([Forms]![ReportsForm]![StartDateTXBX],"Short Date") And Format([Forms]![ReportsForm]![EndDateTXBX],"Short Date")) AND ((PagesHistory.ReviewEndTime) Is Not Null) AND ((DateDiff("s",[PagesHistory.ReviewStartTime],[PagesHistory.ReviewEndTime]))>0));

Do I need to join anything to pull data from forms?

[ChipR]

What's the source you're using for the text box on the report that shows #Name? Something is wrong in the way your are trying to point at the form data, but it could be anything from the name of the box being misspelled to the form not being open at the time.

[jmprescott]

Yeah I don't really get why it's not working in the text boxes in the report

=Format([Forms]![ReportsForm]![StartDateTXBX],"Short Date")

is what I'm using

[ChipR]

Try in the immediate window
? Format (Forms!ResportsForm!StartDateTXBX, "Short Date")
or put a button on your form and have it do
MsgBox Format (Forms!ResportsForm!StartDateTXBX, "Short Date")
and see what you get. I suspect that something is simply being referred to by the wrong name.

[jmprescott]

Another bonehead mistake on my part lol

I used your idea of throwing in a msgbox and it told me that ReportsForm didn't exist... which I know it does!

...it's a subform of a form I wasn't including in the command >.<

Anyways, problem solved, thanks again, ChipR!