Append Query

[kkyork]

I was wondering if it was possible to run an append query to add the day of the week to a table which already contains a date. In other words, my table has dates in January through May and I'd like to add a column which lets me know what day of the week that specific date is (Mon, Tues, etc). Let me know if you have any ideas.



Thanks!

[Robeen]

Does it HAVE to be an append query?

You don't HAVE to actually add that one field to the Table - you can just create a query with all the fields from the Table PLUS an extra field that tells you the day of week for each date.
You can then use the query in pretty much the same way as you would use a Table [since they are both'data sources'].

Then, if you really need to - you can turn the query into an append query.

Let me know how you want to proceed.

[Robeen]

In your query, in Design View, add a field like this:

DayOfWeek: WeekdayName(Weekday(Your_Date_Field))

Again . . . if the query gives you the results you need - you can always convert it to an Append Query to write the data to a Table.
BUT . . . you don't HAVE to put a derived [calculated] value into your table when your query will provide it for you whenever you need.

Hope this works for you.