output

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janis - 15 Sep 2007 17:46 GMT

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

Reply to this Message

Tom Wickerath - 17 Sep 2007 07:46 GMT

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

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.access&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
__________________________________________

> tblRouter:routerName
> tblUtilization:routerName, weekending date, utilization%
[quoted text clipped - 17 lines]
>
> The

Reply to this Message