Mine was a bad raid controller

Thank you both, this is very helpful!

Thanks Steve! That was so easy I didn't even think to try it!

Thanks Sam, this was very helpful! My first time using CTEs or Windows Functions....pretty slick!

Thanks Jeffrey. This gives me some stuff to research. I am not familiar with linked reports at all. Appreciate the help!

Jeffrey Williams 3188 (9/3/2012)

---

Triality (9/3/2012)

---

Thank you for the direction, however none of these examples are applicable. My clients have access to these reports, so I don't want a parameter...

Thank you for the direction, however none of these examples are applicable. My clients have access to these reports, so I don't want a parameter driving the data source,...

bump

Still stumped on this one...any ideas?

Lynn it sounds very similar to our environment. These power users do amazing things with MS Access -- stuff you aren't supposed to be able to do. However,...

The problem is this is what the data analysts have used for 10+ years. The data is far exceeding the 2GB file size limit of MS Access, but this...

Is seems like it completely defeats the...

Lynn - very good info to know. Thanks for sharing!!

Paul - If the MS Access database is saved on the SAN, do you know if the temporary tables are...

Thank you very much for your response, Paul. You are correct, I am talking about a linked SQL table in MS Access.

This actually helps quite a bit...

Sean Lange (4/25/2012)

---

If you are just using this as random dates just update your table to change the 2/29 values to something else, or delete them. Then your previous update...