Hey,

I'm creating a service program in Access 2003

I have two tables:

tbl_Appliance
ApplianceNo (Primary Key)
SerialNo
ApplianceType
ApplianceManufacturer
ApplianceModel
ApplianceDescription

tbl_NextService
Nxt_Service_ID (Primary Key)
Appliance_ID (Foreign Key)
Nxt_Service_Date

as you can see the tbl_Appliance stores all data about the appliance, the tbl_NextService table stores the next service date of that appliance.

What i need to do is find all the dates stored within the database that match the month of the Computers system date. is this possible using access?

e.g.

if i have the date 23/03/2005 within the tbl_NextService table, this date will be queried as the system date is the 14/03/2005 (Date is in the same month as the system date)

VB Code:
  1. SELECT tbl_Appliance.*, tbl_NextService.Nxt_Service_Date

  2. FROM tbl_Appliance INNER JOIN tbl_NextService ON tbl_Appliance.Appliance_No = tbl_NextService.Appliance_ID

how would i add a WHERE clause to the above SQL statement

Thanks