Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lsridh

  1. lsridh

    Query with left join giving #Error values

    Was anyone able to figure this out -- pretty please???
  2. lsridh

    Query with left join giving #Error values

    I was initially getting error in that -- but by some freak chance (I copied the old Access 97 code to the query) it is working now. But, I am not sure what changed or why it is working now
  3. lsridh

    Query with left join giving #Error values

    Here is the CapDynamicLoad_2 query The problem is I think the Dlookup function, which uses dynamic_loadsize which is a Yes/No field on a table. The recipe time for all the #error values is blank, which indicates that there is something going on there. But I am not sure what to fix? SELECT...
  4. lsridh

    Query with left join giving #Error values

    A bunch of them - but the main problem is the UPH column... as that is the one which uses the iif condition with Dyn_UPH.
  5. lsridh

    Query with left join giving #Error values

    Let me know if I need to explain something SELECT capRoutes_1.RTS_Area, capRoutes_1.Rev, capRoutes_1.[Tool Size], capRoutes_1.Route, capRoutes_1.Sequence, capRoutes_1.[Mvs Rem], capRoutes_1.[Fiscal Year], capRoutes_1.[Work Week], capRoutes_1.Qty, capRoutes_1.Yields, capRoutes_1.Yld_Qty...
  6. lsridh

    Query with left join giving #Error values

    I recently migrated an Access 97 database to Access 2003. After figuring out how to get rid of the GUIDs & other such system generated fields, my database is clean now. But some of the queries are not performing correctly. I am using left join on two queries to generate a third. Query 2 has a...
See more

Part and Inventory Search

Back
Top