I am creating a database for a co-worker that has no administrative help to create it for him. Overall it should be a pretty simple database to create...I do have a delima on how to do something though.
Eric (the gentleman I am doing this for) wants an ExitCode field and be able to choose one of the following Exit Codes:
A, C, D, E, I, L, N, G, T or P. That was going to be easy (use a list box) until I read the fine print on the form they are now filling out by hand...it states: A combination of codes may be used.
My question is can I make one field store in combination of the Exit Codes and still be able to break them out for a report? For example, if Eric makes an entry and his Exit code is C and E...I will want to be albe to print a report that says how many entries Eric has had and how many of those were each type:
Eric - 10 Entries
A - 1
B - 1
E - 2
N - 3
T - 3
Does this make since to anyone? I know what I want to be able to do, just not sure how to go about asking you if I can do it.
Thanks in advance for your help.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net
Eric (the gentleman I am doing this for) wants an ExitCode field and be able to choose one of the following Exit Codes:
A, C, D, E, I, L, N, G, T or P. That was going to be easy (use a list box) until I read the fine print on the form they are now filling out by hand...it states: A combination of codes may be used.
My question is can I make one field store in combination of the Exit Codes and still be able to break them out for a report? For example, if Eric makes an entry and his Exit code is C and E...I will want to be albe to print a report that says how many entries Eric has had and how many of those were each type:
Eric - 10 Entries
A - 1
B - 1
E - 2
N - 3
T - 3
Does this make since to anyone? I know what I want to be able to do, just not sure how to go about asking you if I can do it.
Thanks in advance for your help.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**
lena.wood@starband.net