Okay, I started a formal poll.

Are you looking for the date range a customer was active, or are you asking how many days a customer was active given a specified data range?

Now for something totally the same...

How many people, besides...

Sibbs (4/29/2009)

---

Hello,

I have been implementing some session source tracking on our SQL servers, and am unclear on any difference between the APP_NAME() and PROGRAM_NAME() functions.

Most of the code examples I...

But how many of you can actually visualize Darth Vader and Yoda working together??? :w00t:

Mh (4/29/2009)

---

GSquared (4/28/2009)

---

It's an undocumented table that SQL Server uses for it's own stuff. Basically, don't even try to change anything in it, but it can come in handy...

I hope the following code will help you:

/*

ORDERID DeliveryDate Price UnitId Status

2765 2009-02-13 00:00:00.000 49.95 4 Completed

2765 2009-02-13 00:00:00.000 9.95 89 Completed

2765 2009-02-14 00:00:00.000 49.95 89 Completed

2766 2009-02-15 00:00:00.000 19.95...

Roy Ernest (4/29/2009)

---

I am reaching that magic figure of 1000. But that does not mean I know anything. But I try to learn from reading the solutions to different problems...

And yet, I managed to redeem myself in that very same thread! (The silence in the desert is deafening!) 😉

Scott Roberts (4/29/2009)

---

Jeff Moden (4/29/2009)

---

Scott Roberts (4/29/2009)

---

Sorry about the confusion over mis-matched data sizes for RawData. The RawData column used to be VARCHAR(300) but we encountered a new format that...

How about you first try to fix the things we have already noted for you in what you originally posted? I pointed you to a logic error that I...

As it is, I really need to check the forum of question before I post. Really sad when I post a SQL answer in an Access forum.

john.arnott (4/29/2009)

---

Jack Corbett (4/29/2009)

---

Lynn Pettis (4/28/2009)

---

You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his...

Try something like this:

SELECT DISTINCTROW JKTime.PayrollWeek, JKTime.Mechanic, JKTime.JobID, JKTime.TimeType, Sum(JKTime.Time) AS [Sum Of Time]

FROM JKTime

GROUP BY JKTime.PayrollWeek, JKTime.Mechanic, JKTime.JobID, JKTime.TimeType

HAVING (((JKTime.PayrollWeek)=#1/1/2009#));

You will need to change the date for PayrollWeek

Sorry, I didn't realize this was Access when I posted the query. Don't know enough about Access to help at this point. Let me do some research and...