Results 1 to 3 of 3

Thread: Query Help

  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Query Help

    Hi,

    I'm a novice Access (2003) user and really need some help!

    I've built a form and subform, the form showing basic customer details and the subform showing the number of jobs done for that person.

    Using that data I've built a query and added both tables but when I run it I fills in the customer details in every row where they have more than one job.

    What do I enter into the criteria so that I could show just the customer details once and then all the jobs.

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Robert

    It doesn't work like that I am afraid. The sutomer details are the same for each job for that customer so they are repeated. There are SQL tricks to do what you want but almost certainly they are more effort than is worth it. You can get something more like what you are after in access reports either by adding a grouping or by setting the textbox hide duplicates property to true

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Pootle's right.

    Having said that, I qualify that statement by saying that there's another step you can take. Simply make your new query the Record Source for a report; you can put the repetitive stuff in a Header Section and the detailed stuff in the Detail Section. That is the surpose of having these features in reports.

    HTH,
    Sam

Posting Permissions

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