Try using the function Date() instead of Now() - Date() will return today's date without the time (as Now() does).
Hope this helps! Alienwebmaster --- In [EMAIL PROTECTED], Øystein Frostad <[EMAIL PROTECTED]> wrote: > I try to make a query that's finding all reckords today from a table. > But the table field e.g 'Reg Date' must be a Date/Time General date now > () "21.08.2005 12:03:50" > > So is it possible to make a query on todays reckords with a text date > box from my form only with the string "21.08.2005" that I put into the > criteria like: [Data now] ????? > > Stein ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hif38dv/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124663127/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
