I know you can go into a query and put in [Enter Employee number here.] and pull up certain items in your rows. Can you also put in "example" January and pull up the "COLUMN" for January and keep all of the information in the rows?
Example 1
Query is set up this way right now. These are the columns.
Sheet, Jan 03, Feb 03, Mar 03, Apr 03, May 03, Jun 03, Jul 03, Aug 03, Sep 03, Oct 03, Nov 03, Dec 03, Budget, Remaining, Total
Hours, Indirect Costs, Direct Costs, Monthly Totals
Example 2
I would like to be able to have a prompt to where when they open the query it will just pull up the following columns … Using whatever month they enter
If they put in January it would pull up as follows:
Sheet, Jan 03, Budget, Remaining, Total, Hours, Indirect Costs,
Direct Costs, Monthly Totals
If they put in February it would pull up as follows:
Sheet, Feb 03, Budget, Remaining, Total, Hours, Indirect Costs,
Direct Costs, Monthly Totals
Example 1
Query is set up this way right now. These are the columns.
Sheet, Jan 03, Feb 03, Mar 03, Apr 03, May 03, Jun 03, Jul 03, Aug 03, Sep 03, Oct 03, Nov 03, Dec 03, Budget, Remaining, Total
Hours, Indirect Costs, Direct Costs, Monthly Totals
Example 2
I would like to be able to have a prompt to where when they open the query it will just pull up the following columns … Using whatever month they enter
If they put in January it would pull up as follows:
Sheet, Jan 03, Budget, Remaining, Total, Hours, Indirect Costs,
Direct Costs, Monthly Totals
If they put in February it would pull up as follows:
Sheet, Feb 03, Budget, Remaining, Total, Hours, Indirect Costs,
Direct Costs, Monthly Totals
