linking two fields in seperate box's

  • Thread starter Thread starter ksawb
  • Start date Start date
K

ksawb

I have a bunch of tables each one a question. In each table two fields.
Field 1 is the answer field 2 is the points for that answer. How can I set it
up that the points show in a text box next to the combo box. I'm teaching
myself so I don't know a lot of the terminology for this program.
 
I have a bunch of tables each one a question.
You should not have a separate table per question. Use a separate record
for each question.
Use this in select statement --
SELECT QuestID, [Answer] & " - " & [Points], ....
 
Thanks but where would I put the formula. Should I make a Query for this?


KARL DEWEY said:
You should not have a separate table per question. Use a separate record
for each question.
Use this in select statement --
SELECT QuestID, [Answer] & " - " & [Points], ....

--
KARL DEWEY
Build a little - Test a little


ksawb said:
I have a bunch of tables each one a question. In each table two fields.
Field 1 is the answer field 2 is the points for that answer. How can I set it
up that the points show in a text box next to the combo box. I'm teaching
myself so I don't know a lot of the terminology for this program.
Click to expand...
Click to expand...
 
Yes you need a query. I suggest that you follow the advice given by Jeff
Boyce.
--
KARL DEWEY
Build a little - Test a little


ksawb said:
Thanks but where would I put the formula. Should I make a Query for this?


KARL DEWEY said:
I have a bunch of tables each one a question.
Click to expand...
You should not have a separate table per question. Use a separate record
for each question.
How can I set it up that the points show in a text box next to the combo box.
Click to expand...
Use this in select statement --
SELECT QuestID, [Answer] & " - " & [Points], ....

--
KARL DEWEY
Build a little - Test a little


ksawb said:
I have a bunch of tables each one a question. In each table two fields.
Field 1 is the answer field 2 is the points for that answer. How can I set it
up that the points show in a text box next to the combo box. I'm teaching
myself so I don't know a lot of the terminology for this program.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top