Date Function Issue

[boblarson]

About the only thing left would be to see the db itself.

 

[Rich]

You shouldn't and don't need to store what is just a calculated field, a query or calculated control will give the correct result

 

[lk2827]

Hi Bob,

It wont allow me to upload it. It says failed. Can I email it to you. If so whats your email

Thanks

 

[boblarson]

Did you first follow these instructions closely:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[lk2827]

Sorry I took so long to reply.

I have attached it. Please could you have a look at it and let me know where I am going wrong.

Thanks again for all your help.

 

[boblarson]

Okay, here's the stuff:

1. The function was wrong (sorry about that, that is my fault - the part of [Last Test Date]) should have been dteDate.
2. You can't have the controls and field names named the same when doing calculated fields. Access gets confused.
3. You had the function in the wrong control. I needed to be in the NEXT TEST control and not the Frequency control.
4. the function was called incorrectly. You just need to pass the field names in brackets.
5. You had criteria in your query of [monthly] OR [Monthly] which the brackets mean to Access, in that case, to prompt the user for input. If you had wanted to select only the monthly values then it would have been "Monthly" in quotes (and it is case-insensitive).


See attached.

 

[lk2827]

Thanks Bob, it works fine nice one. Cheers Lee