Kitty_Kitty
New member
- Local time
- Today, 15:59
- Joined
- Oct 23, 2006
- Messages
- 3
Hi there,
I am currently altering a database for a large uk campaigning company.
People pay fund by DD each month, I need to run a query to extract the monthly DD people, and extract the DD's that are due this month. Then run an update query to add a month onto the membership renewal date.
I have done this query but it doesn't seem to want to play ball:
UPDATE [zz dd current month] SET [zz dd current month].[Date Joined] = DateAdd("mm",1,[date joined]);
When I run it it claims it fails "due to a type conversion failure".
Can anyone tell me what that might mean and point me into the right direction to reactifying it? I am still fairly new to access.
Thank you,
Cathy
I am currently altering a database for a large uk campaigning company.
People pay fund by DD each month, I need to run a query to extract the monthly DD people, and extract the DD's that are due this month. Then run an update query to add a month onto the membership renewal date.
I have done this query but it doesn't seem to want to play ball:
UPDATE [zz dd current month] SET [zz dd current month].[Date Joined] = DateAdd("mm",1,[date joined]);
When I run it it claims it fails "due to a type conversion failure".
Can anyone tell me what that might mean and point me into the right direction to reactifying it? I am still fairly new to access.
Thank you,
Cathy
