Date / Time

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
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
 
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#
Click to expand...

'====================================================
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

Richard said:
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
Click to expand...
Click to expand...
 
Back
Top