Search results

Using this method, why would I need to enter the range twice? Jim

Ahhhh yes. That will work. Thanks, Jim

I have a spreadsheet where workers enter the number of hours they worked that week. So column A lists the workers name and column B lists the hours worked for the week. In cell C1, I need to get the average time worked ONLY for workers who worked 30 hours or more. For example, if I have 30...

I have a query linked to a main frame database. One of the fields is [significance] and gets a number 1-20. Usually when this data is entered, it gets multiple significance numbers. This causes my query to return separate records for each significance number. For example if case number 123...

This does not seem to work. First of all I am using a count query, not a table. So the count query creates it's own name, not the field name of the table it references. However, I tried it anyway and it returned "#Name?" So I don't think this will work. I origainally had this pulling into...

I tried your first suggestion, but I have more than one row. I can have up to 5 rows, but when I tried this it created many duplicates and I wound up with 360 rows. I don't understand how to do your second suggestion. Thanks, jim

When I add a text box to the report and add Dlookup, it puts the following in the critera "=DLookUp([«expr»],[«domain»],[«criteria»])". This does not look like what I need. Can you give me more details on how to do this? Thanks, Jim

I have 6 queries that performs some count functions. So the results of each query looks something like this. Group Count EHS 3 RGC 6 SAR 9 BRT 1 UTC 5 NAM 9 I need one report that shows the count results from all 6 queries. How can I do...

I have an Access database stored on our LAN. This database connects to a mainframe database and has several some count queries. I have an Excel Spreadsheet in the same folder on our LAN. I imported the data from my Access queries and set it up to refresh the data on file open. This worked...

Now that's a thought. I never considered doing it that way. I'll give it a try. Thanks, Jim

That would not work because then the query would simply retun ALL the records for ALL groups other than SRG. What I need is all records where there is a Responsible group other than SRG but not a corresponding record where SRG is listed as a Resonsible group. As a note of clarification...

I have a query that includes the following fields Year EventNumber CorrectiveActionNumber ResponsibleGroup Committment Each event will have multiple corrective actions. For each corrective action assigned to a group, the "committment" is also assigned to them, but I also have to assigned a...

Great! That's a big help. I really appreciate the support. I think I can do it now. Jim

The report is exactly what I am looking for. Now, how in the heck did you get it to do that? You don't have a query, just table and a report. I looked at the record source for the report, but don't have a clue how to write such a long string of code. Also, it appears your data is in 2-3...

Thank you. I really appreciate your help. Jim

I appreciate your help Bob, but this is still not what I need. Your report shows the layout like this; Site1 Question 1 Response Question 2 Response Question 3 Response Site2 Question 1 Response Question 2 Response Question 3 Response etc.... but what I want is for each page to be a question...

I appreciate the responses, but I am still a little confuse. If I base the report on a query, I may only have to design one report, but I still would have to have 20 of them or change the query 20 times and rerun the report. If I use Sorting and Grouping, I can group one all the responses...

I did a survey with about 20 questions and captured the answers in Access. I want to build a report where each page has the question in the heading and all the answers for that one question below that. Is there a way to build this in one report, or will I have to have 20 reports? Thanks, Jim

In a report I have a "Priority" field that can have a potential of 24 codes. About 8 of them are considered high priority. These high priority codes all contain a "1" in them and I need to have a conditional format to highlight these red. So for example, some of my high priority codes are 1...

Where would I separate the mainframe's stored date/time into separate date and time fields? I only have read access to the mainframe data. Could this be done locally / temporarily somehow? I am not sure how to do what you are suggesting. Thanks, Jim