Here's my Inception to Date Table sorted by org, fund and account code then filtered to show org numbers equal to or less than 3, and account codes equal to or less than 8999.
My principal investigators (org numbers) are employed in different departments. By filtering data by org number I can show all PIs within certain departments. I guess another way to do this would be to add a column or look-up table for department information.
By filtering data by account codes I can show each PI expenditures only (account codes less than or equal to 8999). This is good because typically PI's are not as interested in the revenue reported on their grants (account codes starting at 9000). They are much more interested in finding out whether they have overspent their expenditure budget.
This might be a disadvantage for that one extremely picky PI who really does want to see (and understands) his/her grant revenue.
2 comments:
well you can't please everybody...or can you? the next unit is about queries which you can customize to your hearts content.
Wow! Your tables look pretty good. After finishing up the query lesson, I can see how you'll find them pretty useful.
Post a Comment