Search results

Hi Khawar, After futher usueage of your code I've come accross an issue with company names containing the apostrophe character , e.g. Bob's Cafe. Once the program encounter one of these, it produces the following error message "Runtime error 3075. Syntax error (missing operator) in query...

Thank you very much for taking the time to look at my problem - your solution works a treat. Regards, Jules

Apologies all - the format of my table didn't come across correctly. I'm attaching a file containing the raw data and also the required output. Thanks again Jules

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 Adam, Thanks for the reply. Currently the list of customers stand at 25, but this will change over time, customers being added or deleted. I don't want the end-user having to edit this function when changes need to be made - I would rather them just have to enter the details into 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...

Thanks for your response, Pat. What you say does make sense, even though the field will always have the same value in that particular table (but the value will change month on month) A bit more info: I'm running 2 queries, the first to list all bills for the pervious period. The user is...

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

Many thanks for your time Craig, I got that to work for me. Regards, Jules

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