Search results

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])

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

Please help me understand why I get the following error message when trying to execute a query using this expression: ERROR MESSAGE You tried to execute a query that does not include the specified expression " as part of an aggregate function. EXPRESSION Expr1: (SELECT [Daily Goal] FROM...

Everyone, I am totally out of my league here so any help you can offer is greatly appreciated. Firstly, my database is modeled for a manufacturing company production line. We want to report on employee and product performance on a given day. The database was not created by me but I have been...

I have the following two queries that I generated from the results of the union query below. I would now like to join the two queries so that the resultant query results look like this: Date, Line, Shift, Work Order, HeaderOP, HeaderAB, HeaderAvailHrs, SleevesCut, HeadedTubes, Printer...

Please help me with junction tables. I havea large database that makes reporting a NIGHTMARE. The first step is to normalize this db and define relationships. I have hdr, print and line tables. I need to establish a relationship between the three. There is only one print per line but some lines...

Can someone tell me what the steps are to normalizing an existing database. I have inherited a database that has 54 tables with 22 appearing in the relationship window. Most of which do not have established relationships. Firstly I created a copy to play around with. I have run the table...

I must preface this posting by saying that I am truly a novice at this, so any help you can provide is greatly appreciated. I have a query with 14 fields and a query with 13 fields. The first six fields of both have the same name. The others are different. I am trying to generate one query...

I am an extreme novice to access however I have taught myself some things thanks to this forum. Can someone please tell me why I keep getting a "Syntax error in join operation" error for the code below? Thanks in advance. SELECT * FROM [Test NewProductionRptqryHDR] LEFT JOIN [Test...