tech advice
Jan. 21st, 2010 11:37 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
dreamfiredAn 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?
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?
