Search results

I am trying to set-up a booking system for a kids' holiday during the summer. At present, I collect data in JotForm, from where I can export it into Excel, but not Access. So I have an Excel spreadsheet that looks like this: and would like to import it into an Access table that looks like...

I run activities for children during the school holidays and log their personal details in the following table: Whenever they attend an activity, I log their attendance in the following table: where ActivityNumber is 1 for Monday's activity, 2 for Tuesday's activity etc. (details about the...

I'm running a summer holiday club for around 30 famiies that has 19 different activities on different dates. I'm trying to create a database to record which activities parents have booked for. They can, and will, change their bookings fairly often. So far I have 4 tables: tblParentData...

I finished writing a simple access database about 3 months ago but have come back to it to add extra functionality. However, some queries that I thought were working 3 months ago aren't working now. Here are some exmaples: 1. The following expression in a query gives a data type mismatch...

I was trained as a PL1 and FORTRAN programmer many years ago and later dabbled a bit with Access. I'm now trying to get to grips with it again as I'm helping out a small charity that needs a database and can't afford to pay for a professional. I live in north-east England, UK. It's good to be...