Search results

  1. I

    Calulate column?

    I've created a table with a few columns and used a lookup on one of them. The lookup looks up items in another table which have a name and a price. The user can select multiple items, and it then saves the list of items to the column. I need to also take the prices for the selected item and...
  2. I

    Import xml and preserve character encoding

    Hi, I am currently a SQL DBA, and have been roped in to help a fellow staff member import some XML data into an access database. I am using Office 2003, and the Get External Data command. It successfully imports all of the data, but my colleague says that it is not acceptible because the data...
  3. I

    Sum is counting all records including 0s

    I am working on a project that requires a LOT of calculation, and I have managed to get to the end and have everything working. Or so I thought until yesterday afternoon. I have a query, that calculates the average number of hours each person has spent in a specific situation per week. This...
Back
Top Bottom