Results 1 to 2 of 2

Thread: Data report Wizards in 'ere!

  1. May 2nd, 2002, 08:50 AM #1
    GrImShEePeR
    GrImShEePeR is offline

    Thread Starter
    Junior Member
    Join Date
    Apr 2002
    Posts
    18

    Data report Wizards in 'ere!

    Hi Peeps!!

    Can someone help us out a lil bit

    ok, i have a data report, and i want to create data reports with a layout of one customer per page, with their details surrounding it!

    Ok, on my main form i have a customerID.text box, and the surrounding ADODCs are controlled by this..... what i want to do is have a report which ONLY shows the report for that specific customer, again just relating to the customerID entered in the text box.....


    Anyone know how to do this or at least can point me in the direction???

    Ive been racking my brains on the SQL trying to do it, but am not that confident at SQL to be sure if im doing it right, or even in the right place!!

    Any help is apprectiated, thanks peeps
    Reply With Quote Reply With Quote
  2. May 2nd, 2002, 11:00 AM #2
    Arc
    Arc is offline
    PowerPoster Arc's Avatar
    Join Date
    Sep 2000
    Location
    Under my rock
    Posts
    2,336
    The SQL to return a single customer based on his CustomerID would be

    SELECT * FROM Customers WHERE CustomerID = 'His/HerID'
    -We have enough youth. How about a fountain of "Smart"?
    -If you can read this, thank a teacher....and since it's in English, thank a soldier.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width