Search results

Gina, Thanks for your further suggestion, but I don't have any Combo's and can't find anything significant in list Boxes. I did follow up my own thought about the concatenated 'Member Name' and replaced it with a simple First Name & Surname, but it made no difference, I still get the Enter...

I tried that yesterday, and again today, but my records are then sorted on the primary key instead of in surname order and the Parameter error is still there. Could it be anything to do with the fact that the Report doesn't actually use the Surname field in its printout. It is of course...

Thank you Gina, Selecting 'Group & Sort' in Design View shows only the <Add> facility and nothing else. As previously mentioned, the Property Sheet does show Order as [Mail List]. [Surname] but that is required. Strangely, I have a virtually identical Report which takes similar data from the...

Good Evening, I have noted several instances of the dreaded 'Enter Parameter' message occurring on Queries and Reports of my Database. I have been able to resolve all but one of these by examination of the relevant Property Sheet.Record sources to correct anomalies. One of the instances has...

Many thanks for the comments. It appears that that is an idea I have to abandon. jcbhydro

I have had a look at 'Security' but i don't see a solution to the read only facility. Regards, jcbhydro

Good Morning, I have trawled through the help files to find a means of saving a database as a read only version to distribute to interested users. I would eventually make it available to selected parties as a read/write version in a controlled manner. Is such a facility available for Access...

What a disappointment! Presumably this means that to produce a report which lists record totals from several separate tables will require a Query for each Table. I was hoping to limit the number of Queries I use. regards, jcbhydro

Re: Report to show totals extracted from Tables Good Evening, With the kind assistance of Forum Members I have built a Query that successfully achieves a 'count' and/or 'sum' of columns from a single Table. My next move is to carry out similar counts of records from 2 or 3 additional...

Thank you Brian for the further comments. Originally, I was attempting to count totals for a mixture of columns, not just tick boxes. I removed most, except tick boxes, to simplify my attempts. I don't want my count to include Null values so Count(*) doesn't seem to be appropriate. However, is...

Good Afternoon, After a deal of experimentation, and great assistance from Forum Members. I have eventually succeeded with my 'Totals Query. The Count facility counts the number of records OK, but it counts Yes and No in tickboxes, not just the Yes ticks. The solution as suggested is to use SUM...

Hi jdraw/Brian and thank you for further comments on my query. Taking account of what you have each said, I have several attemots at modifying my query. My efforts have been directed to 'counting' the records in each column of the Table, not a specific value as in the PostCode Query mentioned...

jdraw, I do a 'Compress & Repair' at least once a week. I think that the size is a function of having 5 Tables, about 15 Queries and about 10 Reports, plus 4 Forms and a couple of Macros. The membership is only about 400, but each of them belong to 5 or 6 of the 52 Interest Groups. Regards...

jdraw, Thank you for your comments which will require some careful consideration. As mentioned, I had to delete two thirds of the database to fit the 2 Mb upload embargo. Hence you will be unaware of the real structure of the database. It has 5 Tables which includes one called Groups and...

I am very much aware of the generosity of Forum members who provide assistance to others and I have expressed my sincere gratitude on very many past occasions. I have not been reluctant to provide data to those wanting to assist. I merely didn't want to confuse the issue by providing...

Brian, I wasn't ignoring you. I was merely waiting to see whether there would be any further action about my complaint of foul language & personal insults posted by a previous responder. Higher authority obviously shares my view and has removed the offending post. Returning to my original...

Good Morning, On 9th Oct. I initiated a thread on the Reports Forum concerning the use of Access in-built Access routines. Carelessly, my the title of my post included a typographical error! My post raised a general query on the subject of extracting 'Totals' data from a Table. I received 2...

Good Afternoon, In continuation of my earlier question, I have built a Query which I confidently expected to extract the relevant data. The Query uses the inbuilt Count feature of the Totals facility but does not produce the expected result. Instead of producing the actual 'Totals' for each...

Neither of these responses are in any way helpful! The structure or contents of the database are irrelevant to the question. My query, in perfectly plain English, requested advice in extracting totals data from a Table, probably using a Query. The totals data is a standard feature available...

Good Evening, I routinely produce a report for regular Committee Meetings which includes statistical date derived from the total rows for various fields in 1 or more Tables. It should be possible to extract such data automatically, probably using a query. So far, my endeavors in this direction...