Search results

The report has a group by "booknumber" and "activity" I added a group just for "booknumber" the total is the same. What is needed is to count unique book numbers for each activity. Each record has a book number for each activity. Is there a way to get a count of unique book numbers?

Thank you, I have got a working report . Another thing I need is to have a count of the books associated with each activity. When I attempt to do a count of the book number ("Count of members for this activity") I get a count of the number of activity events. Instead of a count of the number...

A picture is worth a thousand words This is a snippet of the report as it stands. I am also attaching the SQL of the query used My guess is I have to modify the SQL, a helping hand would be appreciated.

Hello! I have a report from a log-book database that produces "activity Book# detail hours mileage" with running totals by activity and book#. I would like to produce the report without the details just the "activity book# hours mileage" with running totals of hours and mileage. I get the data I...

Maybe I am abnormal, to my mind the purpose of making a workbook read only is that recipients can read the results of the spreadsheets contained therein without the ability to modify anything. MS solution seems to have no real effect if it can be so easily circumvented. Thank you for your input...

Yes! Isaac. This is the option I used. I did not supply a password to open read-only, I supplied a password to modify. I followed your sequence and you are correct it saves a copy; read-only can be by-passed by renaming, so it is not a very sound method to prevent modification :(( Thank you for...

See my response below to Isaac!

Hi, I saved a .xlsx file as read-only but when I closed it read-only then re-opened as read-only I was able to edit cells. Would appreciate pointers to what may be causing this!

Thank you! that fixed that problem.

Hi, I have exported data to a spreadsheet to auto populate a pre-formatted spreadsheet in that workbook from my access DB. This works! This was code I found and modified with some assistance. I am concerned that the data now relies on the integrity of the 2nd sheet in the workbook. Therefore I...

This turned out to be a rather simple exercise. Created a select query of the crosstab query and selecting only those columns required.

This is how I would like the data to appear in the spreadsheet.

I won't be able to use a form or report as the workbook exists it has a formatted spreadsheet and I need to create another spreadsheet in the same workbook and populate the existing spreadsheet from that. (unless there is another way to achieve the result). I need to take a closer look at your...

I just need the Activity ID , Activity Type, total hours and total distance I'll go do some research and see where I get TY

Ah! ok I think I need to go study how to export a report to a spreadsheet. Thank you for your guidance.

As I don't really need the date columns is there any way to produce the output without displaying the date columns? <edit> To be clear I just need the totals of the hours and distance.. Also what is the column labeled <> ?

do you notice how you and I keep typing responses at the same instant? I think this is 3 times in about a week

Ok! took a break, on return I see where I had made a typing error in the sql, It now works with just the hours, now I'll put the distance and I am sure all will be good. Thank you very much for your patience.

oops!

Ok this is what my sql looks like. I removed {, Sum(ActivityRange.Distance) AS SumOfDistance} , I thought that could be added later. TRANSFORM (val(Sum(ActivityRange.Hours) & "") AS SumOfHours1 SELECT [Activity Type].[Activity ID], [Activity Type].ActivityDesc, Sum(ActivityRange.Hours) AS...