Please help with complex query

[Ben2k]

Hi, I hope someone can assist with this.

I want to create a query which will tell me what vehicles were in stock on a specific date.

I have two tables

CARS
CINVOICE

Linked by a field called StockNumber

I want to return records that have either of these criteria

CINVOICE.Date > 31/7/04

OR

CARS.Status > "In Stock"

I started to build the query as follows.

CINVOICE.Type = "invoice"
CINVOICE.StockNumber
CARS.Cost
CARS.Siv
CARS.ReconCostTotal
CINVOICE.DATE > [forms]![frm_input_historicstock]![date]

This is where I got stuck, this returns records where invoice date is greater than specified date but how do I now add-in records that are simply CARS.Status = "In Stock"

Thanks

Ben