Need to create invoice with many variables

  • Thread starter Thread starter M Brown
  • Start date Start date
M

M Brown

Hope someone can help me...
I need to create invoices for a school contest.
I have several criteria and am not skilled enough to know how to make this
happen.

Students can enter 1-3 events. In this case, the school is charged $18
However, if they enter ONLY a written event, they are only charged $5
For each contest, I have a yes/no field established to determine if it is a
written contest or not.
So, I need Access to determine if the student is entered in only 1 event and
if that event is JUST a written event. Then I need Access to assign the
correct $$ charge.

As an added bonus (!),
Advisors are charged $10 and would not be entered into ANY events

Advisors are coded as "A" and students are coded either "S" or "PS" - I
think I need to just pull the "A"s and charge $10 then search the "S" and
"PS" for the written contest criteria.

This is too much for my brain - please help, if you can! =D
 
M Brown -

You can do this, but it will depend on your data structure. Since you
haven't given us much to go on, I will make some assumptions. I assume you
have a table called Contestants with one record per student or advisor, and
that record has a SchoolID type field. You can either have a related table
with the events they have signed up for, or used three different fields (like
Event1, Event2, Event3) in the Contestants table to show what they have
signed up for. The former is the better way to go, but most new users think
like Excel and do it the latter way. We also need to know which events are
written, so you can have a table of events that give the list of possible
events and if they are written or not. Or, a new user may have the events
coded like W100, W101, W102, P100, P101, P102 where the first character
indicates written.

Please post your data structure including the fields you want to see on the
invoice so we can help you out.
 
Back
Top