Search results

Thanks Paul :) I appreciate the help.

Hi Paul, Thanks! From my learning point of view is your format: SELECT DateCost, HoursWorked, Rate FROM tblCost Left JOIN tblRate ON tblCost.DateCost >= tblRate.ValidFrom AND tblCost.DateCost <= tblRate.ValidTo; The same in principle to: select * from tSales inner join tLabRate on...

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

Hi Moniker, Thank you for the post, and apologies for not formatting correctly, I didn't know how to do that, I'm new to both Access and this site. I also posted on EE and ended up with the following which I think is what you are suggesting: In Module: Dim OldVal As String Function...

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

Answered Don't worry have sorted it. i was doing an aggregate query but had left a 'Year:year(sDate)' as 'Group By' in there so of course it returned one line per year..... Doh.

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

Think you right-click on the join and select 'all from <whatever>' to show the fields without a corresponding match in the other table. Regards Graham