Recent content by Kath

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'