Search results

Whenever i try to enter that into the "Before Update" box for the "End Date" field, I get this error message: "The expression you entered contains invalid syntax. You may have entered an operator, such as the + operator, in an expression without a corresponding operand" What do I do now? I...

Thanks, that was perfect I knew there was an easy way :D Rob

Hey all, I'm currently writing a query that is meant to display a list of all properties that were being rented within the last 24 months. However, the closest I can get to writing any kind of suitable criteria is this: >Date()-(24*28) I'm sure there is a better way to write this out -...

Just to stop the confusion, that is meant to say: >[Start_Date] Also, don't get confused - the fields are called 'Start_Date' and 'End_Date' (I just didn't include the underscores in my description of the problem. Rob

Hello all, I'm having a situation with a form that I believe can be solved easily with some kind of validation code (I assume created with the expression builder). There are two specific fields I am focusing on - a 'Start Date' and an 'End Date'. Both are short date format, and so accept...

Yeah, at the moment. Although, if it can be done in forms, I might be able to work around it. If I were to do this kind of validation in a form, how would I do it? Rob

Clueless Newb - needs help with Date fields Hey all, I'm constructing a database in Access for a project, and I'm stumped as to how to get two date fields to work with each other. The layout is as follows (you'll probably think this is simple) : I have a "Agreement Starts" date, and an...