Brian,

Thanks for you help, much appreciated.

I am an EE and do not have any experience with this but will play around your suggestions.

Just adding the date column has been a...

One thing I am confused about is where the date comes from in the SQL database.

Is this something that is automatically generated by default and always there, or does the...

Thanks for the ideas.

How do I create a filter to pull data for the past 7 days?

I found this but not sure is the right approach:

http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/build_query_4.html

• This reply was modified 3 years, 9 months ago by  jnbrown.