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

I see, thanks for your thoughts and suggestions. But there is no possibility to do it with a query?

Hi again, thanks for your reply. Please let me clarify my question. All the data I need to get the data I need is contained in tblTrades, i.e. I don't need any further data. In this table I record all my stock market transactions, i.e. each time when I buy or sell a stock an entry is made...

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

Hi gemma-the-husky, thanks for your reply, that helped. The following query works: SELECT Q.sTicker, T.dtDate, T.iQuantity, T.dPrice FROM qryPortfolioHoldings AS Q LEFT JOIN tblTrades AS T ON Q.sTicker=T.sTicker ORDER BY Q.sTicker, T.dtDate; Thanks JapanFreak

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

Okay, thanks, but there is no way to include it into the SQL query? Because the result of that query should at the end of the day be the result of a sub-query which goes into another query...

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

Thank you, that helps!

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

Thank you. Now it works. Thank you!

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

Sorry, that was a stupid question... April 31st doesn't exist. So I simply have to use < 1st day of the following month as the second condition and it works. Sorry.

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

Problem solved. Uncle Gizmo, thank you for your reply. I will consider that going forward. Kempes, thank you very much - yes, that works. Best regards JapanFreak

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