So I'm fairly new to Access and know very little about VBA. I have a query that essentially needs an IF statement (or something comperable).

I have a static TABLE1
and two queries

SELECT TABLE1.SHIPNUM, TABLE2.MULTISTO P, SUM(TABLE2.MILE S)

**SHIPNUM is a unique identifier tied with table2**
**MULTISTOP is a single 'P' or Null value**
**MILES is a number value**

I need...