Between Dates From a Form

[rutkus]

hey,

i have a form(with 2 unbound textboxes asking for beg and end dates) that sets the criteria for a crosstab query(which defines a report).

In the query i setup a new field with the same field name as the column heading, from there i added a WHERE clause and in the criteria i typed this:

Between [Forms]![ReportParameters]![BegDate] And [Forms]![ReportParameters]![EndDate]

this is the error i got:

The Microsoft Jet Database Engine does not recognize '[Forms]![ReportParameters]![BegDate]' as a valid field name or expression

I was thinking maybe i have to open the form before the query opens, so that itll find the textboxes, but i can also see how that wouldnt be necessary (i have default values already set, so it should find a date range). Then i also thought maybe i have to make a table for the textboxes, so that the query can get the info off that, but that also seems a bit unnecessary.

so if anyone has encountered this and knows what i should be doing, any and all help would be greatly appreciated.

thanks
Omar Qureshy
HI-Tek

 

[Databaseguy]

The form should be open when you run the query. The text boxes do not have to be bound to an underlying table. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[JoeMiller]

Not to be rude, but do you have a form named ReportParameters??? Joe Miller
joe.miller@flotech.net

 

[Databaseguy]

Good point Joe.

One should remember not to name objects after reserved words and/or built in objects.
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Guest_imported]

This is a wierd thing with crosstab queries. I remember seeing something about it awhile ago, but I don't remember where. What you have to do is this:

Choose Query->Parameters from the menu. For each of the parameters that is giving you the error, you need to stick the full name in the left hand side of the column and the data type in the right hand side.

Once you do this, you will no longer get the error.