Search results

Ok. So I have 20 Select Queries set up. Stated above is only Primary Key, Calculated field for check box label and value of check box. Is that the only three fields I need for each query? I don't need any other information about each line item (Name, Date, Client, etc)? On a union query...

Yes. All yes/no fields on one table. So 20 queries and 21 to unionize the 20 queries? What am I putting in the 20 queries and the 21st?

I have a table that has 20 yes/no fields. When creating an error report to show the null values I'd like to create a report that shows only fields that return a NO value. I know how to set up in the query to pull only null values but when it rolls to the report I'd like to only see the fields...

Thanks Galaxiom. That was my issue. I kept trying to sum at report level and it was giving an error message. Once I plugged in the formula at the record source level and then just summed at report level it worked perfectly. Thanks again.

I understand how to make the above text box invisible. My field is called [Error Count] but when I try to add another field to COUNT[Error Count] it isn't recognizing the field and zeroing it out when I run the report. I must be missing something. Help?

Appreciate it. I kinda had that in my head but thought, "Nah, this person used some sort of high tech feature to understand the page coordinates and didn't just print it out and count the spaces over." Thanks again.

Understood. I apologize. The database is pulling from a .PRN doc with the following code. If stEMPNO > "000000" and stEmpNo < "999999" then stWeekEnding = Mid(stRecord, 141, 10) stCode = Mid(stRecord, 191, 10) stHours = Min(stRecord, 84, 6) Ok. So I understand the first...

Ok, I know this is easy but I can't find the answer and hoping you all can pop an answer to me. I am reviewing a database with a number of MID string statements. I understand the first number is the location and the second is the length. What I'm failing to understand is how you calculate...

I have two tables that I've combined into a query. I want to pull from that query to update a form. Allow for some further input from the user and then save all fields to another table. In my Employee ID field I have a select query that has a search criteria of WeekEnding. Once the week...

You guys are awesome. I played with it and finally got it to work. I was being stupid and didn't realize that you had to enter the dates in the form first then the query pulls the records from those dates and then puts the dates in the text box on the final report. Excellent. Thanks! Kudos...

="Between " & [Forms]![frmName]![txtDateFirst] & " And " & [Forms]![frmName]![txtDateLast] Ok. So I'm not sure what I input. What is [Forms]? Is that the form that the query pulls from? Though it pulls from a table. [frmtable] same question. It's a query pulling from a table to a...

I have a report that pulls info from a query that has a set criteria of a date range using [Between]. How do I post that date range on the report? The date range changes from report to report so I'm hoping there is a way to show the range criteria on the report from the query. Any suggestions?

When I went a different route I was getting a Division by Zero error. How do I work around this? Sometimes there will be zeros when it comes to time (associate is out of the office, etc.) Is there a way to have it skip the environment calculations if there is a zero present so it can calculate...

So I have a form broken into three sections. First section is associate time oriented items (scheduled hours, absent, overtime, available time, production hours, production percentage). Second section is a set of 5 different environments were time is collected where associates work. (Mode...

George, Having the same problem when I query the queries. Telling me that I need to set up a query first. I've attached a screenshot.

I hope everything is alright with the wife. Appreciate you taking time to respond to me. I tried the outer joins in a monster query but got the error message about too many ambiguous joins etc.

I think I solved the outer join problem. The 3 extra records it was pulling werent duplicates but actual records but they had a week ending date that wasnt found on the week ending table. So the outer join links should work as you suggested. So once I have outer join queries for all modes to...

George, I decided to join the Mode tables with the associate and week ending tables first. When I do outer joins with the mode to associate and from mode to week ending it gives me my list of records but then it gives me a second list of records that don't match with the week ending. The...

Thanks for the direction George. So I understand you correctly, you are stating that I should create multiple queries with outer joins first and then essentially query those queries to a final query? If that is correct which do I outer join first? The mode time tables to each other? Or the...

SELECT [tblWeek Ending].[tblWeek Ending], [tblDC Associates].[tblUser ID], [OCR Mode Time].OCR, [KE Mode Time].KE, [BDE Mode Time].BDE, [KEV Mode Time].KEV, [KFI Mode Time].KFI, [OCRTotalWait]+[KETotalWait]+[BDETotalWait]+[KEVTotalWait]+[KFITotalWait] AS [Total Wait] FROM [tblWeek Ending] INNER...