use data from form on query?(noob)

[bungle bonce]

I have used the usual method of calculating age from DOB and placed it
on a form, I now need to use this in a query, or place the data in a
table so I can then query it.

I am a noob so be gentle please.
TIA

[David B]

You don`t give much info on your setup but if you have the age in a text box
on a form then the query will grab it from there using something like this in
your
query criteria -- [Forms]![yourformname]![yourtextboxname]

The form always need to be open when you run the query.
HTH
David B
bungle bonce <bu*********@hotmaiLL.com> wrote in message
news:40***********************@news-text.dial.pipex.com...

I have used the usual method of calculating age from DOB and placed it
on a form, I now need to use this in a query, or place the data in a
table so I can then query it.

I am a noob so be gentle please.
TIA

[Bungle bonce]

Thanks David.

Will have a try tonight.

"David B" <Da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c5**********@newsg3.svr.pol.co.uk...

You don`t give much info on your setup but if you have the age in a text box on a form then the query will grab it from there using something like this in your
query criteria -- [Forms]![yourformname]![yourtextboxname]

The form always need to be open when you run the query.
HTH
David B
bungle bonce <bu*********@hotmaiLL.com> wrote in message
news:40***********************@news-text.dial.pipex.com...

I have used the usual method of calculating age from DOB and placed it
on a form, I now need to use this in a query, or place the data in a
table so I can then query it.

I am a noob so be gentle please.
TIA