I hate Reports!

#1 (**permalink**) 28-Jul-2006, 08:36 AM

I have a data base that uses a formand subforms (One of which is continous)
to enter data into several related tables. This form is a questionairre.
I am trying to create a report to print out the data from each questionairre
seperatly.
Perhaps I am going about this the wrong way.
I have created a query to select which questionairre I wish to print.
Unfortunately if I include the continuos field in the query it only shows the
first instance.
If I use a query to populate a main report and then use a subreport to show
the other data I am unable to link the fields because the main forms field
name is different i.e its name is "table.fieldname" where as the subform
child field is "fieldname", I assume its this difference which prevents the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13351-i-hate-reports.html
sub report from displaying the relevant information.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
Any Help?

#2 (**permalink**) 28-Jul-2006, 08:36 AM

I Assume you have the same fieldname from 2 tables included in your query

ie
SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
-- or --
SELECT A.*, B.* FROM A INNER JOIN B....

2 solutions:
1) remove 1 of the ID fields from the select
2) Alias 1 of the ID fields
SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
-- or --
SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....

HTH

Pieter
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351

"Accessidiot" wrote in message
news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
>I have a data base that uses a formand subforms (One of which is continous)
> to enter data into several related tables. This form is a questionairre.
> I am trying to create a report to print out the data from each
> questionairre
> seperatly.
> Perhaps I am going about this the wrong way.
> I have created a query to select which questionairre I wish to print.
> Unfortunately if I include the continuos field in the query it only shows
> the
> first instance.
> If I use a query to populate a main report and then use a subreport to
> show
> the other data I am unable to link the fields because the main forms field
> name is different i.e its name is "table.fieldname" where as the subform
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
> child field is "fieldname", I assume its this difference which prevents
> the
> sub report from displaying the relevant information.
> Any Help?
>

#3 (**permalink**) 28-Jul-2006, 08:36 AM

I Assume you have the same fieldname from 2 tables included in your query

ie
SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
-- or --
SELECT A.*, B.* FROM A INNER JOIN B....

2 solutions:
1) remove 1 of the ID fields from the select
2) Alias 1 of the ID fields
SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
-- or --
SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....

HTH

Pieter

"Accessidiot" wrote in message
news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
>I have a data base that uses a formand subforms (One of which is continous)
> to enter data into several related tables. This form is a questionairre.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
> I am trying to create a report to print out the data from each
> questionairre
> seperatly.
> Perhaps I am going about this the wrong way.
> I have created a query to select which questionairre I wish to print.
> Unfortunately if I include the continuos field in the query it only shows
> the
> first instance.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
> If I use a query to populate a main report and then use a subreport to
> show
> the other data I am unable to link the fields because the main forms field
> name is different i.e its name is "table.fieldname" where as the subform
> child field is "fieldname", I assume its this difference which prevents
> the
> sub report from displaying the relevant information.
> Any Help?
>

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4231 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

#4 (**permalink**) 28-Jul-2006, 08:36 AM

I have used a query to populate the main report, then I am using the master
child to populate a sub report from a different table that has a foriegn key
which matches the primary key in the first table(That the query is based on)
But in the master child link box it shows the child field as "InspectionId"
and the Master as "Inspection.InspectionId" ("Inspection" being the name of
the table). The subreport does not get populated with any data and I assume
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
this is because the names are different?

Perhaps I am going about the whole thing wrong?
Ian

"Pieter Wijnen" wrote:

