Raminhos wrote:
Hi,

Thanks again for helping with this. To be honest, I've decided to
just pull
all the data into Excel and manipulate it from there.

Shame. I was just about to suggest something like this:

SELECT Copy_Of_Closed_."_2", Copy_Of_Closed_."_4",
Copy_Of_Closed_."_8", Copy_Of_Closed_.BriefDesc,
Copy_Of_Closed_.Caller, Copy_Of_Closed_.Category,
Copy_Of_Closed_.Channel, Copy_Of_Closed_.Module, Copy_Of_Closed_.Ref,
Copy_Of_Closed_.Solution, Copy_Of_Closed_.Version, Copy_Of_Closed_."_2"
FROM Copy_Of_Closed_
WHERE Copy_Of_Closed_."_2" BETWEEN (CURRENT_TIMESTAMP-8) AND
CURRENT_TIMESTAMP;

CURRENT_TIMESTAMP is the ANSI standard way of getting the current
date/time so has the best chance of being understood by your DBMS. Some
don't adhere to the standards and have their own proprietary syntax
e.g. with MS Access/Jet you one must use NOW().

Jamie.

--