Query that show certain results

[LukeJ Innov]

Hello All,

Im currently building a small database for a client, but they have asked me for something which has stumped me. Here goes:

I have a column in a table that is a range of dates, how would I create a query so it only shows dates that are 11 months old if you get my drift.
The table shows information on boilers (those things that heat your water in your homes ) every year the company carries out a service on said boilers. I want the query to show the service dates that are 11 months old, so the customer know that that boiler will need another service soon.

Thanks in advance,

Regards
Luke

[June7]

Try:

SELECT * FROM table WHERE DateAdd("m",11,[ServiceDate])<=Date());

[LukeJ Innov]

Hi,

The code does not seem to be working for me? It shows the results but im getting all of the dates, not just the ones that are over 11 months old.

Thanks,
Luke

[LukeJ Innov]

Sorry got it to work, Thanks!!