output

[Janis]

tblRouter:routerName
tblUtilization:routerName, weekending date, utilization%

What I want to do is output to Excel the fields: routerName & the last 6
weeks utilization figures in columns.

Do I create a form with a calculation field that can figure out what the
last 6 weeks are from all the dates in the tblUtilization somehow. How would
I do that? and add the field for the router Name to this form. The dates may
not be exactly 7 days apart. I just have to output it as a table to Excel so
I need to get it formatted as one table with rows and columns, ie.
RouterName, 9/1, 9/7
Router ubra... 80%, 81%
Router ubrb... 75%, 76% etc.


Or would I do this as a query to both tables. How do I do the query?

tia,

The

 

[Tom Wickerath]

Please see my reply to a similar question that you posted:

http://www.microsoft.com/office/com...cess&mid=89165c68-20b7-475b-9652-ea19073e3dd8

You can add criteria to limit the results to the last six weeks, although
you hadn't mentioned this in the later post, so I didn't cover that. If you
use a parameter type query, make sure to supply the parameters to the
crosstab query. My Crosstab Query document that I pointed you to includes an
example of doing this.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________