> I Assume you have the same fieldname from 2 tables included in your query
>
> ie
> SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
> -- or --
> SELECT A.*, B.* FROM A INNER JOIN B....
>
> 2 solutions:
> 1) remove 1 of the ID fields from the select
> 2) Alias 1 of the ID fields
> SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
> -- or --
> SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....
>
> HTH
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
>
> Pieter
>
>
>
> "Accessidiot" wrote in message
> news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
> >I have a data base that uses a formand subforms (One of which is continous)
> > to enter data into several related tables. This form is a questionairre.
> > I am trying to create a report to print out the data from each
> > questionairre
> > seperatly.
> > Perhaps I am going about this the wrong way.
> > I have created a query to select which questionairre I wish to print.
> > Unfortunately if I include the continuos field in the query it only shows
> > the
> > first instance.
> > If I use a query to populate a main report and then use a subreport to
> > show
> > the other data I am unable to link the fields because the main forms field
> > name is different i.e its name is "table.fieldname" where as the subform
> > child field is "fieldname", I assume its this difference which prevents
> > the
> > sub report from displaying the relevant information.
> > Any Help?
> >
>
>
>
> --
> ----------------------------------------
> I am using the free version of SPAMfighter for private users.
> It has removed 4231 spam emails to date.
> Paying users do not have this message in their emails.
> Get the free SPAMfighter here: http://www.spamfighter.com/len
>
>
>

#5 (**permalink**) 28-Jul-2006, 08:37 AM

trust me,
this will only happen if the aforementioned conditions apply
get rid of the duplicate field names from the query & you're ok

Pieter

"Accessidiot" wrote in message
news:00D1187E-679A-43AA-B7E0-7BE9FE923B48@microsoft.com...
>I have used a query to populate the main report, then I am using the master
> child to populate a sub report from a different table that has a foriegn
> key
> which matches the primary key in the first table(That the query is based
> on)
> But in the master child link box it shows the child field as
> "InspectionId"
> and the Master as "Inspection.InspectionId" ("Inspection" being the name
> of
> the table). The subreport does not get populated with any data and I
> assume
> this is because the names are different?
>
> Perhaps I am going about the whole thing wrong?
> Ian
>
> "Pieter Wijnen" wrote:
>
>> I Assume you have the same fieldname from 2 tables included in your query
>>
>> ie
>> SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
>> -- or --
>> SELECT A.*, B.* FROM A INNER JOIN B....
>>
>> 2 solutions:
>> 1) remove 1 of the ID fields from the select
>> 2) Alias 1 of the ID fields
>> SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
>> -- or --
>> SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....
>>
>> HTH
>>
>> Pieter
>>
>>
>>
>> "Accessidiot" wrote in message
>> news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
>> >I have a data base that uses a formand subforms (One of which is
>> >continous)
>> > to enter data into several related tables. This form is a
>> > questionairre.
>> > I am trying to create a report to print out the data from each
>> > questionairre
>> > seperatly.
>> > Perhaps I am going about this the wrong way.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
>> > I have created a query to select which questionairre I wish to print.
>> > Unfortunately if I include the continuos field in the query it only
>> > shows
>> > the
>> > first instance.
>> > If I use a query to populate a main report and then use a subreport to
>> > show
>> > the other data I am unable to link the fields because the main forms
>> > field
>> > name is different i.e its name is "table.fieldname" where as the
>> > subform
>> > child field is "fieldname", I assume its this difference which prevents
>> > the
>> > sub report from displaying the relevant information.
>> > Any Help?
>> >
>>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
>>
>>
>> --
>> ----------------------------------------
>> I am using the free version of SPAMfighter for private users.
>> It has removed 4231 spam emails to date.
>> Paying users do not have this message in their emails.
>> Get the free SPAMfighter here: http://www.spamfighter.com/len
>>
>>
>>

#6 (**permalink**) 28-Jul-2006, 08:37 AM

trust me,
this will only happen if the aforementioned conditions apply
get rid of the duplicate field names from the query & you're ok
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351

Pieter

