Recent content by cokeblue8

It doesn't matter because the calculations are made from the records themselves, regardless of which table it came from. I figured out a solution by making a query by "union-ing all" the two full tables, and then adding calculations in on the unionized query. Thanks for your help!

I have two tables, and I made a union query (tbl1 UNION ALL SELECT ...tbl2). Problem is, I have two entries that are identical in both tbl1 and tbl2, but I want to include BOTH of them in the union query. Even though I used the ALL operator, only one set shows up!! I'm pulling out my hair trying...

do you mean to put the filter on a table instead of the FORM?

Hi everyone I'm relatively new to MS Access, and I have no experience dealing with workgroups and user-security. I have a database that I need to put on the company network. The database will be accessed by many different users and computers. How do I set up the database so that only certain...

Hi I'm new at programming Excel, so I apologize in advance if this is really elementary. I want to fill in all the empty cells with the value '0' only if the empty cells are between two non-empty cells less than 4 cells away. Otherwise, the cells should be left blank. I.e. for: 5 | 6 | |...

Bob, here is what I have as my rowsource for combobox #2: SELECT tblName.LineID, tblName.Name FROM tblLine INNER JOIN tblName ON tblLine.LINE_ID = tblName.LineID WHERE (tblLine.LINE_ID=[forms]![frm]![subfrm].[form]![cboLine].column(0)); Keith, I still get the same error message about an...

Hi all I have searched through this forum and on google, and I know that I can refer to a combobox's column property IN VBA by [myform]![mycombobox].column(1) When I do this in SQL, it complains that there is an "unidentified function" (column). What am I doing wrong?

Thanks for all the help, ajetrumpet. I really appreciate it! I thought about having two separate queries (one for each of the changeover types) and unioning the two (so the act. and std. would be on one record), but I thought that there would be a simpler way that I might have overlooked. In...

When I use "Act." I mean actual changeover, and "Std." to mean standard changeover. Simplified example of what I have: Date Problem Name Duration 09/05/07 Act. 120 09/05/07 Std. 100 09/10/07 Act. 90...

Act. and Std. are in the same field. The reason for this is because Act. and Std. change-over times are a subset of Machine problems.

Hi everyone! I have a report based on a query which shows the actual and standard change-over times. Is there a way to get Access to show the difference (or (Act.- Std.) / Std. ) for every Act. and Std. change-over pair? Thanks in advance

I have two tables: tblOne and tblTwo with identical categories. TblOne and tblTwo both group by Category and Duration. When I make a union query between tblOne and tblTwo, I notice that if I have the exact same category and duration for BOTH tblOne and tblTwo, the union query "eats up" one of...

The names all are correct..

I know this should be very simple, but I've already tried every possible entry from the site given in the FAQ section of this website (http://www.mvps.org/access/forms/frm0031.htm), but it keeps access keeps asking for a parameter value!! i have a subform(frmSub2) on a subform(frmSub1) on...

Does that mean I don't have to make the frmProblems subforms of the frmDetail subform, and can just do what you told me above? (Which, btw, can you please explain further? I'm a beginner at Access)