Search results

Hi Thanks, The transaction date is the date on which a purchase transaction is recorded Wk st date and end date refers to a customer being active with in specified range of week dates While License st date and end date refers to the dates within which the customer could avail the...

HI Can you not try doing pivot in access to get the required result Thanks and Regards Gary

Hi I am new to the forum and request help. I have a table with the following columns, TransdateCustomer NameLocationUnit PriceWk Start DateWk end DateLicence Start DateLicence End Date I need a SQL Select statement to return location and unit price for a customer where the transaction...