Recent content by 555access

Thanks Gina

And yes, that was me too. :)

Thanks pbaldy Checking out the sample db.

How to make such a SCANNER by making use of Access Database Table? A lot of stock market websites give us the ability for scanning the stocks which fulfill particular criteria / conditions etc. based on different parameters. Just as shown in these snapshots – I want to make something...

It seems that you do not understand how the Stock Market Data works. The solution will obviously show the data for the most recent SYMBOL records only, and that is how it is supposed to be. You might not have read what I explained in the very first post regarding the Dates. I mentioned very...

I am sorry plog for posting your replies. I will keep that in mind in future.:) Now here comes even better method ! Just one query to get all the required fields, no more messing around with multiple queries - ExactaBox @stackoverflow Rocks ! :thumbup: Thanks

Thanks for the prompt reply plog. The current database table has got the data for only 27 Stocks. So it should show only 27 Rows, one row for each symbol. I would request you to have a look at the queries that I have created in the uploaded database. That will make it clear why it should show...

Thanks for the help plog. I do not have much knowledge about the Database concepts etc. I tried to create a module as you told and then created a query by using the SQL code that you posted. Then I got the result as shown in the attached snapshot. I am afraid that I might have made some mistake...

INTRODUCTION TO DATABASE TABLE BEING USED - I am working on a “Stock Market Prices” based Database Table. My table has got the data for the following FIELDS – ID SYMBOL OPEN HIGH LOW CLOSE VOLUME VOLUME CHANGE VOLUME CHANGE % OPEN_INT SECTOR TIMESTAMP New data gets added to the table daily...

Hi I am glad that I have found this forum. Hope to learn a lot from this helpful community. Thanks