By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,301 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,301 IT Pros & Developers. It's quick & easy.

different data type in same field

P: 6
hello professnols,

In my table I have, among other, two fileds "Activity" and "Accont ID". I
use form to fill the data in the table. If the field "activity " is either
"deposit" or withdraw" the field "Account ID" should read "NA" (data
type=text) but if the field "Activity" is "transfer" then the filed should
wait for the numeric data to be filled(data type=number). so my problem is
can i make a field to accept both type of data ( number and text) ?? please
help
Apr 20 '07 #1
Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
You simply cannot have a table field that that is sometimes text and sometimes numerical! Having said that, why do ever want the AccountId to ever be numerical.? Things like AccountIDs, while they can digits (0-9) are usually text, simply because it's not something you're going to do calculations with.
Apr 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.