"Accessidiot" wrote in message
news:00D1187E-679A-43AA-B7E0-7BE9FE923B48@microsoft.com...
>I have used a query to populate the main report, then I am using the master
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
> child to populate a sub report from a different table that has a foriegn
> key
> which matches the primary key in the first table(That the query is based
> on)
> But in the master child link box it shows the child field as
> "InspectionId"
> and the Master as "Inspection.InspectionId" ("Inspection" being the name
> of
> the table). The subreport does not get populated with any data and I
> assume
> this is because the names are different?
>
> Perhaps I am going about the whole thing wrong?
> Ian
>
> "Pieter Wijnen" wrote:
>
>> I Assume you have the same fieldname from 2 tables included in your query
>>
>> ie
>> SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
>> -- or --
>> SELECT A.*, B.* FROM A INNER JOIN B....
>>
>> 2 solutions:
>> 1) remove 1 of the ID fields from the select
>> 2) Alias 1 of the ID fields
>> SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
>> -- or --
>> SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....
>>
>> HTH
>>
>> Pieter
>>
>>
>>
>> "Accessidiot" wrote in message
>> news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
>> >I have a data base that uses a formand subforms (One of which is
>> >continous)
>> > to enter data into several related tables. This form is a
>> > questionairre.
>> > I am trying to create a report to print out the data from each
>> > questionairre
>> > seperatly.
>> > Perhaps I am going about this the wrong way.
>> > I have created a query to select which questionairre I wish to print.
>> > Unfortunately if I include the continuos field in the query it only
>> > shows
>> > the
>> > first instance.
>> > If I use a query to populate a main report and then use a subreport to
>> > show
>> > the other data I am unable to link the fields because the main forms
>> > field
>> > name is different i.e its name is "table.fieldname" where as the
>> > subform
>> > child field is "fieldname", I assume its this difference which prevents
>> > the
>> > sub report from displaying the relevant information.
>> > Any Help?
>> >
>>
>>
>>
>> --
>> ----------------------------------------
>> I am using the free version of SPAMfighter for private users.
>> It has removed 4231 spam emails to date.
>> Paying users do not have this message in their emails.
>> Get the free SPAMfighter here: http://www.spamfighter.com/len
>>
>>
>>

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4231 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

#7 (**permalink**) 28-Jul-2006, 08:37 AM

How foolish of me! I see what you mean, I was using the * field to enter
fields and also a duplicate for the parameter.
Thank you

"Pieter Wijnen" wrote:

> trust me,
> this will only happen if the aforementioned conditions apply
> get rid of the duplicate field names from the query & you're ok
>
> Pieter
>
> "Accessidiot" wrote in message
> news:00D1187E-679A-43AA-B7E0-7BE9FE923B48@microsoft.com...
> >I have used a query to populate the main report, then I am using the master
> > child to populate a sub report from a different table that has a foriegn
> > key
> > which matches the primary key in the first table(That the query is based
> > on)
> > But in the master child link box it shows the child field as
> > "InspectionId"
> > and the Master as "Inspection.InspectionId" ("Inspection" being the name
> > of
> > the table). The subreport does not get populated with any data and I
> > assume
> > this is because the names are different?
> >
> > Perhaps I am going about the whole thing wrong?
> > Ian
> >
> > "Pieter Wijnen" wrote:
> >
> >> I Assume you have the same fieldname from 2 tables included in your query
> >>
> >> ie
> >> SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
> >> -- or --
> >> SELECT A.*, B.* FROM A INNER JOIN B....
> >>
> >> 2 solutions:
> >> 1) remove 1 of the ID fields from the select
> >> 2) Alias 1 of the ID fields
> >> SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
> >> -- or --
> >> SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....
> >>
> >> HTH
> >>
> >> Pieter
> >>
> >>
> >>
> >> "Accessidiot" wrote in message
> >> news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
> >> >I have a data base that uses a formand subforms (One of which is
> >> >continous)
> >> > to enter data into several related tables. This form is a
> >> > questionairre.
> >> > I am trying to create a report to print out the data from each
> >> > questionairre
> >> > seperatly.
> >> > Perhaps I am going about this the wrong way.
> >> > I have created a query to select which questionairre I wish to print.
> >> > Unfortunately if I include the continuos field in the query it only
> >> > shows
> >> > the
> >> > first instance.
> >> > If I use a query to populate a main report and then use a subreport to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
> >> > show
> >> > the other data I am unable to link the fields because the main forms
> >> > field
> >> > name is different i.e its name is "table.fieldname" where as the
> >> > subform
> >> > child field is "fieldname", I assume its this difference which prevents
> >> > the
> >> > sub report from displaying the relevant information.
> >> > Any Help?
> >> >
> >>
> >>
> >>
> >> --
> >> ----------------------------------------
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
> >> I am using the free version of SPAMfighter for private users.
> >> It has removed 4231 spam emails to date.
> >> Paying users do not have this message in their emails.
> >> Get the free SPAMfighter here: http://www.spamfighter.com/len
> >>
> >>
> >>
>
>
>
> --
> ----------------------------------------
> I am using the free version of SPAMfighter for private users.
> It has removed 4231 spam emails to date.
> Paying users do not have this message in their emails.
> Get the free SPAMfighter here: http://www.spamfighter.com/len
>
>
>

