Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2005

Tip: Looking for answers? Try searching our database.

Count Duplicate Fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ben - 03 Dec 2005 19:51 GMT
This is the last step in completing my database.  Here are the specifics:
I have a report based on an order form based on table "tOrders".  Some
customers have multiple orders.  I used conditional formatting in my report
to have certain text boxes turn yellow if a customer appears more than once.  
I used this conditional formatting:
DCount("*","tOrders","[Last] +  [First] = " & Chr(34) & [Last]+[First] &
Chr(34))>1

Now I would like the report to count how many times a particular first and
last name appear and display it.  For example, Joe Smith ordered a prime rib,
a turkey and a spiral ham.  Next to his name on the report I want it to
display the number 3.  If a customer has only a single order (no duplicates)
I want that display to be blank.

I created a "find duplicates query" and was able to get the count there.  
However, when I try to bring that query into the report it won't allow me
because I am using  a table and a query based on that table.  Of course.

I dunno'.  I'm sure it's very easy, but I'm really burnt out on this thing
and need a little help.

Thanks,
Ben
Duane Hookom - 03 Dec 2005 20:41 GMT
There should be no reason why you can't add your find duplicates query to
your report's record source. This is fairly common practice. Did you get an
error message? Your solution is probably what I would have recommended.

Signature

Duane Hookom
MS Access MVP
--

> This is the last step in completing my database.  Here are the specifics:
> I have a report based on an order form based on table "tOrders".  Some
[quoted text clipped - 23 lines]
> Thanks,
> Ben
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.