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