Access or Excel for swim club fees

  • Thread starter Thread starter Phil Boorman
  • Start date Start date
P

Phil Boorman

I have built a simple database for our competitive swim team that contains
info such as name, address swim group etc. As the registrar I need to pass
along information to the treasurer on a monthly basis that indicates how
much money she is expecting to collect. There are monthly fee's that apply
to individual swimmers and yearly fee's that apply to families. I would love
to build a table/form that links to my list to track in/out payments but I
am coming from a pretty basic level so I have been searching for sample
databases that I could adapt. Would I be better off just exporting my list
to Excel and doing the financial calculations with a spreadsheet?
 
you can probably do it in Access pretty easily. please post details of your
tables, and i'll make some suggestions to you. use the following format:

TableName1
FirstField (use PK to indicate the primary key field)
SecondField
ThirdField (use 'FK from table name' to indicate a foreign key field)
FourthField
etc

TableName2
FirstField
SecondField
etc
 

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

Back
Top