Combining two queries

[joeshig]

Hi, new to Access and SQL writing so bear with me.



I have two queries on an Access form which check whether a car is covered by the manufacture warranty or not based on mileage and date of purchase.

I have these as two separate text boxes on the form but struggling to combine these into one text box/query.

Here are the queries:

=IIf(DateDiff("yyyy",Date(),[txtPurchaseDate])>-"3","Covered")
=IIf([txtMileage]<70000,"Covered")

I've looked up and tried combining them by removing second = sign, sticking in AND/OR's but not sure if its as simple as that.

Sorry if this is simple but appreciate the help.

Cheers

[JoeM]

A bit of nomenclature - these aren't queries, they are calculations in the Control Source of your Text Box.
To combine both those checks into one, if would look like:

=IIf((DateDiff("yyyy",Date(),[txtPurchaseDate])>-"3") Or ([txtMileage]<70000),"Covered","")

[ranman256]

DateDiff produces a numeric value, not a string.
...)>-3,"Covered"...

[JoeM]

DateDiff produces a numeric value, not a string.
...)>-3,"Covered"...

Good catch!

[joeshig]

Cheers guys! Will action this and take a look at the DateDiff. Appreciate your help