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 solved the problem! I copied the database and spreadsheet onto the server again, remade my connections and did some queries (all using the import data option on the data menu). I have tried it on a few other machines on the network and it appears to be working as it should :D I think the...

Hi David Thanks for the suggestion. I moved both the database and the spreadsheet to the shared drive on the server before I made a connection and queries. I saved the DNS connection in the same folder as the db and spreadsheet on the drive before making the connection and queries also and I...

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