Search results

Apologies, probably a dumb question but I can't find the solution: I have two tables, let’s call them A and B. B is a sub-set of A, i.e. every item in table B can be found in table A, but not every item of table A can be found in B. Both tables have the same columns. One column is called...

Dear All, sorry, I need your help again please… The question below builds on a problem earlier today (http://www.access-programmers.co.uk/forums/showthread.php?t=209691). Again I have attached a small sample database which helps to make my problem clearer. I have a database with a table...

Dear All, please find attached a small sample database which maybe better helps to explain my problem. I guess the solution is quite simple but I just don’t get it… I have a database with a table called tblTrades in which I collect data on stock market transactions: tblTrades TradeID –...

Hi, I use Excel and ADO to access and write data in an Access database. I use the VBA code below to add new records to an existing table. This works so far, however how do I have to adjust the code if I add another column to the table, which contains a primary key which is set by Access...

Hi there, I have a question with regards to printing binary data in a txt file. The code below retrieves historical stock price data from Yahoo. This works fine so far. However, at the beginning of the txt file there are always some weird symbols (e.g. "
¿M"), which are not part of the...

Dear All, I have a question with regards to SQL and its use in conjunction with functions. Under this link you can see a question which I asked in this forum before: http://www.access-programmers.co.uk/forums/showthread.php?t=161510 I asked whether there is a SQL function which allows me to...

Dear All, I have a question: I want to have a query which gives me the maximum of different columns, i.e. somehting like Max(Column1, Column2, Column3). Due to my Google research I know that there is a function called "Greatest" in MySql - is there something similar in Access / VBA? JapanFreak

Dear All, I have a problem with importing data from a txt file whilst using SQL. The following SQL request works: sSQL = "SELECT Sec, Op1, Tot_Asset, Cash, MKTCAP, EVnow FROM " & TxtFileName(i, j) & _ " WHERE Op/(Tot_Asset-Cash)<" & dROICHurdle & _...

Dear All, I have a general question regarding my draft of a data model. Actually, I would like to make sure that I am not making a major mistake before I move on. Please find attached a ppt-File, which shows the relevant section and visualizes my explanations below. Background Table 1...

Dear All, I have a problem with filtering out certain dates in a Where-statement. The following query works: SELECT sum(D.EVnow)/sum(D.Tot_Asset - D.Cash) AS AssetMultiple FROM Data AS D WHERE D.Op/(D.Tot_Asset - D.Cash)>0.1 AND dDate=#04/30/2008# AND FINOTH="NONFIN"; However, if I...

Dear All, once again I have a problem where I have absolutely no idea where to start from... I have two tables. The first one, called tblAccounting, contains cash transactions. It looks like follows: AccDate Account Amount Currency Remarks 09/01/07 Account1 50.00 USD...

Hi there, I have one question with regards to the WHERE part of an SQL query. I want to limit my query on datasets, where the first three letters of a certain field (which contains strings) equal "Exp". Is there a more efficient way than the following? SELECT A.Date, A.Name From tblA as A...

Hi there, once again I have a problem for which I am looking for some hints... I still have one table, called tblTransactions, which contains security market transactions. For each buy and sell order, respectively it contains one data set with columns Date, Ticker (i.e. the unique identifier...

Hi there, I have one table, called tblTransactions, which contains records on security market transactions. For each buy and sell order, respectively it contains one dataset with columns Date, Ticker (i.e. the unique identifier of each security), Quantity (positive for buy, negative for sell...

Hi there, I have a problem with an SQL query, which should combine data out of three different tables (tblTransactions, tblTradedSecurities, tblStopps, tblQuotes) using a combination of Inner-joins and sub-queries. However, I get an error message, which tells me that this is an improper SQL...

Dear All, once again I need your help, I have no idea how to tackle the following problem. I am taking records of stock market transactions. As a final result I want to have a query which gives me for every end of the day the total value of my portfolio. Therefore I have two tables. The first...

Hi there, I have a table called tblTransactions with columns called (among others) [Date Time], Ticker, Quantity, Price and Commission. Column [Date Time] contains both a date and a time. I want to determine the commission paid per day. If I use the following code I still get all single trades...

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...

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...

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...