Search results

Thank you, I knew there would be a simple solution. That saved me some work. Ian

Thank you, I can see the logic now, but initially, it was not what I expected.

Just that it is in two columns Sorry, I meant SQL Ian

I'm a beginner at Access, but the one thing I have leant is there is often a very simple way of doing a task if you know how. So before I start looking at VBA and DAO commands. Is there an easy way of entering a value in a text box, passing to a query to do a count function and then return...

Dale Thank you, as you have probably guessed I'm new to access. Your SQL brings up something I didn't expect in design view, I think I will probably be better off concentrating on writing SGL!!! Thank you Ian

I have created a query in design view which has generated this SQL: SELECT [ACD-C-DataSourceExport].Field2 FROM [ACD-C-DataSourceExport] GROUP BY [ACD-C-DataSourceExport].Field2 HAVING ((([ACD-C-DataSourceExport].Field2) Like "2313*")); This works fine and returns all 265 records bginning...

All Thanks for all your assistance, I finally got it working. Either I or Access was getting confused by having the same field name for ID in several tables. I have now made them unique and got it all working.

Richard Thanks for your encouragement, I am getting closer. Can I check I am selecting the correct tables for the subform? If I have the following three tables, which hopefully will be self explanatory... tblPerson tblLink tblGroup When I add the subform, I am selecting fields from both...

Thank you , but I have done the relationships (I think!!) Ian

Aggghhh why is Access sooo difficult. Rather than amending the example database, I thought I would learn more from starting from scratch using the example database as a guide. I have added the tables and set the relationships ,however as usual the forms are a PTA.. I added a form with a...

Richard Thank you, I spent quite some time scouring the web looking for some guidance, but couldn't find any. This download is ideal, as I can dissect and see how it is done. Thank you very much. Ian

Richard Thank you, I follow the logic. However I thought as it is possible for a person to have a role in multiple groups, I would need an intermediate table to form a many to many relationship? This is what I have set up, but I can't my head around how to set up updating the data in a form...

Thank you. I have attached the spreadsheet with anonmylised minimal information. There is one tab for Group and one tab for people Regards Ian

Hi All I'm a newbie at access, I believe I understand the basics of relational databases and queries, but I am really stuck on an issue. I have been asked to maintain a directory for our local Scout district. It's currently in a spreadsheet, but is crying out to be a database. Here is what I...

Thank you, I've realised what I was doing wrong with my command button, I have added the =dlookup to the onlick event. The only thin, I'm not sure about now, is if I should be pointing to a query at all, should I do the query in the onclick event as well? Regards Ian

Hi All I'm an MS Access newbie and I was wondering you would be able to help me with a form and query? I've done some googling of the problem and I have come up with the following: I have a table of telephone extentions called "ACD-C" I have a query "called qryRecordedBySite" and I have a...

I have a database which I run for my Scout group. One of the reports I run is the nights away badge. In the report, I produce a list of camps each Scout has attended and calculate the total number of nights. I also have another field that displays the current nights away badge held, so for...