Shared Data Types
in [Tables]
|
Prev: Email Validation
Next: tracking from a query to a table
From: Duane Hookom on 28 Jan 2010 23:18 If you only intend to store numeric values then you might want to use a numeric field. If you choose to use a text field, you can convert it to numeric using Val(). Duane Hookom MS Access MVP "oldblindpew" <oldblindpew(a)discussions.microsoft.com> wrote in message news:3A6D2B21-45C5-4E68-9F8E-DD30EAC0955A(a)microsoft.com... > Yes, that's the example I've been studying. He uses Text for his response > field data type, and I was hoping to flush out a reply on why one might > prefer Text over Number, even if Number seems a more likely candidate. > Also, > he does have a field for QuestionType, but so far I have not found any way > for the user to access that field when creating a survey question! > > Thanks, > OBP > > "Jeff Boyce" wrote: > >> If I recall correctly, Duane H. did something like this in his At Your >> Survey database/application: >> >> http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3 >> >> Regards >> >> Jeff Boyce >> Microsoft Access MVP >> >> -- >> Disclaimer: This author may have received products and services mentioned >> in this post. Mention and/or description of a product or service herein >> does not constitute endorsement thereof. >> >> Any code or pseudocode included in this post is offered "as is", with no >> guarantee as to suitability. >> >> You can thank the FTC of the USA for making this disclaimer >> possible/necessary. >> >> "oldblindpew" <oldblindpew(a)discussions.microsoft.com> wrote in message >> news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD(a)microsoft.com... >> > I'm anticipating something like this: >> > >> > PERSONS >> > PersonID >> > Person fields... >> > >> > REQUESTS >> > RequestID >> > RequestDescription >> > RequestType >> > >> > RESPONSES >> > ResponseID >> > RequestID >> > PersonID >> > Response >> > >> > I expect the Responses to be Numbers, Currency, or Yes/No, however, all >> > responses go in the same field, which can have only one data type. I >> > have >> > set aside the RequestType field as some sort of flag to indicate the >> > kind >> > of >> > response expected for each request. >> > >> > Question: Which data type should I use for the Response field? It >> > seems >> > like Number would work, but an example I've seen used Text. >> > >> > Bonus Question: Is there a preferred way (sample code?) to make use of >> > the >> > RequestType to convert the Response into the correct value of the >> > correct >> > type? >> > >> > Thanks, >> > OldBlindPew >> >> >> . >>
From: Piet Linden on 29 Jan 2010 00:38
On Jan 27, 5:35 pm, oldblindpew <oldblind...(a)discussions.microsoft.com> wrote: > Yes, that's the example I've been studying. He uses Text for his response > field data type, and I was hoping to flush out a reply on why one might > prefer Text over Number, even if Number seems a more likely candidate. Also, > he does have a field for QuestionType, but so far I have not found any way > for the user to access that field when creating a survey question! > > Thanks, > OBP > > "Jeff Boyce" wrote: > > If I recall correctly, Duane H. did something like this in his At Your > > Survey database/application: > > > http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3 > > > Regards > > > Jeff Boyce > > Microsoft Access MVP > > > -- > > Disclaimer: This author may have received products and services mentioned > > in this post. Mention and/or description of a product or service herein > > does not constitute endorsement thereof. > > > Any code or pseudocode included in this post is offered "as is", with no > > guarantee as to suitability. > > > You can thank the FTC of the USA for making this disclaimer > > possible/necessary. > > > "oldblindpew" <oldblind...(a)discussions.microsoft.com> wrote in message > >news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD(a)microsoft.com... > > > I'm anticipating something like this: > > > > PERSONS > > > PersonID > > > Person fields... > > > > REQUESTS > > > RequestID > > > RequestDescription > > > RequestType > > > > RESPONSES > > > ResponseID > > > RequestID > > > PersonID > > > Response > > > > I expect the Responses to be Numbers, Currency, or Yes/No, however, all > > > responses go in the same field, which can have only one data type. I have > > > set aside the RequestType field as some sort of flag to indicate the kind > > > of > > > response expected for each request. > > > > Question: Which data type should I use for the Response field? It seems > > > like Number would work, but an example I've seen used Text. > > > > Bonus Question: Is there a preferred way (sample code?) to make use of the > > > RequestType to convert the Response into the correct value of the correct > > > type? > > > > Thanks, > > > OldBlindPew > > > . Really simple. You can store almost anything in a text field and then use conversion functions to convert to another datatype. e.g. CInt ([MyTextField]) If you wanted it to be relatively painless, you could store the intended type in a table somewhere, or in the Question table... |