Needing some help with Parameters

[djclntn]

I have a query which contains a Date/Time Field. I want to have the query open up asking me for a ‘StartDate’ & an ‘EndDate.’ The Date/Time Field is entitled, “TDate.” So I simply open the query in Design View, open up the Query Parameter window; on the first line I put “StartDate” & on the second line I put in “EndDate.” I set both Parameters Data Type to Date/Time, ran the query, I when I type in two dates (Start & End Date) in return I get ALL of the dates/Records can anyone please tell me what I might be doing wrong.


Thanks in advance

[pbaldy]

Doesn't sound like you added them to the criteria line in design view:

Between StartDate And EndDate

[djclntn]

Never mind. I first Goggle searching for "Setting Parameters in Access" but I then used Access help & found how to be set up the 2-Parameters I needed. In my opinion, I find "Access Help" to be useful sometimes & sometimes not.

[djclntn]

Right PD, I did that now & it worked. I don't understand when the Query is in Design View there's a Query Parameters window where I thought you use when you want to create Parameters, but it didn't work. This "Query Parameters Windows" might not be on older versions of Access. Thanks for responding, pd ... dj

[pbaldy]

It is in previous versions, but it is just where you can explicitly declare them. You still have to put them in the criteria row so Access knows which field(s) to apply them to, and how ( =,>,<, etc).