Age

[fender via AccessMonster.com]

Hi,
I have a form linked to one table.
On the form i want to have a combi box for "Age" with the choices, 12,13,14,
15,16,17,18,19,20,21,22,23,24, 25+ and "age not given".
What is the best way to achieve this?
Have mercy,very new to Access,thanks!

 

[Arvin Meyer MVP]

Create a 1 column combo and set the RowSourceType to Value List. Then enter
a row source of:

"12"; "13"; ... "25+"; "age not given"

 

[Jeff Boyce]

A note of caution ...

Your database is guaranteed to be incorrect and in need of updates ... if
you record "Age" rather than Date of Birth.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fender via AccessMonster.com]

Thanks for your reply Arvin.
I tried that, but when i run a query with criteria set to find the 25+ , i
get an invalid syntax message.
What am i doing wrong?
Thanks

Create a 1 column combo and set the RowSourceType to Value List. Then enter
a row source of:

"12"; "13"; ... "25+"; "age not given"

Hi,
I have a form linked to one table.

[quoted text clipped - 3 lines]

What is the best way to achieve this?
Have mercy,very new to Access,thanks!

 

[fender via AccessMonster.com]

Thanks for your reply Jeff,
Its actually going to be used for people who don't want to give their DOB.
Regards

A note of caution ...

Your database is guaranteed to be incorrect and in need of updates ... if
you record "Age" rather than Date of Birth.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi,
I have a form linked to one table.

[quoted text clipped - 3 lines]

What is the best way to achieve this?
Have mercy,very new to Access,thanks!

 

[Arvin Meyer MVP]

OOPS. Try ">25"
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thanks for your reply Arvin.
I tried that, but when i run a query with criteria set to find the 25+ , i
get an invalid syntax message.
What am i doing wrong?
Thanks

Create a 1 column combo and set the RowSourceType to Value List. Then
enter
a row source of:

"12"; "13"; ... "25+"; "age not given"

Hi,
I have a form linked to one table.

[quoted text clipped - 3 lines]

What is the best way to achieve this?
Have mercy,very new to Access,thanks!

 

[Arvin Meyer MVP]

Jeff is correct. I had assumed that your query was calculating age.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thanks for your reply Jeff,
Its actually going to be used for people who don't want to give their DOB.
Regards

A note of caution ...

Your database is guaranteed to be incorrect and in need of updates ... if
you record "Age" rather than Date of Birth.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi,
I have a form linked to one table.

[quoted text clipped - 3 lines]

What is the best way to achieve this?
Have mercy,very new to Access,thanks!

 

[fender via AccessMonster.com]

That works a treat !
Thank you

OOPS. Try ">25"

Thanks for your reply Arvin.
I tried that, but when i run a query with criteria set to find the 25+ , i

[quoted text clipped - 12 lines]