Using > with an inoutbox

[bibbyd01]

Hi All



I think this might be the easiest question all year

I have a query where I want to select all data over a certain amount of days, so I used >30 on the query.

I want to change it to give the user a choice, so in the query I now have =[insert days] to give the popup box but I can't get it to work with the >. What rediculously easy thing am I missing?

[Robeen]

Try this in your criteria row for the date field:

>DateAdd("d",[Enter # of Days],Date())

I entered -30 and got back only records with a date more recent [greater] than 30 days ago.

Hope this helps!

[bibbyd01]

Hi

This works but I guess I didn't explain myself too much

The days isn't based on a date, but an integar. So the days are just entered in

[bibbyd01]

Just figured this out

I used

>([Enter # of Days])

[Robeen]

Glad you were able to figure it out!! Mark the post 'Solved' [in 'Thread Tools' up top] if your question has been solved.
All the best!!