Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Ohio
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2k report no showing info (Access 2000)

    <img src=/S/broke.gif border=0 alt=broke width=31 height=23>
    I have a report setup that uses a parameter Query to get info from a table with all of our job routings for work. We have about 1000 jobs and about 99 percent work fine. But with a few of the the info doesn't show in the report.
    If I run the query without the report its there but not with it.
    I've tried reentering the jobs but it still does not show in the report.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2k report no showing info (Access 2000)

    Are you getting any error messages or what tips you off that some records are missing? If records don't appear in a report it means that they don't meet the criteria for the report. Check your report and make sure you aren't applying any filters, etc. Also check your sorting and grouping to see which fields you're grouping on. Then check those fields in the query to see if any of them are null. That would result in records showing up in an unexpected location in the report, which might make it appear they were missing.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 2k report no showing info (Access 2000)

    Can you find where the jobs should be on the report? Perhaps the info is there, but the way your sorting/grouping is defined has consolidated its data with that of another job?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    New Lounger
    Join Date
    Feb 2001
    Location
    Ohio
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2k report no showing info (Access 2000)

    There are no error messages. The table includes all the operations that we do on all our jobs. Each job may have up to 30 records, one for each operation that has to be performed to complete the job. Each record then has the pertinent info for that operation, furnace temperature, crew size, customer specifications, method and so on. So when we run a job we have to put a method sheet (the report in question) out on the floor to the men to doing the work. The same report is used all over the shop, but we use the parameter qry to pull up only the operation (record) that is used at that area of the shop.
    So each report has only the record that we want for that operation.

    When we run the other operations (records) for the same job they show show up on the report fine.
    When it doesn't work properly the report comes up with the requested job number showing and the requested Sequence which are part of the record but the balance of the infor shows blank.

    As I mentioned before if I just run the qry without the report it shows up fine. Also same sequence (record) number shows up on other jobs. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  5. #5
    New Lounger
    Join Date
    Feb 2001
    Location
    Ohio
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2k report no showing info (Access 2000)

    Plese see my reply to Charlott
    Thaks

    John

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2k report no showing info (Access 2000)

    All I can tell you is what I've learned from 10 years of working with Access--if data doesn't show up in a report, there's something wrong with the data. You're saying that a job may have 30 operations and that one of the operations is not showing up for a particular job. That strongly suggests that you triple check the data for that operation, not the sequence number but the record itself. If everything else shows up fine and that one doesn't, then start trying to figure out what's different about that record. If the operation in question shows up in the query but not the report, is the query for all records or just for the job in question? If it's for all records, filter it down to the job in question and see whether the operation is still there. Sometimes conflicting keys in a record can bite you in reports when you least expect it.
    Charlotte

Posting Permissions

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