Results 1 to 4 of 4

Thread: Stuck...Please Help

  1. #1

    Thread Starter
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    I have a datalist box with a list of invoice numbers im pulling from the a recordset, using the adodc control. Now, i want to have an edit button on my form, and when clicked, pull of the invoice numbers whose length is less than 7. Would I need 2 list boxes or two adodc controls?? Or can i get away with just one of each, using an SQL query. thanks for the help

  2. #2
    Hyperactive Member barrk's Avatar
    Join Date
    Sep 2000
    Location
    My own little world
    Posts
    274

    Question I don't think I understand what you are trying to do.

    Why don't you just pull only the invoices with a length less than 7 in your initial query rather than having an edit button?

  3. #3

    Thread Starter
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496

    ..

    Well, because all of the invoices that have a length of 7 are the correct invoices, the others need to be edited. Any other suggestion out there..thanks

  4. #4
    Guest

    Lightbulb SQL

    Fill the datalist recordsource with a Select num_invoice from invoices where num_invoice <= 9999999, you can use the same datalist or another.

    or

    Select num_invoice from invoices where len(num_invoice) = 7

    my two cents

    [Edited by JuanCarlos60 on 11-03-2000 at 07:58 PM]

Posting Permissions

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



Click Here to Expand Forum to Full Width