Search results

Not sure what that means, but I really appreciate the help. It's back working great. Thanks again. Jim

I have an action tracking database that someone on this forum helped me create some 15 years ago. It has worked flawless until we upgraded to Windows 10 and Microsoft Office 2016. Now I have a few problems. I was able to fix some, but two I have been unable to fix. The problems are listed...

Any easy to understand tutorials on how to do this? I am a medium level Access user with no experience in writing code.:( Thanks, Jim

jdraw - Yes that is a typo. All fields contain the same information except the problem description. I have no clue why this database was created that way. It's an action tracking database developed by ABB company and used by a lot of people in the utility industry. Galaxiom - I am only...

Not sure. I have not looked for a unique field, but you would think there would be one. When I run a query, it always returns the records in order. Would a unique field help solve my problem?

I am linking to an SQL database that is designed in such a way that the problem description is recorded in multiple records. See a simplified example below. I want to run a query that will merge the information in the PROBLEM_DESCRIPTION and return only one record for PROB_ID 55678. PROB_ID...

Thanks everyone. I am headed out of town on business so it may be a while before I can test this out for myself but from what you say it should work fine. I really appreciate the help. Jim

accessAnswer - You are correct. For the example I gave the results would be blank because Event_No 123 has some Action_No's with Priority other than 3. If it helps to understand what I am trying to do, Priority 1 and 2 actions fix the problem but Priority 3 are only enhancements. So I want...

I don't think either of the suggestions will work. Here's why. Lets say I have the following records, Site Event_No Action_No Priority 1 123 1 2 1 123 2 3 1 123 3 3 1 123...

I have a database table with the following fields. Site Event_No Action_No Priority For Event_No may have more than one record becasue it may contain a number of Action_No. For example, Site A may have Event_No 123 which has 10 Action_No's. Each will be a separate record. I want a query to...

I don't know how to be any clearer but let me try again. In our company we have 4 physical sites or plants across 3 states. The sites in our database are simply Site C, Site G, Site M and Site O (the first letter of the name of the site). However, each site has a different number of units...

I am stuck on how to write and IF statement that will count the values for each site and then divide each site's count by the number of units. On my current report, I am simply using "=Count(*)" in the site_cd header. So my results is simply a total count for the site (c,m,g and o). However...

The units at the sites is a know standard. Think of units as plants. So site C and M have 2 units or plants on their site. Site o has 3 units or plants and site G has only 1 unit or plant.

site_cd pip_yr pip_no entering_dte c 11 1563 3/1/2011 5:05:00 AM m 11 1564 3/1/2011 6:09:00 AM o 11 1565 3/1/2011 7:15:00 AM o 11 1566 3/1/2011 7:28:00 AM o 11 1567 3/1/2011 7:56:00 AM o 11 1568 3/1/2011 8:11:00 AM o 11 1569 3/1/2011 8:13:00 AM g 11 1570 3/1/2011 8:31:00 AM c 11 1571...

I have a report that totals the number of items for a given site [site_cd]. I have a Site_Cd header and I am using the [=Count(*)] to give me the total. However I want the total to be based on the number of units at the site and was wondering if I could use an IF statement to accomplish this...

Thanks tehNellie. In the criteria field for my table 2 item if I use Like "*1*" or Like "*2*" or is Null I still get no results. If I leave it blank I get results that are all "3". Again what I am looking for is how many in Table 1 have no 1 or 2 [Priority_Cd] from table 2. As for your...

As a follow-up, if what I asked above is normal as I suspect, how can I write a query to look for records in table 1 that do not have a certain criteria in table 2 for that corresponding record. For example lets say I have the following in my query TABLE 1 YR ID# Type TABLE 2 YR...

I have a query that has 2 linked tables in it. I have the Joined Properties set to include all records from table 1 and only those records from table 2 where the joined fields are equal. To validate my query is working, I picked a query that would pull 3 records from Table 1 when there are no...

Thanks. I had to change [RC] to "RC" but after that both worked fine. I appreciate the help. Jim

I am trying to write an IIF statement to calculate the days a report has been open. I have to do this because in the database I am linking, the start date gets changed too easily, so I have to calculate the days open this way: DAYS_OPEN: (Date()-([prob_eval_orig_due_dte_tm]-30)) The database...