L
Lisa
Hi,
I am new to Access and working with a database I did not create. In the
database there are 3 separate columns for the date- Day, Mon, and Yr. I
would like to be able to include in my query a field that combines these
three columns into the date format that I want (e.g. 18-Apr-2007).
I can't figure out where this falls in terms of queries, as I am not
calculating anything- I just want them to show up together in one column in
the query, in that format.
So ultimately I use the query to generate labels in a program called
Bartender. I tried just including each column separately in the query, but
when I pulled the info into Bartender my day and years had decimals (2007.0).
Couldn't figure out what was up, since in my Access columns they look
normal. I didn't know if this is a Bartender or an Access problem, or how to
tell.
I suspect that the guy who created the database used some code to accomplish
this.
Can anyone help??
Thanks!
Lisa
I am new to Access and working with a database I did not create. In the
database there are 3 separate columns for the date- Day, Mon, and Yr. I
would like to be able to include in my query a field that combines these
three columns into the date format that I want (e.g. 18-Apr-2007).
I can't figure out where this falls in terms of queries, as I am not
calculating anything- I just want them to show up together in one column in
the query, in that format.
So ultimately I use the query to generate labels in a program called
Bartender. I tried just including each column separately in the query, but
when I pulled the info into Bartender my day and years had decimals (2007.0).
Couldn't figure out what was up, since in my Access columns they look
normal. I didn't know if this is a Bartender or an Access problem, or how to
tell.
I suspect that the guy who created the database used some code to accomplish
this.
Can anyone help??
Thanks!
Lisa