I think what your looking for is the datediff function here are a couple of
links
http://www.techonthenet.com/access/functions/date/datediff.php
http://office.microsoft.com/en-us/access/HP010984861033.aspx
This will allow you to calculate the number of days between to dates
LastMowDate: DateDiff("d", [MowDate], Date()) (I think I have right format
best to check) then you can set the criteria in your query to only select the
answers with the correct number of days
Hope this helps
LIsa
Computer Systems Assistant
Center on Budget and Policy Priorities
820 1st Street, NE, #510
Washington, DC 20002
Ph: 202-408-1080
Fax: 202-408-1056
[EMAIL PROTECTED]
________________________________
Mon Apr 28, 2008 4:46 pm (PDT)
Hello all,
My name is Jesse and I am new to the list. I'm putting together an
access database to help a friend of mine with his growing lawn
maintenance business. The requirement I'm stuck on is that I need to
have it figure out who needs to be mowed based on the terms of their
service (how long between mowings) and the current date. I've got
that much but it displays every record that exceeds the threshold set
in their terms of service.
So if I have 2 entries for a customer and the newest means they are
over the limit it still displays output for the older entry as well.
I'm not sure where I need to work this into my query.
As you can probably tell I'm fairly new to access as well. Ask me
whatever other questions you need and I'll do my best to get you the
info you need to help me.
Thank you so much for your time and assistance.
Jesse
