Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Grabbing Last Six Digits Of Social Security Number


hello,

simple problem. how would i grab just the last six digits of a social security number?
example: 123-45-6789 to 456789

I'm guessing that I should use the Format function, but I'm not quite sure how to write it. Thanks!

G


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Report To Only Show Last 4 Digits Of Social Security Number
I have a report to print that only shows the last 4 digits of the Social Security field. How can I do so for the entire list of social security #'s.

Thanks in advance.:cool:

View Replies !   View Related
Hide Social Security Number
I have a database for which I would like to disguise a social security number (123-45-6789) with stars (***-**-****) in my form, but only for a group of people for whom "Employee status" is "Staff". The SSN will not be entered in this particular form, only viewed to double check for all individuals who are not "Staff". Can anyone suggest how to do this? Thanks!

View Replies !   View Related
Search Queri Social Security Number
HI

I have a query that looks like this:
Like [Forms]![Searchaddress_form]![search_3] & "*"
The filed name is "ssn"

In a form I have an unbound field that is called "search_3" and when I type a number or more and hit enter it's supposed to look it up in the table. But it´s not working

FYI! It works whith letters. I have the same query for searchin first name and it works.
But not with numbers.

Any suggestions?

//Mikael

View Replies !   View Related
Social Security Alternatives?
Hi,

I need a natural unique id for current and new enrollees, and I do not want to store social security numbers. If a new person enrolls, I need a way to know if they're already in our system.

I was wondering if a lookup table would work, where you switch a random autonumber for a social. If this will work, is it more secure than simply storing the socials?

Thank you!

View Replies !   View Related
Social Security Masking On A Form
I have a form based on a table where social security numbers are entered. I would like to enter a social security number on the form and once it's entered the first 5 digits are masked. When I go to the table I would like to see the complete social security number displayed. Is this possible? Can the control source on the form be formatted to hide the existing social security numbers as well so they don't have to be rekeyed with the new format?

Thank you in advance:cool:

View Replies !   View Related
Social Security Numbers Used As Identifiers.
G’day all.

I am posting this on more than one site but that should not matter simply because it asks for an opinion and, as such, your opinion should not be construed or even considered as an absolute answer…valued yes, absolute no.

What issues may emanate from using the US SSN, or equivalent numbers in other countries, as an identifier for unique records in a database?

Legal?
Voluntary?
Not under local database control?
And anything else you may care to mention.

Please, members from foreign countries to the US, you are welcome to add your thoughts here.

And please also, this is not about anything you may wish to take up with the Federal Court, Privy Council, High Court or whatever in the future in your country. It’s about your understanding of the situation as it stands, at the moment, in your country.

That’s about it…what do you think?

The following three links should take you to the other two sites…
(Sounds like a bit of gobldegook but you are already on one of those sites.)

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=3&Number=1001301&page=0&view=collapsed&sb=5&o=&fpart=1
http://www.access-programmers.co.uk/forums/showthread.php?t=93569
http://www.accessvba.com/forum/showthread.php?t=17057





Regards,
Chris.

View Replies !   View Related
PageUp Gives Last User Social Security
I have a database that keeps track of vositors to our center. A student recently complained because after signing in he hit pageup and his social security was displayed.

Students enter thier number and pick a subject and class from drop downs and thenclick sign in.

Is there something I can put in the Onclick event that would not allow a new user to view the previous users info?

Thanks

Tricia

View Replies !   View Related
Change Number Of Digits To 5
have a query with a field that contains numbers with 3,4,and 5 digits. I want to format it so it displays all as 5 digits by adding 0s to the front of the number. EX:

324
4856
45634

change to:
00324
-4856
45634

Help please. Dont want to do it in VBA either. I would rather build it as an expression field or something.

View Replies !   View Related
Currency Convert From Digits To Number
dear frnd,

i have a access program for printing cheque. i want to use a text box which automaticaly convert number ito digits from user input text box.

View Replies !   View Related
Need Longer Then 9 Digits In Number Type Field
I need a field to permit only numbers. Upon selecting number for the data type I select Long Integer for a longer number... But it only allows 9 digits.. I need it to allow to enter in longer numbers... Any help?
Thank you very much in avdance

View Replies !   View Related
Define Number Of Digits In Table Fields
I'm just to work with Fox Pro, and I am therefore puzzled with how to define the exact number of digits in a field in a table in Access. If I need 9 digits + 2 decimals in a number filed, how do I define that in design view?

Also, I need to know how to export a table into a text file, with a format without any spaces, and each record is divided with a new line. This an old IBM text format file.

Thanks, Torsan

View Replies !   View Related
Update Query For Number Less Than 8 Digits Long
Hi there

Im working on an update query to add 2 zeros to the front of a field where it is less than 8 digits long. I'm not sure how to go about this, can anyone help me out?

Cheers

View Replies !   View Related
How Can I Limit Number Of Digits Entered In The Text Box? Please Help!
Hi guys,

I have a text box, which requires a 8-digit number entry. I have wrote the code to check that the length is 8 and if it isn't a label will turn visible next to the field telling the user entry must be 8 digits.

