Search results

Hi there I have read through a number of posts concerning storing derived fields and I am aware it is a controversial issue, so I wouldn't mind getting some opinions on my scenario. I am designing a database which stores client and invoice information and creates printable invoices using...

I have created a workbook which both imports data from an access database and exports data to same. Some of the data I need to access is dependent on parameters which the user will change in excel e.g. I need to extract PeriodID (ID for a month end date) based on a date in a speified cell in...

Hi there, I have seen the great help you guys give to others and wonder could you help me out with a crosstab problem I’m having. I have a table tbl_clients, with a currency field (either EUR, GBP or USD from a lookup table) and a table tbl_purchases with a currency field (the same...