Hi, I am using this query to retrieve teh data in crosstab for last 5 days.
TRANSFORM Count([Closed ID].[ID]) AS [CountOfID]
SELECT [Closed ID].[RC]
FROM [Closed ID]
WHERE ((([Closed ID].[Create-date])>Date()-5))
GROUP BY [Closed ID].[RC]
PIVOT Format([Create-date],"yyyy/mm/dd");
Now, if there is no data on a particular date, the query does not populate
blank columns in crosstab.
I tried adding the dates forcibly on the Column headers but no luck.
Is there any other way to retrieve all columns? My collegue just blindly gave
me an hint of achieving this with Union query. Can this be done with Union
query?
Thanks,
Prasanna.
"Heaton, Timothy H. (USD)" <[EMAIL PROTECTED]> wrote:
You can't assign them randomly AND evenly, but you could employ
elements
of both. Why not just cycle them between the reps (ABCABCABC)? Don't the
leads arrive "randomly" for all practical purposes? Otherwise you'd have
to write an algorithm that switches between random and "catch up" for
those have been cheated by the random assignment. But why???
-Tim
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Lisa
Sent: Sunday, October 21, 2007 7:43 AM
To: [email protected]
Subject: [Access VBA Central] Assigning names to records randomly
Hopefully someone has a solution for me. I receive sales leads on a
daily basis and I need to assign those leads to our inside sales reps
randomly.
I have tried different approaches, but it doesn't distribute the leads
evenly (one person may get 6, while the next person only gets 2).
Thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
