Description:
Microsoft Office Access newsgroup.
|
|
|
Change text box background color depending on value in Label Reports
|
| |
Hi, hope someone can help. Struggling with this.
I have designed in MsAccess 2007 a Reports to print Labels 3 across. I would like a specific field to change background color according to the value of the field. Using Conditional formatting, I can enable this but only for three values. However I am using more than 3 values.... more »
|
|
|
Report Width, why 23" not 11"
|
| |
When I make a report from a query, the default action is to place everything in a row and I frequently end up with a report that's 23 inches wide.
Why does it do that? Then I need to move everything around, headers, footers, default graphics, change the width, etc.
Am I missing something, is there an easy why to make the report fit a normal 8.5"x11" page?... more »
|
|
|
Adding a checkbox to an Access 2007 report
|
| |
I've created a report that will be constantly updated with new records that my group is generating for another group within my company. The report will be a checklist for tasks to complete. Is there a way for the report to have a checkbox so that the users can indicate which tasks they've completed, and which ones are still to be completed? Otherwise the report is just going to get bigger and bigger and will get confusing.... more »
|
|
|
Alternate newsgroup/website?
|
| |
I see that this newsgroup is no longer heavily used. Have people migrated elsewhere? Or is this just a sign of what has become of Access?
TIA
LAS
|
|
|
Report summing problem
|
| |
Is there a simple way to do this? I think I can get it done with coding and such, but perhaps there's an easier way?
I have a report that is grouped as follows:
Class
Student
Item Type
Item
I would like to display the subtotals of a numeric field for the different... more »
|
|
|
start count after 3rd. record.
|
| |
Hi, I would like to count records in a field beginning with the 4th. record. I now have this in a text box: =Count([VisitDate]) , but I need to start the count AFTER the 3rd. visit date to get a total of the remaining visits. Thank you for your help. David
|
|
|
Group by value
|
| |
Hi
Is it possible to group records on a report by a value? for example if
I had a field called labour time (in hours) on my report, would it be
possible to group records for every 20 hours?
Thanks
Alec
|
|
|
Average cases handled per agent in Sorting and Grouping report
|
| |
In a report using sorting and grouping by [WeekClosed], [Agent]
counting [CasesHandled]
I would like an average number of CasesHandled per Agent in the
WeekClosed header.
For example
WeekClosed 10/8/2012 CasesHandled: 36 Average Cases Handled Per
Agent: 12
Agent,RunningSum,Count(CasesHa ndled)... more »
|
|
|
