Gym club database upgrade

[bacon]

Good morning


I have an access database which holds the membership details of a local gym club. At present we have to export the data into excel to produce invoices as different classes have different costs.

What we would like to be able to do is to print the invoices as displayed in the attached excel spreadsheet straight from the Access database.

1) print invoices from access database
2) choose a select (from - to) to print from.

If anyone can help it would make a big difference.

Thank you in advance .

Bacon

[OBP]

I have experince in creating invoices for customers in Access.

[matthewspatrick]

What you are trying to do would be a trivial exercise, if you had set up your database properly in the first place. The biggest flaw in your db design is that you have separate fields for each class; the proper way to have handled it would have been to have one table that holds info on classes available, one table for members, and a "class assignment" table that links members to classes.

IMHO, what you are asking for is beyond the scope for what one could expect in a free forum--after all, what you really need is an application redesign. However, many members here are open to contract work offers. Those who are open to such offers will generally state that in their public profiles.

[bacon]

What you are trying to do would be a trivial exercise, if you had set up your database properly in the first place. The biggest flaw in your db design is that you have separate fields for each class; the proper way to have handled it would have been to have one table that holds info on classes available, one table for members, and a "class assignment" table that links members to classes.

IMHO, what you are asking for is beyond the scope for what one could expect in a free forum--after all, what you really need is an application redesign. However, many members here are open to contract work offers. Those who are open to such offers will generally state that in their public profiles.


you are correct... thank you for the advice... :beerchug:

[ALaRiva]

Wow, since when did this site become focused on offering only answers to questions that can be answered quickly, and if they can't, you offer to redesign it for a fee???

I've helped people on other forums for 2-3 months straight going back and forth with helping them on learning a particular subject. No big deal, that's what a Help/Discussion Forum is for.

Isn't that what this forum was supposed to be about, NOT UPSELL!

- Anthony

[matthewspatrick]

Anthony,

Please read my post again. I outlined what bacon ought to do: revise the table structure, and then query against that revised schema to generate the invoices.

Do you think I ought to redo the schema, rewrite the queries, redesign the forms, and redo the reports, and all for free? I certainly could do it--it would be easy--but it would also take several hours, and this site is not about donating several hours of time. It is about collaboration and learning.

Patrick

[bacon]

it doesnt matter...

I have been offered help.. far and beyond what I would have expected by OBP. Once again this site proves that there are people out there willing to help others.... thats not a dig by the way. :)

It has also fired my interested into Access and I will be teaching myself the basics and hopefully will be able to repay by helping others on here...

It's all about Karma...

[GaryB]

I have to agree with Anthony in one respect. We are here to help each other. I have been helped, sometimes in great depth, many many times and I cheerfully help when I can. Even though my knowledge is limited, there are times when something clcks and I step in. Patrick is right in the respect that we shouldn't be expected to rewrite a total database, but, remember that a lot of us are new at this and looking for guidance from the more advanced and knowledgeable. So, maybe tempering how we say something is the answer and remembering we were all new once the key.

GaryB