|
|
I have two select queries; one for one type of revenue booked by sales reps
which is called 'Bookings' and the other for another type of revenue
generated by sales reps, and this is classified as 'Search'. These two
queries are combined in another query which is a Union Query. This works
fine. Now, I split out the sales rep revenue, by rep and by advertiser, via
a Crosstab Query. All of this works fine. I'm wondering if I can add in
another revenue element, which is a 'Goal'. When I pull in the Goal, through
the Select Queries, the Goal is repeated each time the Rep name appears (the
rep name appears several times to show the Bookings by Advertiser and several
times to show the Search by Advertiser). My question is this: How can I get
the Goal to appear once, either through the Union Query or the Crosstab
Query? Ultimately this will be exported to Excel and I can eliminate dupes
in Excel, but that takes a little work; I'd like to just do everything in
Access if possible. That way, I can just export the final query as a
SpreadSheet and just fire off an email to the recipient...rather than
creating an Excel macro to clean up the Goal-redundancies.
I can post all SQL if that helps; I'm just trying to get a grasp of the
concept at this point. Maybe this is not even possible, but I'd like to know
one way or the other.
Thanks!!
Ryan--
--
RyGuy
|
|
|