Report

  • Thread starter Thread starter mulletteeth
  • Start date Start date
M

mulletteeth

I am trying to make a report. I only want to display a record if a
certain control value is different from the value from the previous
record.
 
Just to correct/clarify myself, I am looking to display only unique
records in a report.
 
You might have to create another query to get only the primary keys for the
distinct records like this using the fields that constitute a distinct
record:

qry2
SELECT *
FROM MyBooks INNER JOIN (
SELECT Distinct author, book
FROM MyBooks
) as qry1 ON
MyBooks.author-qry1.author
AND MyBooks.book=qry1.book
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query design 0
Calculating a value for a new record 2
Query which Value Returns Previous Record 8
monthly/weekly reports 1
Access Access Record Order 0
Access report preview and print only the first page 2
Update field 3
Converting Text to Numeric Value 2

Back
Top