First case:
Left field is autonumber (a number type), Right field is text type - must be a number type.
Second case:
Left field is number type, Right field is autonumber (a number type).
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I hope the right picture was clear enough, but on the second case, I was connecting "nottheid" field and "ID" field. I just inserted the numbers on the left field (and now it's a number type field), but I also did that on my first case with the right field.
To make a long answer short, how do I make my text type to a number type? My boxes contain all numeric characters and no alphabetic.
Looks like I'm late to the party again......
Open table in design view and change field type to Number Long Integer.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Phew, well therer we go. Completely crazy, I was tearing hair off my head over it, calculating and comparing to others why it didn't work. And I knew somethign was off when I wrote the line that it was indented to the left, but then I completely forgot about it. Dammit.
Anyway, hats off for getting so into it as to actually editing and fixing my picture!
You sir are a certified MVP, let me say.
THANK YOU to all! This was really infuriating haha
From both of us, you're welcome.
Yes, it took a little the time to edit the image, but I'd bet you understand RI a lot more now...
Good luck with your project.........
Thank you very much.