Question about how a field in a table is used

J

jwcampbell

X-No-Archive

Hello All,

I am trying to design an exit interview survey database in MS Access
for my job, and I'm basing it off of the "At Your Survey" database
created by MSMVP Duane Hookom. (You can just do a basic web search to
find and download the database . . .). I'm using the MS Access 2000
version.

My question concerns the RspnsType field in the tblQuestions table.
The MS Access description of this field says, "Possible Values
7-Numeric, 10-Text, 8-Date, 1-Logical (data types in Access)", so I
suppose that those are the entries that you're supposed to put in this
field. However, I can't find any code or queries that link off of this
to make it work. Can anyone explain to me how the database uses the
entries in this field to dictate the data types that are allowed as
responses?

I know that I could just use the At Your Survey database to create my
survey, but I'm trying to understand how it works, too. Thanks for
your help!

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top