Recent content by lmg0115

Thank you to everyone who helped me work on this. Here is what worked:

I'm sorry if I'm not being clear but I guess that is part of my dilemma. My query is based off of another query and I want to lookup the header end and subtract it from the header start to get the actual hours worked. I want this to happen where the date in the first query equals the date in...

Thanks for the suggestions. I tried the following and it still does not work. Please show me where I am going wrong. I received a data type mismatch error. What I am trying to do is substract the first dlookup field from the second dlookup field. HDR ActHrs...

Msaccessrookie, thank you for your response, however the syntax for dlookup is: Syntax DLookup(expr, domain[, criteria]) Header Information is the name of the table and what I am trying to say here is HDRActHrs = Header End-Header Start and I want to lookup the header end and header start...

I have the following dlookup expression that is not working. I keep getting a missing argument error. Please help me. HDR ActHrs: DLookUp("[Header End]","Header Information","[Date]=" & [Date]),DLookUp("[Header Start]","Header Information","[Date]=" & [Date]),[Header End]-[Header Start])

One more quick question. . . I would like the Printer Operator ID to print the Last and First name, how do I go about adding this statement to my IIF statement: =[tbl_Employees]![Last_Name] & " " & [tbl_Employees]![First_Name] I tried adding it in the criteria field but it doesn't do...

That's what I missed. Thank you.

I am confused by your statement This statement is exactly like the one above it, the only difference is MyField = A,B instead of "none". Am I missing something? I'm still very new at this and want to make sure I understand where my errors are and how to correct them. In addition, the...

Everyone please help me make this IIF statement work. I have the following query which is derived from a union query: SELECT TestHDRPRUnionqryforProdRpt.Date, TestHDRPRUnionqryforProdRpt.Line, TestHDRPRUnionqryforProdRpt.Shift, IIf(IsNull([Customers]![Customer #]),[Workorders]![customer...

ajetrumpet, our posts must have overlapped. My apologies. It worked (as you knew it would). Thanks again for all of your help on this one.

I looked at all of the data types of the fields in the DLookup expression and the month and year fields in the qryStreamFactor are derived from a Date/Time data type and the month and year fields from the DailyProductionGoal table are set to number. I tried the code above suggested by ajetrumpet...

I'm sorry, I am referring to the daily goal. In the DailyProductionGoal table the daily goal is set to number, however when the query looks up the field it brings back the correct number but as text. I hope that makes sense.

ajetrumpet, this worked! Thank you. I have one question. . . It is reading the result as text and I need it to read it as a number so that I can calculate on the field in my report. How do I change it?

I repaired the data type mismatch error. It is only giving me the results of the first row of data in the ProductionDailyGoal table which is the daily goal for January 2007. I tried adding a where statement and it still gives me only that row of data. Here is a copy of the previously mentioned...

This did not work and I am sure it is through no error of yours. What I am trying to do is this: Each month the Daily goal changes so I have a table named ProductionDailyGoal that has 3 fields, DailyGoal, ProductionMonth and ProductionYear. This information is fed to the table from a form...