Recent content by Robertomac

Sounds like you need to relate your tables, possibly by creating an orders table or an orderline table. Aswell as ID fields, it would need the foreign keys from all the other tables i.e. tiles, carpets etc. Once this is done, you can base a report on an individual order/orderline possibly using...

I have produced a report which shows the payment record for a ski instructor for weeks worked in a season. The main report is based on a query comprising table tblInstructorDetails and tblPaymentHistory. It has a sub-report which is based on a similar query. It all works fine except for some...

I have built a database to log ski instructors for our company - recruitment, employment etc. For each week in resort, I need to create reports that show Instructors Arriving, Instructors Leaving, Instructors Staying, Instructors Moving. I have two main tables that this information will come...

I have built a database to log ski instructors for our company - recruitment, employment etc. For each week in resort, I need to create reports that show Instructors Arriving, Instructors Leaving, Instructors Staying, Instructors Moving. I have two main tables that this information will come...

I have built a database to log ski instructors for our company - recruitment, employment etc. For each week in resort, I need to create reports that show Instructors Arriving, Instructors Leaving, Instructors Staying, Instructors Moving. I have two main tables that this information will come...

I have built a database to log ski instructors for our company - recruitment, employment etc. For each week in resort, I need to create reports that show Instructors Arriving, Instructors Leaving, Instructors Staying, Instructors Moving. I have two main tables that this information will come...

I have built a database to log ski instructors for our company - recruitment, employment etc. For each week in resort, I need to create reports that show Instructors Arriving, Instructors Leaving, Instructors Staying, Instructors Moving. I have two main tables that this information will come...

Is there anyone based in or near Nottinghamshire (UK) who would be interested in reviewing the current database system we use at our office? We are a skiing holiday company and the database is fairly complex. It was created about ten years ago and over time has had various bits and pieces...