Recent content by jsparker

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.