Search results

Hey I am very greatfull for what you have done, thankyou so much, this morning i worked out another solution and it worked as well <Now()-90 and i did that by myself I'm a big boy now Thankyou very much bob craig

it's 552KB could i send it via Messanger if at all possible mate

Changed it to short date and input mask of 00/00/0000;0;_ but the ssame error message comes up sorry for this stupid question

Done that but then it says the same message and puts quotes back on "Date"

Date/Time, Long time

IIf(DateAdd("m",3,[MeetingDate])<"Date","Needs Meeting","No Meeting Necessary") this is what i am inserting i should curl up into a ball and cry

Right my fieldname is called MeetingDate in the meetings table so i enterd the field name in wher it says to, but then this message came up Data Type mismatch in criteria expression sorry for being a complete noob

Its now asking for a meeting date, all i need it to do is list the clients who have not had a meeting in the last 3 months really really sorry if i'm starting to get on your nerv thanks again Craig

Yeah, i have put in a query their surname and meeting date, would i need to put that criteria in that date criteria box or just in the next empty space sorry for acting dumb

Thanks but Thanks bob But i need the clients who have not had a meeting arranged for over three months, if that makes any sence here is the question that was asked " Report lsiting all clients who have not had a meeting arranged for more than three months" Thanks Craig

Hey I need to find Customers who have not had a meeting for over three months and i need to list them in a query, please could someone help me as this is getting very frustrating