Recent content by marshallb

I have a split view and I am only able to filter one column. for enstance, I need to be able to port by "Status" and then by "Location". I apply the first filter to only select tasked personnel. I then attempt to sort by "Loacation" and it only shows "Sort A to Z", "Sort Z to A" and "Text...

Thank you for your help. I found a way to do it that actually makes it easier. On to my next step. I am able generate a list that gives me the numbers of each AFSC (qryAFSC Assigned), but I am trying to set up another query to show me how many of each AFSC has an estimated return date...

I have not worked with SQL yet. I am not even sure where to start with that. I am trying to count the number of times each AFSC appears in that field on my personalinfo table. I have tried using Dcount but didn't get that to work either. My ultimate goal is to be able to create a report with...

I have a feild on one of my tables that lists all of the different "AFSC's" for the personnel I track. I need to count the number of times each AFSC appers in that appears in the field. I have asked google and been through several pages here and can't quite wrap my head around it. This is the...

I have read some on normalization and i think i have a basic grasp. What i am still unsure of is how to get one table to pull data from another table based on certain information (such as SSN). i will post a sanatized copy of my db so that you can take a look if you are so inclined (if i can get...

I didn't think of that. I do indeed have several people with the same last name. I think I may just go with a lookup field for each column. Will begin working on those. Thank you both for your help.

I will have to make a sanitized copy and post it here. Thank you for your help.

I feel a little ashamed to admit this but you are talking over my head a little. I am not sure what an FK and PK are. The tasks are only assigned to one person at a time. I think I may sanitize a copy of the db so that I can post it if neccesary. Until I get this figured out I may just...

My database is used to track Name, SSN, DOB, etc. I am trying to incorporate tracking my members taskings and deployments as well. I had originally built it to use the SSN as the primary key. Unfortunately if I need to move a tasking from one person to another I have to retype all of the...

I get an error "Microsft Office Access can't find the object 'Me'" Where did I go wrong.

I have a combo box with Last Name, First Name and SSN that I am using to input the last name. I could use this to update the SSN field when I choose the Last Name, correct? Would it look like this? Me.SSN = Me.Combo168.Column(2) Also, does this go in the After Update of the Last Name? (I...

Thanks for the fast response. I put the form name in and i am still getting an error. When I look at the info on the error the circular reference is highlighted. I have cut and pasted the string to ensure that I have it right. The form and table are used to track taskings to my unit. Quite...

I am trying to use dlookup to pull SSN's from a different table based on the last name. This is on a splitform. I have included the expression I am trying to use. I have been wrestling with this for a week or so and stumbled accrss this site. Can anyone help me...