This works for when i enter a number less than 8-digits but when i input a number with more digits as it does not fit into the text box it turns it to a scientific format value and when the code runs it shows the length is actually 8! And therefore the entry is valid!

I.e. when i input 123456789 the text box shows 1.23E+08 which is 8 charecters!

I dont want any error messages to pop up as i handle them by code and use labels to show the error message next to the problem field and i would like to keep this consistent. Is there any way i can do this by a function or a property in the table or form?

I appreciate any help/advice

cheers

View Replies !   View Related
Creating A Social Network Database
Hi everyone, I am hoping someone will be able to help me with a problem I have. I am undertaking a social network analysis and in order to do this I need to be able to create a matrix with the following format:

Group Person
J Smith G Fowles M Jones
X 1 0 1
Y 0 1 0
Z 1 1 0

I also need to be able to store and retrieve personal and group level details. Note that people can be in more than one group and groups can have more than one person. My problem is that the data has been gathered by another institution and is only available in the following (Excel) format.

Group Person Role Group Characteristic .....
X J Smith Strategist Level One
X M Jones Supporter Level One
Y G Fowles Financer Level Three
Z J Smith Strategist Level Ten
Z G Fowles .... Level Ten

Any idea how I can go about doing this? I know how I could do it if I manually entered the data, but because there are literally thousands of individuals (and a whole heap of groups too) I am hoping hoping hoping that I can do it using Excel and Access. Any advice would be incredibly appreciated.

Thanks everyone!

View Replies !   View Related
Grabbing Max Or Min Values
Hopefully this is an easy one. I've got a table with (for example) a list of books sold (field 1) and the price they each sold for (field 2). There are duplicates in both field 1 and field 2. I'd like to create a new table that has each book's name exactly once, and the maximum value it sold for. How can I do that?

Thanks!

Ivan

View Replies !   View Related
Please Help With Grabbing The Domain ID Of A Form User.
I would like to know who is using a form I am soon placing on our network. I would really like to have the database locked down by domain authentication, is this possible? I can go into the files properties, but I was hoping there was a way to do this within the DB itself. Perhaps locking certain parts of the database depending on domain security groups.
If this isn't possible, is it possible to grab the user's ID and have it stored in a field? Each time a form is submitted, I would like it to track who is making the submissions.
Thanks in advance for any help

View Replies !   View Related
Grabbing Oracle Login From A Linked Table
Not sure if this is possible but I have in my db a linked ODBC connection to a table. I use a Oracle 8 login to access the linked table. My question is can I capture the user login in ID somewhere in my table to show who is logged in? Thanks...

View Replies !   View Related
Grabbing Values From A Table Based On Form Entry
In my database I have 4 tables for a small painting and decorating business.

These are:
tblCustomers, tblOrders, tblStock, tblPayments.

I have a form based on tblOrders to add new orders when they come in from customers.

In this form there are 3 important fields: "CustomerID" (Lookup to tblCustomers), "StockID" (Lookup to tblStock) and Quantity (Entered by user).

However, I want a calculated field that will be worked out automatically when the user is entering these details. The calculated field should go to tblStock and grab the "Cost" field.

However the main problem is specifying what price it will grab from the table. I want it to get the "Cost" where "StockID" = (the stock ID selected in the lookup). I then want to multiply the price by the quantity which the user has entered.

The control source should be worded something like:
= ([tblStock]![Cost] where [StockID] = StockID)*Quantity

but that isn't valid.

Could anyone point me to a piece of VBA or some way to get around my problem?
Many thanks for any help,
Stephen

View Replies !   View Related
Grabbing Time Values From Table In Visual Basic And Performing Calculations With Them
Hi,

My boss wants me to program in visual basic, instead of using queries, a calculation between times, which values are gotten from a table. How do I perform a calculation between two fields from a table in code and what functions are there to calculate the amount of difference in minutes between times in visual basic? THANK YOU SO MUCH IN ADVANCE!

G

View Replies !   View Related
Last 4 Digits Of SSN
I have a database that uses the SSN as the primary key, but only the last 4 digits of the SSN need to be shown on the reports that are generated. I can't figure out how to use the Left function to extract only the last 4 digits. For example if a SSN were: 123-45-6789 I would want the field to read ***-**-6789, or just 6789 whichever is easiest. I would appreciate any help that could be given.

View Replies !   View Related
Last 4 Digits Of Ssn
I need to pull only the last 4 digits of the SSN. How do I do that in my query?

View Replies !   View Related
Compare Digits
Hi there!
I'm bulding this database where the user will have to insert a full phone number. What I would like to know is? if is there any way where Access can pick the first 5 digits of the number to compare with information already imputed in. by example if the user input the number 01942789789, access pick the number 01942 to look for a match? I know I could do with two diferents fields one for the code number and other for the number, but my boss only want one field. Is there anyone that could help me

Thanks

www.joaobeca.co.uk

View Replies !   View Related
Sort By First 2 Digits Only
Open the database – then open the Report: rep_Billing

