Search results

Hi all, I'd be really grateful if someone could help me figure this out. I'm trying to create a query to show historic attendance figures for a children's music club. The query should count how many unique children (ChildID) attended in each month. So far what I've managed to do is get the...

Hi all, I have an issue which surely is relatively common, however I have struggled to find an answer. I have built databases for 3 similar projects (after school music clubs). The first one was built in Access 2003. The other 2 in Access 2013. I'm self taught, but have learned a great deal...

Hi there, Thanks for taking the time to look. I was beginning to think I had got the hang of creating queries on the fly in VBA. After several hours I have just learned that docmd.runSQL does not work for simple SELECT statements. I'm not going to worry about why that would be. I'm sure...

Hi and thanks for looking, I've posted this in the VBA section as I suspect it will need some code. It might be that some experienced soul can point out a different way of achieving what I desire involving structuring my data in a different way. I'm all ears. Here's what I want to be able to...

Hi there, Thanks in advance for taking the time to look I want to present some data in what seems to me like it would be a very natural and normal format, however have so far been unable to figure out how to do it. :banghead: I record attendance data for a children's after school club in a...

Hi there, Thanks in advance for taking the time to look I want to present some data in what seems to me like it would be a very natural and normal format, however have so far been unable to figure out how to do it. :banghead: I record attendance data for a children's after school club in a...

Hi there, I'd be really grateful if someone can give me a quick steer on something that's been bugging me. I've attached a sample database which is based on part of the database we use to manage a children's after school club. We record Attendance Data. For each date we record whether or not...

Hi and thanks in advance to anyone who can help me. Our access database helps us keep track of children attending an after-school music programme. Each week we print registers and give them to the class teachers for them to mark who is coming. The registers are produced as a report, grouped by...

Hi and thanks for taking the time to read this. I have a database used to record attendance of children at an after school club. We want to fairly analyse each child's attendance. Some children come on a tuesday, wednesday & thursday, some stop coming on certain days and then restart on a later...

I hope everyone's having a good Friday. Thank you kindly to anyone kind enough to offer some advice... I have a table of attendance data for children attending a club. This table (T_Attendance) records the AttendanceID (autonumber) ChildID, Date and whether they attended or not. I'd like to use...

Hi there, I wonder if someone can help me get my head around this... Our Access database is used to record attendance of children participating in an after-school programme. I want to be able to record some more detail, for instance the dates on which a child starts attending, the date they...

Hi and thanks for taking the time to read, I have read lots of posts and advice about this subject but I still haven't managed to crack it. This is where I have got to: I have managed to create code that turns selections from a listBox into a string. The listBox contains a list of colours. The...

Hi there, I am trying to create a query which will show only the oldest child from each family. I have built a totals query which groups by guardianID (which defines their parent) and shows the minimum date of birth (therefore of the oldest child). Or at least it should. Whenever I view this...

My database stores details of children taking part in a music project. I want to create a query which I can use for a mail merge to write to all the families. Some children are from the same families. I don't want more than one letter to go to the same family, but in the letter I want to be...

To get to the root of a problem that has been causing me significant grief I have created the attached incredibly simple database. t_Children and t_Lessons are related in a one to one relationship. If I want to add a new child, I open table t_Children and create a new record. What I would like...

Hi there, I have an attendance report, which displays attendance grouped by child's name, so each child's name is listed with a list of dates under each one, and whether they were there or not. Is there any way of stopping groups from breaking across pages? This looks bad and makes the report...

Hi and thanks in advance for any advice, I use a database to look after the children's charity for whom I work. We have regular trips and I normally create a new table for each event to keep track of who is signed up. So I have two tables - one called Children, with the structure: ChildID...

I have a report running off a query displaying attendance data. It lists children by name, then attendance dates, whether they were there or not, and any notes. It seemed to be working fine, but now for certain children (consistently the same ones) each entry date is appearing three times...

I have a report running off a query displaying attendance data. It lists children by name, then attendance dates, whether they were there or not, and any notes. It seemed to be working fine, but now for certain children (consistently the same ones) each entry date is appearing three times...

Hello, I have a database of contacts which is available over our office network. I would like for the data to be available to be read by all users but only edited by certain people. To acheive this simply I created two users, one called admin, which I gave full access, and one called others...