Search results

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 -...

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...

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...