Recent content by josh_hat

Does this look like what I need? Iif(Date() <> [Due2]![Due]+90,Is Not Null,Null) Then put "Is Not Null" for the Criteria field?

Rich, When I apply a filter with the Iif statement what to I put in for the false value?

What I have right now is a query set up that has a field that contains the last date a specific piece of equipment was last serviced, it is named "Last Cert". I also have field that has the frequency (in months) that piece of equipment needs serviced, it is named "Ferq". The other field is...

realnine, I tried both ways that you suggested. Neither one is giving me is giving me just the customers that will be due within the next 90 days. If you have any other suggestions I would appericate it. Thanks.

Yes it is the field that I did the first DateADD function with. This field gives me a calculated date for the next date the equipment needs certified.

When I type in... Between Date() And DateADD("m",3,Date()) I get.... Data type mismatch in criteria expression I'm I doing something wrong?

This was a different question. I got the DateADD funciton to work. I didn't have the m in " ", yes I know I am a retard. Now that I have the DateADD funtion working I can't get it to should just the ones due in the next 90 days. Sorry for the double posting. I really appreciate your help.

I have a query made that calculates when my equipment needs retested. I want to make the criteria so that only the equipment in the next 90 days shows up. I have tried a couple of different ways but they are not working. When I try =Date()+90 I get a mismatch warning. If this doesn't...

When I use the DateADD funciton, I put "m" for the interval value. Then when I try to view outside the design view it as to set a parameter value. What does that mean. Thanks again for your help.

I am trying to calculate a due date for my equipment. I am creating a table right now and I have a field that is the last date of certification. I also have a field that has the number of months till the equipment needs recertification. I am having trouble getting the field for the due date to...

queries criteria Sorry, this might be a dumb question but what do I put in the criteria so that I have the option to view all customers and the option to save or print one of them? As you can tell I am kind of new at this so your help is very appreciated.

Thanks for your help.

I made an invoice out of an access form and when I try to save or print it for the customer it prints or saves all 1100 customers. Thank you if anyone has advise.