Search results

  1. C

    Access Query to Excel Problem

    I have attached an example of my database. It is the results of the Query "PriceReport" i want in excel. But it must be linked, so when i update "PriceReportData" in access, the new data will show up in my excel file.
  2. C

    Access Query to Excel Problem

    I'm just jusing the build in function in Excel to connect to the Access database. It is the one under det data tab.. I have aslo tried with msQuery and with VBA, but no matter which way i try to retrieve the data from the query, i'm getting no values for SYS, DK1 and DK2. It shows me the...
  3. C

    Access Query to Excel Problem

    Hello, I have en Access created following Query: SELECT p.Produkt AS Produkt, (SELECT TOP 1 pr1.Pris FROM PriceReportData AS pr1 WHERE pr1.Produkt=p.Produkt AND pr1.Type="SYS" ORDER BY pr1.Dato DESC) AS SYS, (SELECT TOP 1 pr2.Pris FROM PriceReportData AS pr2 WHERE pr2.Produkt=p.Produkt AND...
Back
Top Bottom