Re: MODELING ADVISE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 02/21/05


Date: Mon, 21 Feb 2005 15:54:01 -0600

The link suggested by Jeff can be "re-purposed" for modeling more than just
a survey. You could possibly add a table to At Your Survey that identifies
which series of information needs to be applied.

Did you review the demo?

-- 
Duane Hookom
MS Access MVP
--
"Carlee" <Carlee@discussions.microsoft.com> wrote in message 
news:8031CC7D-6CE2-4B6E-A8CF-857A44914698@microsoft.com...
> Jeff,
> thanks for the reply.  My database isn't a "survey" in the typical sense, 
> it
> is a method of collecting data for laboratory testing.  The use of the 
> term
> 'survey' is symatical in this situation.
>
> Having said that, can you advise at all on my initial question?
>
> Many thanks in advance
>
>
>
> "Jeff Boyce" wrote:
>
>> Carlee
>>
>> I may be fixating on, and over-reacting to, your use of the word 
>> "survey",
>> so take this with a grain of salt...
>>
>> A fellow MVP has created a very useful application/model of surveys -- 
>> please see:
>>
>> Duane Hookom has a sample survey database at
>>   http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
>>
>> -- 
>> Good luck
>>
>> Jeff Boyce
>> <Access MVP>
>>
>> "Carlee" <Carlee@discussions.microsoft.com> wrote in message
>> news:6A020D6B-455C-49E6-B027-B8BC2947AAA9@microsoft.com...
>> > Hello all,
>> >
>> > I have a fairly complex model I am trying to figure out.  This is just 
>> > one
>> > part of it.  I have a survey being conducted at a site.  Depending on 
>> > the
>> > site type, a series of information needs to be collected.  For example, 
>> > if
>> > the site is residential, then fields A,B, AND C need to be collected. 
>> > If
>> > however, the site is a commercial location, then fields A,D,E,F,G etc.
>> need
>> > to be collected.
>> >
>> > Question:
>> > should I be putting all the fields, regardless of their type in one 
>> > table?
>> > -- 
>> > Carlee
>>
>> 


Relevant Pages

  • Re: table design
    ... The link supplied by Jeff has similar ... MS Access MVP ... > tables and columns...im at work now...do u have an opinion about my survey ... >>> INVENTORY ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Survey Scout
    ... Jeff T. wrote: ... > I wasn't getting a whole lot of spam and then I installed Survey ... > Scout, they are supposed to find surveys that pay money and won't ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: table design
    ... Thank you so much Jeff, but i havent got Access in my pc...so i cant see the ... tables and columns...im at work now...do u have an opinion about my survey ... "Jeff Boyce" wrote: ... >> INVENTORY ...
    (microsoft.public.access.tablesdbdesign)
  • Re: OT: Political flame bait
    ... > the survey estimates of the size of the workforce. ... No one does *not* have to be collecting UI each week to be considered ... The states don't report the unemployment rate. ...
    (sci.electronics.design)
  • Re: MODELING ADVISE
    ... My database isn't a "survey" in the typical sense, ... is a method of collecting data for laboratory testing. ... >> site type, a series of information needs to be collected. ...
    (microsoft.public.access.tablesdbdesign)