Comparing multiple dates and times in a query

[Mikydisco]

Hi there,

I'm trying to 'rank' x5 categories that overlap. To determine the ranking i'm utilising date & time (if the dates are equal). I've managed to do this comparing x2 of the categories but struggling with the logic for x3,x4 & x5 categories

I have the data in separate tables by category date & time and in one large table.

Hoping someone can assist as my head is starting to hurt.

Thanks

 

[DrSnuggles]

Sounds like you need a Bubble Sort on the value returned from a DateDiff.

 

[Mikydisco]

Does the DateDiff function only work for x2 date columns only?
I need to compare up to 5 date columns.

 

[DrSnuggles]

Looks like you're going to have to write a function for this.
Look up Bubble Sort on here or the google.

 

[Mikydisco]

Yep, looks like this will help the cause. Many thanks Dr S!