Search results

Hi there, I have a problem with an SQL query related to a table which contains stock market transactions. The query requests data from a table called tblTransactions with (among others) columns Date, Ticker, Quantity and Price. By adding up the quantities bought (positive number) and sold...

Problem solved Thank you very much. This code works perfectly. I didn't know the TOP 1-syntax before... Best, JapanFreak

Hi there, I wonder whether the following problem can be solved with a Query or if I have to adjust my database. I want to take records of my stock market trades and among others I have created two tables: The first one, called tblTransactions, contains transaction-related data and the columns...

Problem solved - 2 remaining questions Hi, thank you very much for your replies. Actually it was a combination of various things. This SQL request works: SELECT T.Ticker, S.Name, X.qCl FROM tblTransactions AS T, tblTradedSecurities AS S (SELECT Q.qTicker, Q.qCl FROM tblQuotes AS Q...

Hi there, actually I have already asked the following question in an Excel forum (www.excelforum.com) before, but I only got the advice to try to ask this question in this MS Access-related forum. Thus, here it is: I have a problem with regards to retrieving data from an MS Access 2000...