Shared Data Types
in [Tables]
|
Prev: Email Validation
Next: tracking from a query to a table
From: oldblindpew on 27 Jan 2010 11:53 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: Jeff Boyce on 27 Jan 2010 12:54 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: Steve on 27 Jan 2010 15:06 Numbers, Currency, and Yes/No can all be numbers. Obviously currency is a number with a leading dollar sign. If you look at what is stored in a Yes/No field, you will see -1 for Yes and 0 for No. So when you display Response in a form or report, all you need do is format the response value appropriately. Steve santus(a)penn.com "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: oldblindpew on 27 Jan 2010 18:35 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: Steve on 27 Jan 2010 18:57
Did you look at my response? Steve "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 >> >> >> . >> |