Shared Data Types - microsoft.public.access.tablesdbdesign

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

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@discussions.microsoft.com> wrote in message news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD@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

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@penn.com "oldblindpew" <oldblindpew@discussions.microsoft.com> wrote in message news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD@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

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@discussions.microsoft.com> wrote in message > news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD@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 > > > . >

Did you look at my response? Steve "oldblindpew" <oldblindpew@discussions.microsoft.com> wrote in message news:3A6D2B21-45C5-4E68-9F8E-DD30EAC0955A@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@discussions.microsoft.com> wrote in message >> news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD@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 >> >> >> . >>

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@discussions.microsoft.com> wrote in message news:3A6D2B21-45C5-4E68-9F8E-DD30EAC0955A@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@discussions.microsoft.com> wrote in message >> news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD@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 >> >> >> . >>

On Jan 27, 5:35=A0pm, oldblindpew <oldblind...@discussions.microsoft.com> wrote: > Yes, that's the example I've been studying. =A0He uses Text for his respo= nse > 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. = =A0Also, > he does have a field for QuestionType, but so far I have not found any wa= y > for the user to access that field when creating a survey question! > > Thanks, > OBP =A0 > > "Jeff Boyce" wrote: > > If I recall correctly, Duane H. did something like this in his At Your > > Survey database/application: > > > =A0http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3D3 > > > Regards > > > Jeff Boyce > > Microsoft Access MVP > > > -- > > Disclaimer: This author may have received products and services mention= ed > > 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 n= o > > guarantee as to suitability. > > > You can thank the FTC of the USA for making this disclaimer > > possible/necessary. > > > "oldblindpew" <oldblind...@discussions.microsoft.com> wrote in message > >news:A0A492C1-3034-4F6F-B04C-FD63AAD5ECCD@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, a= ll > > > responses go in the same field, which can have only one data type. = =A0I 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? =A0It = 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 o= f the > > > RequestType to convert the Response into the correct value of the cor= rect > > > 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...

Similiar Articles:

Convert data to UK date type - microsoft.public.windows.powershell ...
I have a small script for reading the AV def dates from a file. $def = (gc "C:\Program Files\Common Files\Symantec Shared\VirusDefs\usage.dat")[0...

WCF Exception: Type 'MyType' with Data Contract Name ' ...
WCF Exception: Type 'MyType' with Data Contract Name 'Some Name' is not Expected Follow ... Read this: Shared Types vs Shared Contracts http://blogs.msdn.com/sowmy ...

Shared Workbook is "in use by another user" - microsoft ...
The workbook is saved to a Shared Data folder on our server that > everyone has access ... > > > > (The workbook is a basic scheduling tool for staff to type when they leave ...

Custom field type and external data source - microsoft.public ...
Hi I would like to ask you for advice. In our enviroment we have one web application hosting 3 site collection. Those site collection need to share few (3-4 ...

Problem scheduling SQL Reports - microsoft.public.greatplains ...
Went to a report Properties > Data Sources > change from Shared to a Custom Data source but now I am having trouble with what to enter for Connection Type and ...

Lists - change column type after import - microsoft.public ...
The very first section of the column settings page will be for the data type of the ... Updating Share Point list from within Excel - microsoft.public ... Lists - change ...

How to get all the texts on all type controls in form? - microsoft ...
///// Public Shared Sub AllControlOnForm(ByVal FormName As Form, ByVal xPath As String ... Access automatically creates a text box for fields of the following data types:

column widths keep changing in shared file - microsoft.public ...
I then shared the file so that my co-workers and boss ... It causes the data to show up as just ### because the ... File>Save As Type: scroll down to Excel Template(*.XLT ...

Export SharePoint List data into an excel as metatdata - microsoft ...
I'm looking to export data collected in a SharePoint 2007 list into a ... to a list on a SharePoint site ... cells in Excel can be converted into a data type ...

Lock cells in a shared workbook - microsoft.public.excel.misc ...
Nope... You can not change the protection on a shared workbook without first unsharing it. In Help type in Shared workbook restrictions to find a complete list of the ...

Sharing Types - Microsoft Corporation: Software, Smartphones ...
As a result, Service1 and Service2 do not share the same Name data type—despite the fact that they use the same CLR type, it's the XSD type that really matters.

Ben's blog: Pre-build events, shared data types, and WCF
Generating WCF proxies has always been a bit of pain, especially when one has services that share data types. The Service Reference wizard in Visual Studio ...

c# - Sharing data types from multiple Web References - Stack Overflow
Say a vendor has provided two separate webservices, which both share the same data types and same namespace. e.g. The following webservices both contain similar ...

Variable Declaration - Microsoft Corporation: Software ...
If it is declared with the Shared keyword, it is a shared variable, and it exists in ... Declaring Data Type. The As clause in the declaration statement allows you to define the ...

Windows 8 : the sharing contract in Metro / WinRT applications ...
What can we share ? At the time of the post, you can share – only – 6 different types of data. These types are represented in the StandardDataFormats class as static ...

7/25/2012 8:02:02 AM