Search results

Thank you so very much indeed. I knew it would be simple, I just couldn't figure it out. Cheers!

I'm go to try and explain this another way. I could really use some help with this and I think it must be really straight forwards, but I've been trying for days now and my most recent efforts have been making Access hang! I've attached a screenshot of the table T_Attendance to show the...

Hi, I am grouping by date period. Grouping by ChildID does not produce the desired result. It simply shows the number of times each child attended each month. What I want is the number of unique children who attended each month. Much obliged for any help in modifying the above query. Alan

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

Thanks Arnel, that's done the trick! Alan

Thanks guys. Am I right in saying that this is basically just the same as importing the table from one database to another? So starting point would be that the table simply doesn't exist in the new database? I have added various new fields to the tables, added descriptions where there weren't...

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

Thanks very much for that. It's exactly what I need. Best Regards, Alan

Thanks for the suggestion, however I don't see the value to the end user of being able to view things in the immediate window. I want to see data on a datasheet. I found a solution which works for me, which involved making a dummy query which I called "Info", and then redefining it's SQL and...

Hi JHB. That looks promising. I do indeed need to be able to narrow down the results. How for instance would I use VBA or SQL to just show a list of people who were in the Groups "Men" and "Violinists"? Very grateful for any further help. Alan

Hi all, Thanks for the advice. I have tried using the code suggested as follows. At present it does nothing. Further advice would be much appreciated... Private Sub lbl_OtherKids_DblClick(Cancel As Integer) Dim SQLString As String SQLString = "SELECT T_Children.ChildFirstName...

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 Bob, Thanks for taking the time to create an example. It doesn't do what I had hoped. I'll try and clarify. First things first: How, in the example we are playing with, would you bring up a list of all of the people in the group "women" who are also in the group "violinists"? Alan

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

Fair enough. I'm content that I'm not missing anything, and happy that I can always copy and paste the crosstab into Excel and format it a bit more. Thanks for your help

Hi Rich. That's what worked for me. In fact First, Last, Min or Max works fine. Wondering how (if it's possible) to display this as a report now. Thanks, Alan

Hi Plog, Thanks for that. I've achieved what I'd hoped for. Any way to now display that as a report rather than a query? Alan

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

Glad I could be of assistance. I've had so much help from this forum, I thought it was about time I tried to pass it on. Alan