Recent content by hlacroix

Thank you pbaldy, I'll try that.

Hello, I need to combine the information from eight individual reports into one summary report. Each individual report is based on its own query. What is the best way to accomplish this? Thank You

Hello, My client database features a report summary which is intended to show key details from 8 distinct categories. This summary itself is an unbound report. In the page header is the report name date range paramater current date and page number fields. In the detail section of this unbound...

Hello, When I first open my client data entry page, the page is empty. When I click on sort, the data appears. Please tell me why this happens and what can I do to correct it. Thank you

My database has 8 clients. During a sample date range, between 1/1/05 and 1/1/11, they worked a total of 348 hours. I need to query them for hours divided by client by date range. 3 clients, for instance, worked a total of 162 in the sample date range but the query is dividing the 162 hours...

Thanks statsman, that did the trick.

Hi, In my database, I have clients and client hours. I need to calculate average client hours. My total client hours expression is: TTotals: Sum((Nz([SessionHoursCompleted])+Nz([OptionalHoursCompleted]))). I need to divide this number by the number of clients. Any suggestions ie sum of client...

Hello, I had a date range parameter, ="From: " & [start date] & " To " & [end date] on my report. When I enter a start date and an end date, I am prompted for the range again. To troubleshoot, I removed the range, either from the properties box or just delete it from the control itself. When...

I have a database to track client activity per session. Each client has a unique client number but multiple activities. Therefore, if I have 20 clients in the database and each has 3 activities, I have 60 client numbers, 3 *20 = 60. ( Duplicated) My elementary problem is how do I display the...

I have a database to track client activity per session. Each client has a unique client number but multiple activities. Therefore, if I have 20 clients in the database and each has 3 activities, I have 60 client numbers, 3 *20 = 60. ( Duplicated) My elementary problem is how do I display the...

Thanks for your reply, neileg. The problem was that using the expression ttotals:Sum(([SessionHoursCompleted])+([OptionalHoursCompleted])), the two fields weren' adding correctly. I followed boblarsen's advice and substituted Nz([SessionHoursCompleted], 0) + Nz([OptionalHoursCompleted], 0)...

Thank you Bob. Would you elaborate a bit on the NZ function's specific placement in a query? I tried substituting = Nz([SessionHoursCompleted], 0) + Nz([OptionalHoursCompleted], 0) for ttotals:Sum(([SessionHoursCompleted])+([OptionalHoursCompleted])) but it still isn't right.

I designed an Access database for a project. It consists of tables, queries, forms, reports and macros. Just about all the bugs have been worked out except for a summary page. In addition to a client data entry form, I included a client work summary page which is intended to display a count...