Paremount Query - selecting customer who are 35 and under + 36 and over

[rvd48]

I have a problem with a Paramount query. All I would like the query to do is, look through all the dates of the customer table. Use the date of birth to devide the customers into two tables for the 35 year olds and under. And 36 and over.

But I just cannot seem to get my head around it. I would be greatful for any help,

Cheers :

 

[KenHigg]

How do you intend to use these two tables once you have them?

ken

 

[rvd48]

hi Ken,

Thanks for the quick respons.

For my assigmnement, one of the objectives fo the database is to, target different age groups, namly the 35 and under and the over 35. So that LM books the company can then mailshot the correct group for the products that they will be interested in!

Therefore, I need to somehow be able to take for example 14/10/1954 and run a query that can determin the age of a particular customer and therefore put the customer into the correct age group.

I don't know if this is possible, but there must be a way.

Thanks

Llewellyn

 

[KenHigg]

I don't see why you would need to make any new tables. Could you just build a query where you place a parameter in the date fld that looks something like:

< datepart("yyyy", date()) - 35

???
kh