#8 (**permalink**) 28-Jul-2006, 08:37 AM

been there, done that

Pieter

"Accessidiot" wrote in message
news:90293A96-7C5E-4913-AEF5-F92A44319203@microsoft.com...
> How foolish of me! I see what you mean, I was using the * field to enter
> fields and also a duplicate for the parameter.
> Thank you
>
> "Pieter Wijnen" wrote:
>
>> trust me,
>> this will only happen if the aforementioned conditions apply
>> get rid of the duplicate field names from the query & you're ok
>>
>> Pieter
>>
>> "Accessidiot" wrote in message
>> news:00D1187E-679A-43AA-B7E0-7BE9FE923B48@microsoft.com...
>> >I have used a query to populate the main report, then I am using the
>> >master
>> > child to populate a sub report from a different table that has a
>> > foriegn
>> > key
>> > which matches the primary key in the first table(That the query is
>> > based
>> > on)
>> > But in the master child link box it shows the child field as
>> > "InspectionId"
>> > and the Master as "Inspection.InspectionId" ("Inspection" being the
>> > name
>> > of
>> > the table). The subreport does not get populated with any data and I
>> > assume
>> > this is because the names are different?
>> >
>> > Perhaps I am going about the whole thing wrong?
>> > Ian
>> >
>> > "Pieter Wijnen" wrote:
>> >
>> >> I Assume you have the same fieldname from 2 tables included in your
>> >> query
>> >>
>> >> ie
>> >> SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
>> >> -- or --
>> >> SELECT A.*, B.* FROM A INNER JOIN B....
>> >>
>> >> 2 solutions:
>> >> 1) remove 1 of the ID fields from the select
>> >> 2) Alias 1 of the ID fields
>> >> SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
>> >> -- or --
>> >> SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....
>> >>
>> >> HTH
>> >>
>> >> Pieter
>> >>
>> >>
>> >>
>> >> "Accessidiot" wrote in message
>> >> news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
>> >> >I have a data base that uses a formand subforms (One of which is
>> >> >continous)
>> >> > to enter data into several related tables. This form is a
>> >> > questionairre.
>> >> > I am trying to create a report to print out the data from each
>> >> > questionairre
>> >> > seperatly.
>> >> > Perhaps I am going about this the wrong way.
>> >> > I have created a query to select which questionairre I wish to
>> >> > print.
>> >> > Unfortunately if I include the continuos field in the query it only
>> >> > shows
>> >> > the
>> >> > first instance.
>> >> > If I use a query to populate a main report and then use a subreport
>> >> > to
>> >> > show
>> >> > the other data I am unable to link the fields because the main forms
>> >> > field
>> >> > name is different i.e its name is "table.fieldname" where as the
>> >> > subform
>> >> > child field is "fieldname", I assume its this difference which
>> >> > prevents
>> >> > the
>> >> > sub report from displaying the relevant information.
>> >> > Any Help?
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> ----------------------------------------
>> >> I am using the free version of SPAMfighter for private users.
>> >> It has removed 4231 spam emails to date.
>> >> Paying users do not have this message in their emails.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
>> >> Get the free SPAMfighter here: http://www.spamfighter.com/len
>> >>
>> >>
>> >>
>>
>>
>>
>> --
>> ----------------------------------------
>> I am using the free version of SPAMfighter for private users.
>> It has removed 4231 spam emails to date.
>> Paying users do not have this message in their emails.
>> Get the free SPAMfighter here: http://www.spamfighter.com/len
>>
>>
>>

