I have a text box with multiple values

G

Guest

I have text box in my input form in which I need to have multiple values
such as "H" and "M"on the same day . In most cases it will only be an "H".
In the input form I enter the date and then the student name and the next
field will be the LunchType where I will input H, M then the amout
collected. I have set up a crosstab query to run the report. Everything is
running smoothly if all the students only have one value entered in the
LunchType field. The problem is when the student has two values on the same
day. Any suggestions on how I can correct this?

Thanks,

Robin
 
M

Mike Painter

Robin said:
I have text box in my input form in which I need to have multiple
values such as "H" and "M"on the same day . In most cases it will
only be an "H". In the input form I enter the date and then the
student name and the next field will be the LunchType where I will
input H, M then the amout collected. I have set up a crosstab query
to run the report. Everything is running smoothly if all the
students only have one value entered in the LunchType field. The
problem is when the student has two values on the same day. Any
suggestions on how I can correct this?

Yes. Get rid of the idea. Multiple values in a field are a *very* bad idea
in a relational database.
Each value should be in a field in a related table.

That is the only way to correct the problem.
You can write a lot of code as a workaround but the problem will never go
away.
Sooner than later you will run a report, forget you need to write more code
and find that the administration has lost faith in your efforts because it
is clearly wrong.
 

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