Re: Reporting from Queries

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 02/19/04 

Date: Wed, 18 Feb 2004 19:53:25 -0600

It would really help if you typed or pasted some sample data with actual
field and table names into your message. I can only guess that you should
attempt to normalize the imported records with a union query:
SELECT Person, Mod1, "Mod1" as Question
FROM tblSurvey
WHERE Mod1 is not Null
UNION
SELECT Person, Mod2, "Mod2"
FROM tblSurvey
WHERE Mod2 is not Null
UNION
SELECT Person, Mod3, "Mod3"
FROM tblSurvey
WHERE Mod3 is not Null
UNION
...etc...
This union query should allow you to create your report. 

-- 
Duane Hookom
MS Access MVP
"Rachel" <scrmptus@aol.com> wrote in message
news:128b201c3f680$b3d0fad0$a001280a@phx.gbl...
> I imported data from an Excel file into Access.  This is a
> survey database where different people will receive
> different modules.  There are a total of 16 modules.
> Example
>
> Person 1: Modules 1, 2, 3, 5-7, 14
> Person 2: Moduless 2 and 3
> Person 3: Module 1 - 9
> Person 4: Modules 5
> etc...
>
> The data is compiled with all of the modules in one file.
> The column headers are the questions.  Because each person
> may not receive all modules there are balnk field where
> the person did not give a response.
>
> I would like to pull a report by person that contains each
> module the person received with their responses and leaves
> out any modules that did not have responses.
>
> I tried doing this through a query but when I tried to
> pull the report from the different queries Acess did not
> allow me to.  Any ideas?
> Thanks,
> Rachel

Relevant Pages

  • Re: Variables out the wazoo...
    ... > into his responses that advises folks that they have posted into an ... > Since you expressed that your issue was with a report you might try ... > HTH ... >>> believe you are using the Access Report Designer. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cycle helmets sheet
    ... Patrick Herring wrote: ... free look at the reference since the explicit reason for the ref isn't ... responses suggestive of RC than did nonusers. ... For example, in general, children using PE such as helmets report going faster and more often reported damage to their bike, perhaps because wearers took risks resulting in more severe ...
    (uk.rec.cycling)
  • Other gothic conceptual easters will spring far once again grocers.
    ... Every giant alternative responses ... Don't even try to report a resistance! ... Afif will bounce the mortgage, and if Georgina inside sucks it too, the ... Every peaceful reliefs control Rahavan, ...
    (comp.arch)
  • Re: online incident reporting
    ... Like his report to Council that _all_ responses to Row Safe had been favourable - which he had yesterday, & with utmost reluctance I gather, to accept was simply not true? ... It stinks to high heaven, after the last 8 years of deliberate lying & deceit by the organisation, that key ARA figures simply couldn't be bothered to stay to discuss water safety & hear more about the ARA's continuing attempts to ride roughshod over all the efforts of RoSPA, uncle Tom Cobley & all. ... nothing in the ARA's conduct of rowing safety has been remotely fair. ...
    (rec.sport.rowing)
  • Re: (switching between X11 and consoles (Re: switching games between fullscreen and window)
    ... add Mod1 = Alt_L ... add Mod2 = Num_Lock ... add Mod3 = Mode_switch ... add Mod5 = Scroll_Lock ...
    (Debian-User)