Show Rec's AFTER certain Time AND Date WITH Default Date Entry....

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date Start date
K

kev100 via AccessMonster.com

Last week....I'd gotten some GREAT help with 2 items....

Showing all records AFTER a certain Time on a SPECIFIC Date....

http://www.accessmonster.com/Uwe/Fo...ER-Certain-Time-on-a-Certain#62cede15d47abuwe)


(The solution was adding >DateAdd("d",1,[Enter date...]) on the line below
[Enter date] in the criteria)


and.....


Inserting the current data by Default if nothing is entered...

http://www.accessmonster.com/Uwe/Fo...a-Query-PROMPT-Criteria-type#62d8bdc2cf5bduwe


(Solution was: Nz( [Enter Date (press Enter for today)], Date()) in the
criteria line)


HOWEVER...after combining the 2 in the criteria lines....

Line1: Nz([Enter Date (press Enter for today)],Date())
Line2: DateAdd("d",1,(Nz([Enter Date (press Enter for today)],Date())))

....The Query will run.....and it will use the current date when the user
enters nothing...
....but it will only display the records for the CURRENT day (after the
specified time).....it will no longer display records created on any Date
AFTER the current date (handled by Line2).


I've tried chaning the number of parentheses, etc...and a few other tweaks....
..but can't seem to get it working.

Any suggestions greatly appreciated.
THANKS
 
Sorry folks....I didn't try enough and posted too soon....


Looks like I simply left off the preceeding ">" when the modification was
made...
DateAdd("d",1,(Nz([Enter Date (press Enter for today)],Date())))
Click to expand...

.....works fine.

Please pardon the clutter.


Thanks very much...
 
Back
Top