Search results

Not sure how to post a new question; I was trying to search for how to keep colors consistent with the categories; seems like they change and I'm reading that the colors/categories are 'skipped' if the amount is 0. How do I get the category color to remain consistent with the category name.

Re: Update only some fields in a record I couldn't figure out how to start a new post on this website but somehow got into one of my old posts so will ask the question here. Hopefully I can ask it in understandable language!! I'm still doing the 'oncall' database. One group needs to change...

Thank you so much for your help! I found some coding to use in 'BeforeUpdate' that cancels the update and eliminates the 'can't save' prompt: Private Sub Form_BeforeUpdate(Cancel as Integer) Cancel=True End Sub Private Sub Form_Error(DataErr As Integer, Response As Integer) If...

Thank You. You're right, I have the drop down selection with control source 'group name'. But when I remove it the records for the group name don't come back; nothing does... Nevada you're in so you're probably not even up yet. Luv Nevada !!! such great weather!!

Hi, I'm hoping someone can help. I created a database that will be updated by one group, and then 'selected' information viewed by another. I used forms (for the reading group) to select from dropdowns, run queries, and then display what's requested on a report. Each time the dropdown is...

Hi, I'm hoping someone can help me; not very good with MS Access yet and definitely not versed in VB. Using Access 2002-2003. What I'm trying to do is Group / calculate on 2 types of incidents Sorted (and 'summed up' by Day of the week. So if we had Incident1 3 times Sunday this week, 4 times on...

I think I got it. Had to delete a few items. From working on this yesterday I did get the total to display, but am not getting the Avg Time To Repairs (Avg TTR) on the report. Thinking I'm not getting something pretty simple (hope !!)

How do I upload the database for you to see? or just attach to the email you sent?

Well, I was able to get that field to show up in my report, but now only the calculated fields from query1 and query2 show up to select as controls; and in Query 2 when I drop down the fields from Query 1 (to use in report) - the Sum calculation goes back to showing a 1 instead of the correct...

I'm hoping I didn't use up all of your patience!! I ended up creating 2 queries (2nd one uses 1st as a source) because the 'count' field was always returning a '1' and I couldn't sort on the =sum box. So I have 1 query that has all the info needed for the report, then the 2nd query does a 'sum'...

Alrightey; I'll go 'back to the drawing board' - - thanks again, esp for your patience!! :)

I know why I'm having such a hard time. I'm explaining myself wrong I think. I have one field called 'Service Category' which I'm using a query to count when 'SRT' appears for each of the Service Categories in a query . I use 'count(*)' in the report under a title '# of SRT's" which gives me...

OK, I''ll try. I'm confusing myself I think

I do have the report sorted by Group 'Service Category' - it sorts in alphabetical order but I want it to sort using the totals for each 'Service Category' - in descending order...

OK, I think I've gotten the first and second steps; I have a query that does the counts and my report uses it as the source. I'm not understanding the last item 'use the count from step 1 in your report's sorting'

I keep track of the amount of calls we get for multiple types of services, so list the total calls for each and then a 'grand' total. What I want to do with those counts is list them by the heaviest hit (most calls for this service, next is that one, etc). So 'rank' each service by amount of...

Or maybe I just don't understand how to 'join this query to report's record source' VIA SERVICE CATEGORY FIELD. I have it as the reports record source (completely(?) - if that's the right wording) and using the count from step 1 in my report's Sorting I also don't understand..... :(

I really appreciate your response, but don't understand it. I have a query that counts on Service Category and creates a 'CountofService Category' field which shows all '1's for each record. When I use that query as record source for my report, I get the totals all fine. It totals each group...

Hi! I'm hoping someone can help me with this. I need a descending sort on a textbox that has =Count(*) as its source. Nothing I do (filter, sort) works. The totals display for each group (grouped by the field Service Category). When I run a query, each record has 'countofService Category'...

I have a parameter query with 'From' and 'To' dates that I create a report with. Is there anyway to use the From and To dates as a control source for the report ? I'd like the report page to include the dates as a header, since they will be changing. Thanks in Advance if anyone can help!!