Multiple returns of single record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Beautiful! Thank you.

OfficeDev18 via AccessMonster.com said:
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.
Click to expand...
 
Back
Top