Search results

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...

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...

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 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...

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...

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...

What is the best way to add criteria when there are a lot of them? For example, I have a field called [site_cd]. I want the query to only return records for certain groups. However, I have about 50 groups. Is there a better way to accomplish this than a long string of "or Like" such as "Like...

I have a report (IRs_Generated) based on a query. On the report I have fields [site_cd] and [=Count(*)] in the header. This way I get a total count of the records returned from the query for each site. However, I want to report the results based on the number of units at each site. Some...

I have a query for a report hitting a SQL database. One of the fields is Date-Time in this format [11/16/2011 5:46:00 PM]. I have a form with a combo box with simple numbers 1-10. In the Date-Time field of my query I have the following >Date()-[Forms]![frm_Main]![cboMinusDays] This way I can...

I am using MS Access 2007. Traditionally, Conditional Formatting has been limited to 3 conditions. Is there a way to have more? I have a report with a Priority Code field. Priority x1xx, x2xx and x3xx. I want all of the x1xx (e.g. I1a, O1ba, I1cd, etc.) to show red with yellow text and...

I have a number field in the format 00-0000 on a form and associated table. The first 2 digits represent the year and the last 4 are a numerical sequence. When I designed the database I did not imagine exceeding 9999 in a year, however we did. So I increased the format length to 00-00000...

I have a query based on a linked table associated with an SQL database. The query is looking for the following. YR CR_No UserID Signature_Type (ASSIGN or DUEDATE) Signature_Date I want the query to return all of this data in one record however when I run the query one record shows the UserID...

I have a report that is based on a query using Linked Tables to an SQL database. One of my fields [MR] returns -1 for Yes and 0 for No. I want my report to show Yes and No not -1 and 0. How can I make the report do this? Thanks, Jim

I am using Access 2007. I am quering an SQL database so the tables are linked. I have 2 queries. One query limits the characters in the "description" field but the other does not. I verified it's the query not the report associated with the queries. The main difference in the queries is the...

I have a query to filter the results of my data based on a combo box located on a form. The form Combo Box is called cbo_Status. The code I have in the Criteria section of the query is [Forms]![frm_Main]![cbo_Status] Or Like [Forms]![frm_Main]![cbo_Status] & "*" When I run the query, with a...

I created a new database in Access 2007. The main form serves as a menu to open other forms and reports. After creating the whole thing, I wanted a button to close the database. So, at the bottom of the main form I added a Quit App button. To add this button I clicked on the button tool and...

I am really frustrated at Aceess 2007, especially the Reports. I created a new form but it won't let me move the data fields and field headings around like I want. If I drag one the other come with it. If I try to drag the heading from the page header to the group header it won't let me. If...

I have a simple Append Query that all of a sudden gives me the error message I have not changed the design of this query in months and it has worked fine. Any suggestions on how to fix it? Thanks, Jim

I have a table with a field name "Date". I have a form with two fields "StartDate" and "StopDate". I have a query to display the results. In the Criteria field I want it to use the StartDate and StopDate as the range. However if no date is entered into the StartDate and StopDate, I want it...

I have a form frm_DataEntry. On this form I have a combo box cbo_Status. I also have other text and date fields on the form. 5 of these fields I only want visible when cbo_Status is set to "Ticket Returned". My 5 conditionally visible fields are named EmployeeName, EmployeeBadgeNo...