And all dates before.... (1 Viewer)

[mariaw]

Hi

I have a query that I run which currently picks out everything for the week commencing X, where X is entered.

E.g. when you run the query, it comes up with a dialog box saying "Enter Week Commencing:" - and if you put in 15/10/06, it pulls all of the records that have been put in on that date.

How do I get it to pull all of the records that have been entered on that date, and any date prior to the 15/10/06?

Maria

 

[alastair69]

You could try >#01/10/2004# in your query this will find greater then this date or <#01/10/2004# less then this date.

Just a thought

 

[mariaw]

Hi alastair69

I did think about doing that, but I wonder if there is anyway of having that come up in a dialog box - e.g. so when it says Enter Week Commencing: you can tell it you want it to be the week commencing 15/10/06 and anything before it?

Maria

 

[pot2000]

Make it < [Enter Week Commencing]

Greetings Raymond

 

[AlphaZeroX]

In other words, within the criteria field of the query under that specific Field, change the code from [Enter Week Commencing], to
< [Enter Week Commencing]
NOTE: This will permenantly change the query unless changed back through the criteria field.