I have a query that is doing some sort and count functions. The column [TYPE] is sorted then counted. Instead of sorting by the full name can the query sort based off of the first 2 characters?

Example:
On the report the first company is: AMERICAN POSTCARDS

First it separates the colors, which is good.
Then separates the [TYPE] then counts the total amount that color was that type.
However I do not want the full type to be separated out, I want it based on the first 2 characters so that the “N-“ will all stay together as a group.

Final count should say: AMERICAN POSTCARDS
GREEN RA 3
RED N- 14
RED PR 16
RED RA 12
BLUE NC 1

I know I can get this info from the report, but it has to be done at the query level because it is going to be exported into another system at that point. Thanks.

Let me know if I need to make this clearer. Thank you all.

Travis

View Replies !   View Related
Show Everything BUT The Last 3 Digits
Hi,

I am writing a very very simple query to identify postal codes from a list of addresses. The table containing the data has a field called POSTAL_CODE.

I need to exclude the last three digits of this postal code so as to only show the first 2,3,4 digits.

Example would be simple by having a query just showing the first few digits like this Left$([POSTAL_CODE],4) for example, however that will not show correctly for SK6 5LP and M2 4DJ and SK12 8LY.

I have either 2, 3, 4 digits I will need. All that is sure is - I do not want to see the last three digits. Identifying the last three is of course simple, but I cannot exclude them. Tried this

Right$([POSTAL_CODE],3) - and calling the field LAST_THREE
and then ([POSTAL_CODE]-[LAST_THREE])

However does not work because these are numbers and letters.

Probably a simple one, can someone please help - perhaps a query that sounds like this : show all but not Right$([POSTAL_CODE],3)

Ta

View Replies !   View Related
Show Everything BUT The Last 3 Digits
Hi,

I am writing a very very simple query to identify postal codes from a list of addresses. The table containing the data has a field called POSTAL_CODE.

I need to exclude the last three digits of this postal code so as to only show the first 2,3,4 digits.

Example would be simple by having a query just showing the first few digits like this Left$([POSTAL_CODE],4) for example, however that will not show correctly for SK6 5LP and M2 4DJ and SK12 8LY.

I have either 2, 3, 4 digits I will need. All that is sure is - I do not want to see the last three digits. Identifying the last three is of course simple, but I cannot exclude them. Tried this

Right$([POSTAL_CODE],3) - and calling the field LAST_THREE
and then ([POSTAL_CODE]-[LAST_THREE])

However does not work because these are numbers and letters.

Probably a simple one, can someone please help - perhaps a query that sounds like this : show all but not Right$([POSTAL_CODE],3)

Ta

View Replies !   View Related
Wildcard For One OR More Digits?
Hello, I'm trying to use wildcards to filter for records that contain a date somewhere within the string.

I'm using Like "*#.##.##*" which works for dates that have a day of the months >10, but what about those under?

Well, Like "*#.#.##*" only works for those with the day of month <10. Is there a wildcard character for "one or more digits"?

Also, the above example excludes Oct. - Dec. for the same reason.

help!

Thanks,
Gifford

View Replies !   View Related
First 12 Digits From One Field Into Another
I am having massive problems with data – I have imported data only to find out that Access has not imported all of it as there is a max of 255 fields, and I have loads more!!

I think I can get round this by importing without the delimited or fixed widths into a memo field but this gives me another problem, the the first 12 digits are the ‘Ref_No’

So I have a table called tblCustMemo that I have imported, and I have 3 fields, ID (Primary Key), Ref_No (new and totally empty) and Memo.

How can I put the first 12 characters from the memo field into the Ref_No field?
Then remove the first 13 characters from the memo field (there is a space after the Customers reference number)

I presume I would do this by update queries, but I am currently at a loss!!


I tried this, just to get the first 13 characters then was going to try update query, but this only returned 7 records out of 8687!!

SELECT Custmemo_TEST.ID, Custmemo_TEST.Ref_No, Custmemo_TEST.Memo
FROM Custmemo_TEST
WHERE (((Custmemo_TEST.Memo)=Left([Custmemo_TEST]![Memo],13)));

View Replies !   View Related
Help Me Block Out The First 5-digits Of The SSN
I hope someone can help me. I have a report that prints out with the customers social security number on it. I need to change it so that only the last four digits of the SSN show, so it would like something like this XXX-XX-1234. I still want it to keep the full SSN in my Table though so we can search for the customers info with the SSN.

Is there a way that I can change it on the report only and not mess up any other forms that I have it on? Any help would be awesome!

View Replies !   View Related
Totals But Only If 4 Digits
i need to total some data, but only if the code contains 4 digits.

by this i mean.

Code --> A101 ----> Occur 35
Code --> A101A ----> Occur 1
Code --> A101B ----> Occur 5
Code --> A101C ----> Occur 3
Code --> A101D ----> Occur 5
Code --> A101E ----> Occur 5
Code --> A101F ----> Occur 5

the total i need to be displayed is 24....

you will see that the first code only has 3 digits in the code...

Can this be done? if so how please

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved