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
