Question on displaying repeating data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rich (rstringer_at_provide.net)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 11:33:11 -0400

Hello,

I am developing a financial application that tracks various aspects of the stock and financial markets. I am currently developing it using Access 2003 although eventually, all the data will reside in SQL Server. Access will still provide the UI.

On 1 form, which has to sections (top and bottom), I want to enter/display opening and closing stock prices for a given company. On the bottom half of the same form, I want to display a given number of historical opening/closing prices. The list will be in reverse order based on the current. For example, the last 10 days beginning yesterday. There will be a text box so the user can input the number of historical quotes. The query logic is relatively simple. Something like:
Select date, opening_quote, closing_quote
from tbl_daily_quotes
where date is in (today's date - 10 days). I obvisously don't know the SQL syntax here, but I think the meaning is clear.

My problem is that I don't know how to display this. How can I set up what I imagine is basically an array or table to display the data?

Also, a little help in getting my SQL Syntax is also appreciated.

Many thanks in advance,

Rich

Relevant Pages

  • Re: Question on displaying repeating data
    ... Ok, I have the subform. ... display more than 1 row. ... The query logic is relatively simple. ... a little help in getting my SQL Syntax is also appreciated. ...
    (microsoft.public.access.forms)
  • Re: newbie question: results by page
    ... "Tony Marston" wrote in message ... your SQL syntax. ... Check the manual that corresponds to your MySQL server ... What I used is "ORDER BY id DESC" since I'm trying to display my records ...
    (comp.lang.php)
  • Re: there are 2 SQL statements, whats different between those?
    ... SQL syntax rules would not allow use of keyword table the way ... you display in sample 1. ... you could use to test validity of your SQL syntax across ...
    (comp.sys.ibm.as400.misc)
  • RE: Help to read and display data
    ... If the data the stock items ... This can per done every time the userform is opened. ... array once or do it every time. ... display it again with the next stock item. ...
    (microsoft.public.excel.programming)
  • Re: Help with sql syntax in asp
    ... > I really struggle with SQL syntax when using VBscript asp. ... > ContactID is an Integer held in the rsContacts array. ... You have an array named "rsContactID"? ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)