Hi mate,



Thanks for all your help so far! I'm currently making my way through the first query (It takes me a while as I like to digest and understand before I move on), and I've just come up with an idea which would be AWESOME!

So the code is below... What would be REALLY (!!!!) cool would be to get the user to 'Enter' the start date and end date and then provide them with a drop down of what Server they can use and then aggregate (depending on the server chosen).

Feel free to tell me to go and shove my ideas where the sun doesn't shine :-) I'm not trying to get liberties, I just thought this would be a really awesome touch. Can it be done? I'm not expecting you to do it for me, More than happy to do it myself; just a point in the right direction would be helpful!

Code:
 SELECT 
  Table1.*, 
  DateDiff("d",[Start Date],[End Date]) AS [Days In Range] 
FROM 
  Table1 
WHERE 
  [Table1].[Date Entered] BETWEEN [Start Date] AND [End Date] AND 
  [Table1].[SAN Name]=[SAN] AND 
  [Table1].[Aggregate Name]=[Aggregate]
ORDER BY 
  [Table1].[Date Entered];