Query; >= Date/Time

[pr4t3ek]

Hi,
I have a database.

The database holds the following four fields:

Please Login or Register  to view this content.

I would like to see all the data which was created after 01/03/2009 7pm.

In an access query, if I put:

Please Login or Register  to view this content.

the only problem is that it only shows me data created after 7pm any day after 01/03/2009....

I dont want this, i want to see "all" data created after 01/03/2009, 7pm..

any ideas?

[pr4t3ek]

okay, this is unresolved..

does anyone have any solutions?

thanks.

[ConneXionLost]

How did you gather/enter the data for the "Created" and CreatedTime" fields?

If you used the =Now() function as a default value, then you may be in luck. Just format one of your field as:

"yyyy mmm dd - hh:nn:ss"

[pr4t3ek]

nope...

i import a text file which contains that data and then i was just wanting a query to show me all the ones created after a certain date/time..

One solution i have is:
One query: This gives me anything created on 01/03/2009, after 7pm..
Second Query: This gives me antyhing created on and after 02/03/2009.
Third Query: Union Join Query One & Two... this gives me what i need..

but im wanting to do all of that in one query, there HAS to be a way!

[pr4t3ek]

i just figured it out.. omg, the most n00b question i've ever asked

SQL code as follows:

Please Login or Register  to view this content.