Recent content by JemCain

This works like a dream! Thank you so much.

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...

Thank you. That works great, excpet I've used Count instead of First in the Value field.

Thanks CJ. I always wondered what a Crosstab query did. Bugt I'm not sure I've understood how to assign the value. I've used ChildNumber as that's the linked field between the two main tables, but what I really need is a 1 if they attended, rather than their child number. Is this possible. To...

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...

Hi plog, Thanks for all the advice. I've done every you suggest and it works brilliantly. ActivityTime is a text field that contains a time range (e.g. 10am to 2pm) and is only there so I can print it out on a report to give to parents. Thanks again, Jeremy.

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...

Thanks to everyone for your help. A combination of your advice worked and yes, there was also a null value! Really appreciate it.

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...