Date / Time

[Richard]

Hi

This is my first attempt at using access and I am presented with the
following situation. I have a table called Trades with a field for each
record called TRADE DATE/TIME, which shows data in the 24/06/2009 13:26:09
format. I can easily create a query to return the data I need for a specific
date or range of dates, however I have been asked to provide a report for a
range of dates, where the time is after 15:59:59 on each specific date.

Can you please advise how best to acheive this.

Thanks Richard

 

[Richard]

sorry for waisting anyones time I solved it using a field of:

Expr1: Mid([Trades]![TRADE DATE/TIME],12,2)

and then >15 as the criteria

 

[John Spencer]

For future reference you can use the TimeValue function to strip out
just the time from a date time value

Expr1: TimeValue([Trades]![Trade Date/Time])

and then criteria of

=#16:00:00#

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

sorry for waisting anyones time I solved it using a field of:

Expr1: Mid([Trades]![TRADE DATE/TIME],12,2)

and then >15 as the criteria

Hi

This is my first attempt at using access and I am presented with the
following situation. I have a table called Trades with a field for each
record called TRADE DATE/TIME, which shows data in the 24/06/2009 13:26:09
format. I can easily create a query to return the data I need for a specific
date or range of dates, however I have been asked to provide a report for a
range of dates, where the time is after 15:59:59 on each specific date.

Can you please advise how best to acheive this.

Thanks Richard