Search results

  1. G

    Query without Join??

    I really don't know how to describe this, so bear with me! i have a table of sales data 'tSales' that holds 3 years of transactions. Fields are Acc Cust Market Prod Qty Value Cost Material Labour I have another table 'tLabRate' that holds our labour rates e.g. in 2004 £20ph, 2005 £25ph etc...
  2. G

    Optimize Recordset update - speed

    Hi, how can i best optimize this code for speed? Private Sub cmdBOM_Click() Dim blnOK As Boolean If Me.LMsuccess = "No" Then MsgBox "Please Import LM data before processing", vbInformation, "Processing BOMs" Else MsgBox ("Files Found") 'in Tools | References, make sure the ADO ' "Microsoft...
  3. G

    Aggregate Query (Export to Excel)

    Hi Everyone, I am working on a Sales Analysis db, which pulls from: tSales - Sales Figures (40k records) tBuildUnit - Bom Build Units (8k records - one per product) tBom - Bills of Material - All Components (71k records) tUom - Units of Measure for Products (80k records - 10 per product) It...
Back
Top Bottom