470,561 Members | 1,909 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,561 developers. It's quick & easy.

use data from form on query?(noob)

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

Nov 12 '05 #1
2 1695
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


Nov 12 '05 #2
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by bob hicky | last post: by
3 posts views Thread by bungle bonce | last post: by
8 posts views Thread by siol | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.