Partition function with time-type arguments

I cant' copy with mayby a simple question of how to use Partition
function with time-type arguments. I would like to group data based on
[timeCol] column which shows time detailed down to the second
'hh:mm:ss' using partition(col,start,end,interval) function for groups
with time from 9 AM to 5 PM (17:00) every 30 minutes. I entered
something like this to the project grid in A2000:

new filed name: Partition([timeCol];#09:00:00#;#17:00:00#;minutes(30))
or
new filed name: Partition([timeCol];#09:00:00#;#17:00:00#;#00:30:00#)
but that isn't working.
How should it be done properly ? Sorry, but I don't know a thing about
time arguments in A2000.

Thanks
Tom
tom [ Mi, 09 Januar 2008 20:21 ] [ ID #1903600 ]
Datenbanken » comp.databases.ms-access » Partition function with time-type arguments

Vorheriges Thema: Problem with TransferText
Nächstes Thema: Help with Import from Excel Spreadsheet