Weekday Name

B

Bill

Hi,
I have a numbers Query which when run returns the date & game the number was
picked. What I would like is add a column to my Query results that will show
the Week Day Name. My SQL view of the Query is enter at the end. Can someone
show me what I need to make that happen?

SELECT DlyNumbers.gmDate, DlyNumbers.gmGame, DlyNumbers.gmFirstNumber,
DlyNumbers.gmSecondNumber, DlyNumbers.gmThirdNumber
FROM DlyNumbers
WHERE (((DlyNumbers.gmFirstNumber)=[1st Number]) AND
((DlyNumbers.gmSecondNumber)=[2nd Number]) AND
((DlyNumbers.gmThirdNumber)=[3rd Number]))
ORDER BY DlyNumbers.gmDate DESC;

Thanks,
Bill
 
D

Douglas J. Steele

Use Format(DlyNumbers.gmDate, "dddd") to get Monday, Tuesday, ..., or
Format(DlyNumbers.gmDate, "ddd") to get Mon, Tue, ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top