Search results

hi.. Will let you know Pos,

Hi, Just of a matter of interest if you have a gap in any part of the field expression would this cause the criteria expression not to work. This is the full expression in the field of the query, ie Visual Next Service Date: DateAdd("m",[Formal visual frequency],[Formal Visual...

Will close this now as its gone on to being a query question Cheers Pos,

Hi all, I have enter an expression in the field of an expression Visual Next Service Date: DateAdd("m",[frequency],[LastServiceDate]) When i enter a date calculation..<DateAdd("m",0,Date()).. in the criteria i get an error message.. works fine in access 2002 but i need it in 97 any top...

Hi again, Again a big thankyou but I need some more help... The problem is the calculations work brill in access 2002 ..But when i convert it to access 97, need to use it at work and they are not up todate, the calculation in the critea field causes an expression error... I've tried lookin in...

Hi, Well a great big thankyou goes to everyone helping me... It worked, a simple conclusion.. Learnt laods doin this and I now know where to come. Again Thanks

Hi, Hi there, Thanks for answering.. ...Will try to explain why i need what , i hope simple terms.. I service a large amount of equipment. I need to find out each month what is due to be done or I get it in the neck.. I have in the table A The last time I did it B interval of servicing C...

Here u go..this is the query sql SELECT [All of MCF].[Unit Serial number], [All of MCF].[Site (General Location)], [All of MCF].Location, [All of MCF].Position, [All of MCF].[Item Description], [All of MCF].[Formal Visual NextServiceDate], [All of MCF].[Combined Inspect & test NextServiceDate]...

Hmm Both the inputs in the calculation vary from record to record.. i have put the calculation into a query but did not give the result needed.. Could anyone give me a top tip in the code i need to write in afterupdate Ta Pos,

Hi, Can anyone please help, this is doin my head in.. I have a calculated date field on a form... can i send this information to tha main table... i've tried all sorts. the calculation is =DateAdd("m",[Combined Inspection and test frequency],[Combined Inspect & test LastServiceDate]) and i...