ulteriormotif
Technical User
While I still have some hair left, could someone give me a pointer on this one, please.
I have a simple union query used to add an 'all' option a list of dates in a combo box:
SELECT Date
FROM [DAT - Payments Total]
GROUP BY date
ORDER BY date
UNION SELECT "*"
FROM [DAT - Payments Total];
Works great in that respect, but the problem is that the dates then seem to be recognised as text and sorted as such, with the result that my date list looks something like:
*
10/03/2004
10/05/2004
12/03/2004
12/05/2004
14/04/2004
15/04/2004
16/04/2004
18/03/2004
19/03/2004
I really need the dates to sort as dates, not text. Any suggestions?
Fairly new to working in the SQL side of Access, so hopefully there's some simple qualifier or something that I just haven't come across yet.
I have a simple union query used to add an 'all' option a list of dates in a combo box:
SELECT Date
FROM [DAT - Payments Total]
GROUP BY date
ORDER BY date
UNION SELECT "*"
FROM [DAT - Payments Total];
Works great in that respect, but the problem is that the dates then seem to be recognised as text and sorted as such, with the result that my date list looks something like:
*
10/03/2004
10/05/2004
12/03/2004
12/05/2004
14/04/2004
15/04/2004
16/04/2004
18/03/2004
19/03/2004
I really need the dates to sort as dates, not text. Any suggestions?
Fairly new to working in the SQL side of Access, so hopefully there's some simple qualifier or something that I just haven't come across yet.