I'm trying to get my sales tax query to pull startdate and enddate from a taxdate form. I have a field, PaidDate, which will take >=[startdate] and <=[enddate] as criteria. It works, but I want a more elegant weapon from a more civilized age, so I made the taxdate form, with two fields, startdate and enddate. I tried passing between forms]![taxdatef]![startdate] and forms!taxdatef]![enddate] in PaidDate. I get no records. I tried using >= and <= instead of between. I get no records. I tried plugging in PaidDate twice, aliasing them as QtrStart and QtrEnd, using >=startdate from the form and <=enddate as criteria for the two fields. I get no records. Am I missing something, or is this not possible?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 15.