467,099 Members | 1,103 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,099 developers. It's quick & easy.

Query using joined tables

Help please!!! I am an intermediate access user that is getting my
bottom kicked by what seems an easy problem to fix. I maintain an
employee database at work. I have set up a query from two tables to
generate a query displaying useful fields, but only for those whom
appear on both tables. The names are formatted different so I chose to
join them using the SSN. I set up the query and joined the SSN
property but when I run the query, it comes up blank (despite there
being several matches).
Here is some additional info if it helps. The two tables I am
using are exported from other programs that are used at work. One
exports the SSN with hyphens as placeholders, the other just exports
the number itself. I thought that was the problem so I set up both
tables with an identical input mask and ensured that the field
properties are also identical. Troubleshooting I found that if I go
back and manually reenter the SSN in one of the tables, it will work
exactly as it should.

Any suggestions would be greatly appreciated!
Nov 13 '05 #1
  • viewed: 1381
Share:
1 Reply
Input masks change the way the data is viewed. It does not necessarily
store the value that way unless you use ;0;_ at the end of the mask...Its
the 0 that forces access to save the value in the same way as it appears on
your screen. Another option is to strip out the hyphens from the one SSN or
add in hyphens into the one thats missing them.

HTH
Paul

"Carl B Davis" <cb***********@yahoo.com> wrote in message
news:f5**************************@posting.google.c om...
Help please!!! I am an intermediate access user that is getting my
bottom kicked by what seems an easy problem to fix. I maintain an
employee database at work. I have set up a query from two tables to
generate a query displaying useful fields, but only for those whom
appear on both tables. The names are formatted different so I chose to
join them using the SSN. I set up the query and joined the SSN
property but when I run the query, it comes up blank (despite there
being several matches).
Here is some additional info if it helps. The two tables I am
using are exported from other programs that are used at work. One
exports the SSN with hyphens as placeholders, the other just exports
the number itself. I thought that was the problem so I set up both
tables with an identical input mask and ensured that the field
properties are also identical. Troubleshooting I found that if I go
back and manually reenter the SSN in one of the tables, it will work
exactly as it should.

Any suggestions would be greatly appreciated!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by sqlgoogle | last post: by
2 posts views Thread by allyn44@cox.net | last post: by
1 post views Thread by Michael | last post: by
14 posts views Thread by Tom | last post: by
1 post views Thread by Ike | last post: by
2 posts views Thread by Fendi Baba | last post: by
1 post views Thread by racquetballer@hotmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.