#9 (**permalink**) 28-Jul-2006, 08:37 AM

been there, done that

Pieter

"Accessidiot" wrote in message
news:90293A96-7C5E-4913-AEF5-F92A44319203@microsoft.com...
> How foolish of me! I see what you mean, I was using the * field to enter
> fields and also a duplicate for the parameter.
> Thank you
>
> "Pieter Wijnen" wrote:
>
>> trust me,
>> this will only happen if the aforementioned conditions apply
>> get rid of the duplicate field names from the query & you're ok
>>
>> Pieter
>>
>> "Accessidiot" wrote in message
>> news:00D1187E-679A-43AA-B7E0-7BE9FE923B48@microsoft.com...
>> >I have used a query to populate the main report, then I am using the
>> >master
>> > child to populate a sub report from a different table that has a
>> > foriegn
>> > key
>> > which matches the primary key in the first table(That the query is
>> > based
>> > on)
>> > But in the master child link box it shows the child field as
>> > "InspectionId"
>> > and the Master as "Inspection.InspectionId" ("Inspection" being the
>> > name
>> > of
>> > the table). The subreport does not get populated with any data and I
>> > assume
>> > this is because the names are different?
>> >
>> > Perhaps I am going about the whole thing wrong?
>> > Ian
>> >
>> > "Pieter Wijnen" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
>> >
>> >> I Assume you have the same fieldname from 2 tables included in your
>> >> query
>> >>
>> >> ie
>> >> SELECT A.ID, A....., B.ID, B..... FROM A INNER JOIN B ...
>> >> -- or --
>> >> SELECT A.*, B.* FROM A INNER JOIN B....
>> >>
>> >> 2 solutions:
>> >> 1) remove 1 of the ID fields from the select
>> >> 2) Alias 1 of the ID fields
>> >> SELECT A.ID AS LinkField, A....., B.ID, B..... FROM A INNER JOIN B ...
>> >> -- or --
>> >> SELECT A.*, B.*, A.ID AS LinkField FROM A INNER JOIN B....
>> >>
>> >> HTH
>> >>
>> >> Pieter
>> >>
>> >>
>> >>
>> >> "Accessidiot" wrote in message
>> >> news:3CE1F52D-2321-479E-9C6E-F11A1DD8DACB@microsoft.com...
>> >> >I have a data base that uses a formand subforms (One of which is
>> >> >continous)
>> >> > to enter data into several related tables. This form is a
>> >> > questionairre.
>> >> > I am trying to create a report to print out the data from each
>> >> > questionairre
>> >> > seperatly.
>> >> > Perhaps I am going about this the wrong way.
>> >> > I have created a query to select which questionairre I wish to
>> >> > print.
>> >> > Unfortunately if I include the continuos field in the query it only
>> >> > shows
>> >> > the
>> >> > first instance.
>> >> > If I use a query to populate a main report and then use a subreport
>> >> > to
>> >> > show
>> >> > the other data I am unable to link the fields because the main forms
>> >> > field
>> >> > name is different i.e its name is "table.fieldname" where as the
>> >> > subform
>> >> > child field is "fieldname", I assume its this difference which
>> >> > prevents
>> >> > the
>> >> > sub report from displaying the relevant information.
>> >> > Any Help?
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> ----------------------------------------
>> >> I am using the free version of SPAMfighter for private users.
>> >> It has removed 4231 spam emails to date.
>> >> Paying users do not have this message in their emails.
>> >> Get the free SPAMfighter here: http://www.spamfighter.com/len
>> >>
>> >>
>> >>
>>
>>
>>
>> --
>> ----------------------------------------
>> I am using the free version of SPAMfighter for private users.
>> It has removed 4231 spam emails to date.
>> Paying users do not have this message in their emails.
>> Get the free SPAMfighter here: http://www.spamfighter.com/len
>>
>>
>>

--
----------------------------------------
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13351
I am using the free version of SPAMfighter for private users.
It has removed 4282 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len