Multiple returns of single record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jammamom - 15 Nov 2005 18:57 GMT

I've written an underlying query for a report that uses criteria entered via
a form. The query is used to determine the number of items sold at a
particular branch each week. Users enter the beginning and ending dates of
the week and the name of the branch. The information returned in the report
is correct, except that it lists the correct record multiple times.

Suggestions to solve the problem would be greatly appreciated.

Reply to this Message

OfficeDev18 - 15 Nov 2005 19:18 GMT

With the query open is design mode, click on the View menu and select
Properties. Set the Unique Values or Unique Records value to Yes. Play around
with it, and see which one works for you. These values are mutually exclusive.
You can only set one of them to Yes, not both. Both can be set to No, however.

>I've written an underlying query for a report that uses criteria entered via
>a form. The query is used to determine the number of items sold at a
[quoted text clipped - 3 lines]
>
>Suggestions to solve the problem would be greatly appreciated.

Signature

Sam

Reply to this Message

jammamom - 15 Nov 2005 20:46 GMT

Beautiful! Thank you.

> With the query open is design mode, click on the View menu and select
> Properties. Set the Unique Values or Unique Records value to Yes. Play around
[quoted text clipped - 8 lines]
> >
> >Suggestions to solve the problem would be greatly appreciated.

Reply to this Message