lisaeileen
Last Activity: Jun 25 '12, 07:08 PM
Joined: Feb 2 '12
Location: San Antonio
-
I am keeping historical data - this database is new - I'm just now starting to see people rotate in and out of the the positions. -
Sorry, I confused again - Is this what you are looking for?
...Code:SELECT tblGarrison.Garrison, tblCEDAPPositions.GarrisonType, tblCEDAPPositions.GarrisonDutyTitle, tblCEDAPJunction.EmployeeID, tblCEDAPPositions.PositionLevel, tblCEDAPJunction.PositionStart, tblCEDAPJunction.PositionStop, tblCEDAPJunction.Remarks1, tblGarrison.Region1, tblDirectorate.Directorate, tblCEDAPJunction.ProjectedDeparture, tblCEDAPJunction.ProjectedDateofBackfill,
Leave a comment:
-
Sorry about that and thanks for the quick reply - here is an example. I included one line in red - it shows an individual who arrived and departed from a position - I need that position to show up on the roster as well but with a blank EMPLOYEEID. The roster should only show those individuals currently sitting in a positon and those positions that are currently vacant....Leave a comment:
-
Position Query, when start date blank
Good Afternoon All.
I have a question - believe it might be something simple and I'm just not "seeing it."
I keep track of over 1K personnel - I want to run a query that gives me an alpha roster (all 1K by name etc). The roster looks good initially but those positions that are vacant (e.g. I had someone in there and they have since departed) do no show up on the roster. I'm sure the problem centers around... -
NeoPa,
Garrison refers to the base that is submitting the information (it is a number because it is pulling for another table). There are 100+ bases reporting information. Each month, each garrison will give me their gains and losses for the previous month. I only get one submission, per garrison, per month. I was given each garrisons starting strength as of Oct 2011 - they are now reporting only their losses and gains per month....Leave a comment:
-
C CSR and NeoPA - thank you both for the responses. To answer your questions - yes, there should be two fields - a starting field for the beginning of the month and an ending field. As the garrisons submit their numbers for each month - I'll update their gains and losses - this information will be added and subtracted from the starting number. Once all the garrisons have submitted their numbers for a month - that total will need to be moved to...Leave a comment:
-
Automatically using end of month total for beginning of next month
Good Afternoon Everyone.
I need some help with Access. I am keeping track of a huge amount of data and am trying to simplify it as much as possible. Here's what my table looks like :
Table
...Code:[B][U]Field Name Type [/U][/B] GarrisonInput2ID Auto number Garrison Number MonthYear Date/Time TempLoss Number TermLoss Number VSIP/VERA
Last edited by NeoPa; Feb 3 '12, 12:23 AM. Reason: Incorporated table layout into the post for much easier viewing
No activity results to display
Leave a comment: