Search results

Ok, I am trying to convert the text (company) into a number. Concerning the other questions: It is just a date and the backend DB is on my deskop computer. Could the proposal of vbaInet (flip your date field (using DESC), use TOP 1 and do a join) speed up the query? But I dont know how I...

Yes, the query is still running. The navigation bar is in this query not visible (in other queries i see the "single number" and the first results). On the bottom right side I see only "Query is running" (German: Abfrage wird ausgeführt), but no progress bar. I am using Access 2013 64bit.

The data source is another Access DB (BackEnd). The two tables are linked to the FrontEnd Access DB. This are the two tables: tblDates PosNr As a number (Index, without duplicates) PriceDate As a date (Index, with duplicates) Company As a short text (Index, with duplicates) tblPrice Company...

It is running now approximately 30 minutes. In the bottom on the left side appears a info: This recordset cant be updated. (German: Dieses Recordset kann nicht aktualisiert werden) I think this is not normal, or?

Thank you very much CJ_London! I get the correct result. :) Now I will test it on the "big" database. :D

Hmm...i build test tables with the content from my first post. tblDates PosNr As a number PriceDate As a date Company As a short text tblPrice PriceDate As a date Company As a short text Price As a number And i used 1:1 your code SELECT tblDates.*, tblPrice.Price FROM tblDates INNER JOIN...

Thank you for your support. Unfortunately I get this result: PosNr PriceDate Company Price 1 01.01.2014 Firma A 5 2 02.01.2014 Firma A 7 3 03.01.2014 Firma A 9 4 04.01.2014 Firma A 8 6 06.01.2014 Firma A 6 7 02.01.2014 Firma XY 11 8 03.01.2014...

Hello, I already asked this question in my last thread, but unfortunately it was overlooked because the topic question was solved. Anyway, sorry for double posting. I have a price table: tblPrice PosNr PriceDate Company Price 1 01.01.2014 Firma A 5...

Ok, thank you very much namliam! :) You seem to be an expert in sql. Maybe you have a solution for a other problem. I have a price table: tblPrice PosNr PriceDate Company Price 1 01.01.2014 Firma A 5 2 02.01.2014...

If I change a.maxpos - 365 = b.posnr in a.posnr-365=b.posnr than it works fine! Thank you! :) I would like to test your second code, too. Select * from tbldata as d INNER join ( Select company, max(posnr) as MaxPos from tblData where posnr < 364) as x on d.Company = x.company INNER join...

With this code, I get an "syntax error", too. :confused: Do I have to add something to run this code as a query?

Thank you very much! If I test ... Select * from tbldata as d join ( Select company, max(posnr) as MaxPos from tblData where posnr < 364) as x on d.Company = x.company join tbldata as b on x.company = b.company and x.maxpos = b.posnr ... I get "syntax error in FROM clause". What I am...

Hello, I have this query: SELECT A.PosNr, A.PriceDate, A.Company, A.Price, (SELECT TOP 1 B.Price FROM tblData As B WHERE B.Company= A.Company AND B.PosNr < ( A.PosNr - 364 ) ORDER BY B.PosNr DESC )...

Hello, I am trying to import data from an Excel file to MS Access (2013). The Excel sheet consists of 700 columns. A group of 7 columns (always same header) are to be implement in Access one among the other. That means: At first columns A-G, than columns H-N, than columns O-U I am trying to...