Results 1 to 5 of 5

Thread: list of dates

  1. #1
    Join Date
    Dec 2010
    Posts
    3

    Red face Unanswered: list of dates

    I have a form with a pop-up calendar that posts a date to a text box and saves it to a table (HHclient) in col Visits. Now I want to display the last x visit dates in a combo box or list box or something. Help!

    It si Allan Brown's calander and posts the date as cboStartDate.

  2. #2
    Join Date
    Dec 2010
    Posts
    31
    In the Row Source of your combo box you will need the following:

    SELECT TOP x Visits FROM HHclient ORDER BY Visits DESC

    Just change 'x' to however many of the last dates you want in your combo box.

  3. #3
    Join Date
    Dec 2010
    Posts
    3

    List of dates

    Thanks! That works great for the last date for every client. What I want is a list of dates for just the current client (HHClientID). In HH Client I have LastName, FirstName, ... and Visits. That just stores the last visit, Where do I get a list from?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    So put a where clause on the select
    AND
    put a LIMIT (Offhand I think Access/JET SQL uses TOP

    eg
    WHERE HHClient = avalue

    note if HHCLient is string/text/char you needs to put it in quote makes

    its either
    SELECT TOP(X)
    or
    Select balh di blah limit X
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Dec 2010
    Posts
    3
    What? O.K. so I am an ignorant newbe. Please spell it out for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •