query with next hundred days

[denny]

i would like a query (or table) that when run all it does is list todays date and the next 100 days.



09/05/2011
09/06/2011
09/07/2011

etc

how would i do this,
thanks

[ajetrumpet]

why do you want it? asking because more than likely, the reason you want it is not legit. thus, another method to get to the gold at the end of the rainbow here would make more sense.

[NTC]

in the criteria of your query you simply have to put the two dates to make a date range

first step is to do it manual & fixed:
>=9/1/11 AND <= 12/1/11
see if that works ok as a sanity check

then modify it to make it dynamic
>=Now() AND <=Now()+100

Now() will include time stamps, not just date. Depending on the field properties this can alter the results. So you will want to modify this code with FORMAT or consider using Date() ; I haven't done this in awhile and this isn't exactly precise code but should put you on the right path.

Hope it helps.