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?
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

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:38 pm
Powered by Dreamwidth Studios