Adding a column for DAY in my Query

[derek7467]

Hey guys, im attempting to run a query and i return the below data:



ID | % of calls answered | Date | Sunday |Monday...etc

Currently, i return:

jdoe | 80% | 7/1/2013

I need to know how to return a specific day in another column with that days stats like below:

jdoe | 80% | Sun
jdoe |75% | Mon
...etc

[derek7467]

Is there an expression i could use?

All i want to do is turn that date into a day

Im offering a bounty for this.

35$ to anyones paypal account who gets this working for me!

[derek7467]

seriously, 58 views and not one response?

[ketbdnetbp]

derek7467 -

Search access/vba help for User Defined Date/Time Formats (Format Function).

In the query, you could try something like...

xDay: Format([NameOfYourDateField],"dddd")

All the best,

Jim