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 Jul. 24th, 2017 10:42 pm
Powered by Dreamwidth Studios