Scott/NeoPa
Thank you both for your wisdom over the last few days
I feel quite sheepish now though, the final step that fixed the error on my database in the query was the compact/repair.. (that is using the CVdate)
I did say i was a bit of a novice.. but im a little frustrated i didnt even cotton onto a menu command...
hopefully this will be of some use to someone else though
...
anthonyk
Last Activity: Mar 25 '08, 09:24 PM
Joined: Mar 16 '08
Location:
-
right then,
Thank you ever so much for your help thus far..
I can report..
the date format from visual basic is dd/mm/yy
Im in the UK
using Access 07
On a new database - the CVdate thing works with a criteria. so that appears to be that problem solved! Cheers for that!
however on the database i'm working on it doesnt ("rolls eyes") - i can only presume...Leave a comment:
-
hiya,
yeah thats exactly what i was doing - so just tried and still gives me an error.Leave a comment:
-
Hi there,
Thaks for your help so far.. Im gonna be honest my SQL knowledge - you could write on a postage stamp...
Here is the Sql code from my query where it calculates the end date accurately
...Code:SELECT [Tbl Projects].[Projects Code], [Tbl Projects].[Project Type], [Tbl Projects].[Region], [Tbl Projects].[Start Date], [Tbl Projects].[Duration (mths)], [Tbl Projects].[Cost], DateAdd("m",[DurationLeave a comment:
-
Dateadd criteria problem
Hi there, im hoping someone might be able to painlessly tell me what im incorrectly doing here/expecting.
Im using Access 2007
I am creating a query to show ongoing tasks in a database.
in the fields I have
Start date (dd/mm/yyyy)
Duration (months)
Basically i want the query to calculate is if start date + Duration is greater than today...
so ive used
Dateadd("m",[duration],[start...
No activity results to display
Leave a comment: