form based off parameter query

[Guest]

I sent this problem a few weeks back and thought I had it working, but its
acting up again, so I'll send it again:

I have a form based off a parameter query which asks for an event, then the
start and end date to run a specific report.

In the criteria portion of the event field in the query, I have:
Like [Forms]![frmFilterEventCategory]![cboEvent] & "*"

In the criteria portion of the date field in the query, I have:

Between [Forms]![frmFilterEventCategory]![txtBeginDate] And
[Forms]![frmFilterEventCategory]![txtEndDate]

When I try to run a report from my switchboard (which opens the above form)
it gives me a blank screen. If I take the date criteria out of the query and
run the report, the form opens properly and I can select my event, but then,
of course, the date text fields don't work so I'm thinking it must have
something to do with the way I've entered the criteria in the query? I've
double-checked my spelling, etc. and everything seems to be OK.

I also have the same date criteria entered in the report header so it will
print the proper date span on the report. That seems to print the proper
dates even though the detail info isn't correct.

I've tried deleting the event criteria to see if that changes anything, and
I tried deleting the criteria from the report header, but I still get a blank
screen when criteria is entered in the date field of the query. When I
delete the date criteria from the query, both the form and report opens
correctly, just get wrong data.

Any suggestions?

TIA,
Patti

 

[Guest]

Is your date field a DateTime datatype field?

Does it pull the correct data when you run the query alone?

Post your query SQL.

 

[Guest]

The date field is a DateTime datatype, and yes, the query seems to run fine
alone.
Here's the SQL:

SELECT tblDetails.EventCategory, tblData.LoadDate, tblDetails.DetailsTime,
tblDetails.Description, tblDetails.LoadDateID
FROM tblData INNER JOIN tblDetails ON tblData.LoadDateID =
tblDetails.LoadDateID
WHERE (((tblDetails.EventCategory) Like
[Forms]![frmFilterEventCategory]![cboEvent] & "*") AND ((tblData.LoadDate)
Between [Forms]![frmFilterEventCategory]![txtBeginDate] And
[Forms]![frmFilterEventCategory]![txtEndDate]));

--
Patti

Is your date field a DateTime datatype field?

Does it pull the correct data when you run the query alone?

Post your query SQL.

I sent this problem a few weeks back and thought I had it working, but its
acting up again, so I'll send it again:

I have a form based off a parameter query which asks for an event, then the
start and end date to run a specific report.

In the criteria portion of the event field in the query, I have:
Like [Forms]![frmFilterEventCategory]![cboEvent] & "*"

In the criteria portion of the date field in the query, I have:

Between [Forms]![frmFilterEventCategory]![txtBeginDate] And
[Forms]![frmFilterEventCategory]![txtEndDate]

When I try to run a report from my switchboard (which opens the above form)
it gives me a blank screen. If I take the date criteria out of the query and
run the report, the form opens properly and I can select my event, but then,
of course, the date text fields don't work so I'm thinking it must have
something to do with the way I've entered the criteria in the query? I've
double-checked my spelling, etc. and everything seems to be OK.

I also have the same date criteria entered in the report header so it will
print the proper date span on the report. That seems to print the proper
dates even though the detail info isn't correct.

I've tried deleting the event criteria to see if that changes anything, and
I tried deleting the criteria from the report header, but I still get a blank
screen when criteria is entered in the date field of the query. When I
delete the date criteria from the query, both the form and report opens
correctly, just get wrong data.

Any suggestions?

TIA,
Patti