Weekday Name

  • Thread starter Thread starter Bill
  • Start date Start date
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
 
Use Format(DlyNumbers.gmDate, "dddd") to get Monday, Tuesday, ..., or
Format(DlyNumbers.gmDate, "ddd") to get Mon, Tue, ...
 
Back
Top