Search results

Hi All, I have a table containing raw data customer which is at an individual customer level. Some of these customers have multiple individual accounts with us, but belong to the same group of companies. I want to create a summary table which shows the consolidated totals per group, but in the...

Hi All, I've got the Function below set-up to assign standardised names to cutomers whose names may have multiple different formats, e.g. Fonterra Ltd, Fonterra Limited, etc. The funtion is called from an Access Query. Option Compare Database Function Customertype(CUSTOMERNAME As Variant) As...

Hi all, Is it possible to name a field (heading) based on the value of another field? At the moment the code looks someting like this: Sum(IIf([START_DATE]<=[CurrentMonth],IIf([END_DATE]>= [CurrentMonth],[COST_PER_UNIT],0),0)) AS [ThisMonth Rate] I would like to name the field based on the...

Hi All, I need an Access query to return the rate at which a customer should be charged. A customer's rate can be set for a period of 1 to 6 months and the customer's rate table could look like this: ACCOUNT_ID........START_DATE........END_DATE........COST_PER_UNIT...