Recent content by STEVENCV

You sir, are a genius. Using your NumberofHours worked perfectly! Thank you very much for your help, and your swift responses. It is much appreciated.

Thank you for your help. I understand the logic of that. However, how would I calculate the "NumberofHours" field so that it's a numeric result?

Thanks. I have a field on the report that counts all the users still on the service by using: =Sum(IIf([service_end_date_time] Is Null And [package_accepted]=True,1,0)) So the package_accepted works there. It's the hours field I think that is causing problems. I keep getting "data...

Hi, I am creating a report and need to count the number of clients that are within the first 48 hours of the service, and also count clients that are above 48 hours. I also need to count clients whose service has ended, but count those that ended within 48 hours and those that ended after...

Perfect! Thank you ALL so much for your help. I know it can be frustrating talking someone through something when they clearly don't have experience of doing it, so thank you for your patience and help. This forum has helped me many times in the past (and I'm sure I'll need it again in the...

Thank you. That works beautifully. I now need to be able to create queries by area. I added the criteria "Oldham" as below: And it gave me these results: What it needs to do is pull all records that match all of the criteria you guys have helped me with, but ONLY for those records where...

But how would I then factor in the past into that criteria?

The accuracy is not a problem. It doesn't have to be the last year, just in the past. I used that -365 criteria as I was unsure how to word it for past dates. And the +30 is just a guide to show what is due for renewal in the near future, it does not have to be an actual calendar month. As...

So the criteria "<Date()+30" covers the past, today AND 30 days in the future? That's good to know, should make my criteria easier to write.

Thanks Connor. The date in the cowensform field do not matter, all I need the query to do is pull records if that field is empty. The others all have various criteria that SHOULD be pulled through onto the query. Joe Bloggs should show up because his motexpiry date is within the next 30 days...

I'm really sorry but I'm getting confused now. When use your criteria, it brings up the correct results, and yet your criteria states that the "motexpiry" must be BOTH in the last 365 days AND in the next 30 days? Is that right? For example Joe Bloggs moteexpiry is 26/09/2014, he insurance...

Thank you for the reply. That seems to work perfectly. Can I just clarify something, because I don't understand how that works. You put the criteria as: >Date()-365 And >Date()+30 Why is "And" used and not "Or"? I am looking for records where the date is EITHER in the past or up to 30...

I think my initial attempts as creating this query may have confused people as to my intentions. For the records, when I run the query, it needs to bring up all records where any one of these conditions are met: motexpiry date is null, is today, is within 30 days after today or is in the past...

Then I must have made a complete rookie mistake in my criteria, as it's supposed to only show up records where the actual date in the fields motexpiry or insuranceexpiry is in the past. As Frank Flash's dates are all in 2015, he should not show up.

I have attached the actual database, does that help?