dreamfired: (Default)
[personal profile] dreamfired
An access question. I have a database with a booking field which has a date based input mask.
I want to run a query based on multiple tables(yes a query not a report) which replaces the date based on the input mask which doesn't include day of the week, with a column displaying day of the week.

Booking= Format(Date(), "dddd, mmm d yyyy") I thought all I had to do was put this in the Field header for the column - but apparently not - it returns an error message

Anyone help?

Profile

dreamfired: (Default)
dreamfired

January 2013

S M T W T F S
  12345
6789101112
131415 16171819
20212223242526
2728293031  

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 26th, 2017 04:19 pm
Powered by Dreamwidth Studios