Query Parameter Prompt for >=

G

Guest

I have a query in which I'm trying to set a parameter prompt on a calculated
field called "Weeks Since First E-Mail." This would allow the user of the
query (and the report it's linked to) to call up records for a specified
number of weeks back. In the criteria row I've entered

<= [Enter Number of Weeks]

and my results, while filtered in some un-ascertainable way, don't comply
with the range I've specified. There are no "or" statements in the query, and
when I enter fixed criteria in its design (e.g. <=3) the proper records
display. Any ideas?? Thanks in advance!

Alex
 
P

pietlinden

post yoru SQL statement. Did you use a DateDiff function to get the
actual number of weeks between the two dates?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value in Crosstab Query 4
Parameter Query to filter dates as entered in and if not to show N 4
parameter with iif statement in query criteria 8
Parameter Query multiple criteria help 6
Parameter Query No Results - Needs to Auto Create Record 4
crosstab parameterized query 1
Parameter Query Lookup 2
Using Prompt with a "like" query parameter 2

Top