Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Skipping records (Access 2003)

    I have a file that I get from another system. A client can have 2 associated records - one for debits and one for credits. When running a total report, my numbers double because the credit and debit are there twice (sorta hard to explain this process). Anyway, I need to count it only once.

    I thought about merging the two records to make one...apparently I did not know what I was doing because it did not work. Is there a way, on a report, to only add one record before it moves to another person.

    attached is a spreadsheet that shows how the data in imported. My report is very similar.... I would like to either get one record per client or read a record, then skip and then next person. A catch here is that I have some people who only have a charge not a payment. So they only have one record.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Skipping records (Access 2003)

    You can create a query with the fields that you need.
    In design view, click in an empty part of the upper half of the qiery window.
    Activate the Properties window.
    Set the 'Unique Values' property to Yes.
    Save this query, and use it as record source for the report.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Skipping records (Access 2003)

    I did this and it did not work. The charge amts are different so it makes each record still unique. I still get 2.

    Thanks for the suggestions...any more???

    Deb

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Skipping records (Access 2003)

    Instead of setting the 'Unique Values' property to Yes, you could create a Totals query that groups on account# and takes the First of the other fields.

Posting Permissions

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