Date Paramater prints weird

[NOTLguy]

Good day,

I have created a report from a query that has two parameters. They represent [Enter Starting Date] and [Enter Ending Date] to make the report quarterly. The parameters are of Date Type. In the report header I included the following in a text box:

="Covering Period Starting" & [Enter Starting Date] & "To" & [Enter Ending Date]

When I run the report, the dates appear differently to each other.

Covering Period Starting 07/01/2010 To 30/09/2010

Any thoughts as to why and how to correct the second date?



Thanks
Bill

[slave138]

Almost looks like Format was used on the 2nd date. If you run the underlying query, is it displayed the same way?

[weekend00]

Maybe you entered "07/01/2010" and "30/09/2010", so the report show exactly what you typed in ?

[NOTLguy]

Almost looks like Format was used on the 2nd date. If you run the underlying query, is it displayed the same way?

I ran the underlying query with the parameters as follows:

Enter Beginning Date 09/01/10
Enter Ending Date 10/19/10

The SQL for the query is as follows:

PARAMETERS [Enter Beginning Date] DateTime, [Enter Ending Date] DateTime;
SELECT Hours.HoursId, Hours.ClientID, Volunteers.FirstName, Volunteers.LastName, Hours.FacilityID, Hours.CodeId, Hours.Minutes, Hours.VolunteerID, Codes.Description, Codes.Title, Hours.Date, Round(([minutes]/60),2) AS Expr1, Codes.PrimaryCode, Codes.SecondaryCode
FROM Codes INNER JOIN (Volunteers INNER JOIN Hours ON Volunteers.VolunteerID = Hours.VolunteerID) ON Codes.CodeId = Hours.CodeId
WHERE (((Hours.Date) Between [Enter Beginning Date] And [Enter Ending Date]));


The field Hours.Date is a data type Date/Time

Bill

[slave138]

I'll admit I don't usually use parameters in a query like this, but when I try to replicate the code I don't get any output for [Enter Beginning Date] or [Enter Ending Date]. So how are you pulling that info into the report?

[NOTLguy]

I'll admit I don't usually use parameters in a query like this, but when I try to replicate the code I don't get any output for [Enter Beginning Date] or [Enter Ending Date]. So how are you pulling that info into the report?

In the report Header I have a Text Box with the control source being:

="Covering" & [Enter Beginning Date] & "To" & [Enter Ending Date]

The report is built using the query.

Bill

[slave138]

I guess I would have to see it in action because I can't replicate the problem as it is described.

[NOTLguy]

I guess I would have to see it in action because I can't replicate the problem as it is described.

I am using Access 2002. Does that mean anything in this regard?

Bill

[slave138]

I am using Access 2002. Does that mean anything in this regard?

Bill

Shouldn't matter in this case.

[LillMcGill]

That is a weird problem. If I were you, I'd try renaming the field Hours.Date... something besides "Date". Date is a reserved word and should not be used as a field name.