Recent content by Cero21

Worked! Thanks.

Basically here is what I have. Equipment(Type(key),Unit (key), allocation, Jan, Feb, Mar, Apr..., Dec) Type is the type of equipment it is (ie glowsticks). Unit is the unit number which holds the equipment (we have 4). Allocation is the number of each equipment they initially started with. The...

Any ideas?

I'm using the same thing you showed me above for "allocation".

Each month is a number type so the user just types in how much was used for each month. ie. JAN - 10 Feb - 20 etc

Well, I guess I found another question related to this. How do I sum these results together? Here what I got. As well as allocation I have fields for every month and would like to have quarterly sums. So now I can find the sum for each month but how do I add 3 months (results) together?

Exactly what I was looking for. Thanks!

I have a table with 2 primary keys: Unit and Type Each record has a field called allocation(number) What I would like to do is find the total "allocation" for each type in a query. Another way of putting this is I would like to know my total number of items from all the units combined broken...

Thanks a lot guys that worked out great. I would have never figured that out myself!

Oh ok. Makes sense. I'm going to go the button route. I typed this into a click event for a button Private Sub Command68_Click() strSQL = "INSERT INTO Deployed Personnel Archive " _ & "( [CFTPO], [Service Number], [Unit], [Name], [Initals], [Rank], [Gender], [Operation], [Start Date], [End...

Thanks for your quick response Remou. Just a question on that. Would I place that code in the "event action" for a form button or create the append query and link it to a "run query" form button?

I would like to know if I can copy one record (the currently displayed one) from one table (the table the form is based off of) to another table using a form button. I've been searching but all I've found is how to move all the records at once. Anyone know how to do this? Thanks.

Nevermind my last. I just added the code to the on enter event. Thanks.

I've decided to go with your first idea as it makes the interface in this case cleaner. Just one more thing now that I've been fooling around with it. Is it possible to have the colours show up right away? Right now the combo boxes are white until I change them, then they change to the colour...

Sorry about the question title I was thinking about filling the deployedpersonnel table with the Name and Initial fields from the Personnel table and have those field automatically fill when selecting the corresponding service number. I more appropriate title would be: Showing related table...