SSN query criteria
I would like to create a query which returns only part of the SSN field, basically only the first 11 digits.
I have created a text box on a search form along with a cmdbutton that opens the form. The query has this criteria:
Thank you for taking the time to report an issue.
What's wrong... Please write below.
=DSum("CashforVisit","Financials","Financials.SSN= " & [SSN])
Which worked excellent. However, I need a way to add another criteria to the DSum function, specifically that the payments happenned in 2011. This report grabs information from table Financials, which documents every payment, the SSN of the recipient, and the date of the payment.
Values to sum: CashforVisit
Table name: Financials
Criteria1:"Financials.SSN= " & [SSN]
Criteria2: DateofVisit >= 1/1/2011
I assume to problem is caused by a list box on my form which has as a records source a query with a field:
LastTwoDigits: MID ([SSN], 12,2).
This criteria returns the last two digits on a SSN. This is quite strange because in Access 2003 I don't get any error message. If I remove the listbox then, the error message disappears. I have looked at the references and what is missing is the Microsoft Office Control 1.0 Type Library. I have removed it but still get the problem.
This is the SQL in my query:
SELECT mytable.BGN, mytable.[ssn], mytable.BLN, Mid([mytable],12,2) AS BIC, Left([ssn],11) AS SocSecNo, mytable.Amount FROM Mytable WHERE (((Left([ssn],11)) Like forms!welcome!ssnsearch)) ORDER BY mytable.BGN, Mid([ssn
It is a list of names with SSN. Where there are two names with the same SSN and name, one my have a middle initial and one without one, or any combination with the Initial. I would prefer the one that does have the Initial, but then also get one of the duplicates that does not have this criteria to consider for the next record comparison.
I have an imported table that has only SSN on employees. On another table I have employees SSN and first name and last name and all other kinds of info.
How would I run a querry that would use the SSN's that I got on the one table and display the correct name for the ssn
I want to create a report that will show me the id for each row.
The table design is: employeeID, SSN, Name .
So, I want a report that will show me every SSN and for each SSN, I want to see the employeeID (if it exists) for each table.
The columns for the report would be: SSN, employeeID1, employeeID2, employeeID3, employeeID4, employeeID5, employeeID6
I have a table that contains all the information that I need for my event. The data that is important for this question is the Last Name, First Name, Rank and SSN.
What I want to do is to be able to put the SSN into an access table via a barcode reader. This is not the problem. the problem is that after I input the SSN, I would like the Last Name and First Name and Rank to populate on the table that the SSN is scaned into.
Any help would be better than what I have know.
Also I have another fiels EIN with 7 digits an I need for there to be 2 9's in the beginning. I was goingto use vba but when I go to yp it I only get .value <
Value is tho only option to get. IDK y it does this or how to get it to shop if there is a ay.
payroll: (Store, lastName, PayFreq, SSN (PK), HireDate, EffectiveDate, TermDate, DeductionCode, Deduction, NAD CHAR) AND hrconnection: (Store, lastName, CoTime, Plan, Dependants, HireDate, EffectiveDate, TermDate, SSN (PK), Deduction).
I want to find the records based on SSN that are in the payroll table and are not in the hrconnection tables and then find the record based on SSN that are in the hrconnection but are not in the paypal table.
In this topic:
* Introduction to query criteria
* Criteria for Text, Memo, and Hyperlink fields
* Criteria for Number, Currency, and AutoNumber fields
* Criteria for Date/Time fields
* Criteria for other fields