Search results

Many thanks for the reply - indeed sales is the local table and the only one updated in the query. The query is a simple saved query run in the query window - although it is called via vba when working fine (through docmd.openquery...). Both the update query (slow) and make table (quick) were...

Hello all, I'm after some advice on a query that updates a locally stored table with information from a linked SQL table. I import some sales information into a table within access. I also have a employee table stored in SQL linked in this access database. In my imported sales data I link...

Hi, thanx for taking time to reply. I am basically trying to work out what % one column is of another in a table. The dat is stored in hh:nn:ss format. I have somehow stumbled upon the answer to my own query. I have in effect added 2 extra columns to my table and stored each column twice, one...

Hello all, I have a requirement to give a % figure from 2 time fields. I would have thought this was simple, but when I divide the fields I keep getting #Error. Its not an error caused by a divide by zero, i can recify those. Can anyone point me in the right direction to get a % from 2 time...