Kevin Field
Registered User.
- Local time
- Today, 03:26
- Joined
- May 26, 2010
- Messages
- 35
Okay, this one is driving me nuts.
I want to combine two fields in a query to create a unique ref which i already have created in another table. The format is this:
AdviserCode&ReviewMonth&ReviewYear
This gives a ref of i.e. CJW082010
However, i also have a query above which needs this ref as well. I have tried to combine two fields AdviserCode and Review Short Date (which is formatted as mm/yyyy. In the table, the date appears as this however when you try and run the query with the joined field(s) it seems to ignore the date formatting and puts in the full date i.e. 21/08/2010 when all i actually want is the mm/yyyy. Is there any way to stop this happening?
Can i format the date in the query? I am confused.com
I want to combine two fields in a query to create a unique ref which i already have created in another table. The format is this:
AdviserCode&ReviewMonth&ReviewYear
This gives a ref of i.e. CJW082010
However, i also have a query above which needs this ref as well. I have tried to combine two fields AdviserCode and Review Short Date (which is formatted as mm/yyyy. In the table, the date appears as this however when you try and run the query with the joined field(s) it seems to ignore the date formatting and puts in the full date i.e. 21/08/2010 when all i actually want is the mm/yyyy. Is there any way to stop this happening?
Can i format the date in the query? I am confused.com
