Jippiii I made it.... The thing is... my 'Reg Date' in my table had to be both a date and a time due to some other tasks in the database.
But now I need to filter out some reckords with one perticular date.... So if I wrote in the Query Criteria: [Date_txt]=DateValue([Reg Date]) .... then it's working. DateValue strip of the time values, so then I'm left with the pure date value, equal the 'Date_txt' from the form box. The form box is a visable box, I can update. Then after update do the code: Me.ReckordsToday_Liste.Requery Stein --- In [EMAIL PROTECTED], "Richard" <[EMAIL PROTECTED]> wrote: > 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=12hb77nkn/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124664544/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</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/
