Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / July 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kev100 - 10 Jul 2006 21:40 GMT
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/Forum.aspx/access-gettingstarted/15417/Query-fo
r-Records-AFTER-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/Forum.aspx/access-queries/33188/DEFAULT-Value-i
n-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
kev100 - 10 Jul 2006 22:07 GMT
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())))

....works fine.

Please pardon the clutter.

Thanks very much...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.