Re: Duplicates returned in report -- DISTINCT, DISTINCTROW

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Teri,

Thank you -- same to you

Do you have a main report/subreport? Or are you using grouping?

When you select UniqueValues*, the SQL will change from

SELECT field1, field2, etc

to

SELECT DISTINCT field1, field2, etc

IF you select UniqueRecords*, the SQL will change to

SELECT DISTINCTROW field1, field2, etc

UniqueValues and UniqueRecords are mutually exclusive -- you can only choose one of them. They are part of the Query properties

1. turn on the properties window
from the menu --> View, Properties

2. click in a light gray area of the query that is not a column or a fieldlist

The titlebar of the properties window will say "Query Properties" -- there, you will see these properties


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

Teri wrote:
Hello Crystal, it is a pleasure to "meet" you!

Thank you so much for your response, I truly appreciate it. In your reply you first mention going to the record set of my FORM, I have not created a form. I am working with a REPORT. Would it be the same? I did go into my report's properties, found the recordsource property and went to my query through it. I right clicked on the upper gray area of the query (I believe you meant where the table(s) used are shown) and found the uniquevalues selection and changed it from No to Yes. I saved it and ran my query, there was no change, I am still getting a return of multiple cards for the same recipe. When I checked the SQL view of my query, it makes no mention of unique values. Did I do something wrong?

Thank you again for trying to help me.

Teri.

"strive4peace" <"strive4peace2006 at yaho" wrote:


Hi Teri,

try this:

in the recordset for your form, set UniqueValues = true

1. go to the query builder for the recordset
turn on the properties window
click the ... in the RecordSource property for the main form
2. right-click in a gray area of the query
3. UniqueValues --> true
4. close and update the SQL

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

Teri wrote:

I have downloaded an Access template from Microsoft.com for recipes. I am creating a report so that I can print out recipes (with ingredients and instructions) in the form of a 5x8 index card. I have gotten the form to work properly as far as having all the necessary information included and fitting on the card. My issue is that I now get anywhere from 5 to 10 of the same card as opposed to 1 card for each recipe. Any ideas on how I can get Access to return just one card for each recipe?

Thank you so much in advance!!

Teri.

.

Relevant Pages

  • Re: Duplicates returned in report -- DISTINCT, DISTINCTROW
    ... SELECT DISTINCT [Recipe Ingredients].Quantity, Recipes.Instructions, ... UniqueValues and UniqueRecords are mutually exclusive -- you ... They are part of the Query ... instructions) in the form of a 5x8 index card. ...
    (microsoft.public.access.reports)
  • Re: Select Distinct
    ... You do that either by going into the SQL view, ... looking at the Properties for the query and setting the UniqueValues ... I tryed to do the help function but no examples... ...
    (microsoft.public.access.queries)
  • Re: How to split report on Group data.....
    ... Create a query. ... Drop the Group and ProductName. ... white space near a table and set the properties to UniqueValues = Yes. ...
    (comp.databases.ms-access)