Judy said:The text boxes are in the detail section. The report lists coaches and
their
impact certification and background screening dates. The first two people
both things show up and the third person nothing shows. The fourth and
fifth
person only the background screening date shows up.
the text box for impact dates =([impact date]) and =([background screening
date])
I only want the information to show up for adults and if it is null to be
left blank.
Thanks!
Judy said:When I run a query all of the information shows up and when I run the
report
with using the query it is missing some information. Usually the third
person's information and the first part of the 4th and 5th person.
What is going on?
Duane Hookom said:Did you re-check your report's record source datasheet view?
Is there a reason why you set control sources to:
Control Source: =([impact date])
rather than just
Control Source: [impact date]
Where did the "..show up for adults..." come in to this issue? Do you have a
SQL view of the record source you would like to share?
--
Duane Hookom
MS Access MVP
--
Judy said:The text boxes are in the detail section. The report lists coaches and
their
impact certification and background screening dates. The first two people
both things show up and the third person nothing shows. The fourth and
fifth
person only the background screening date shows up.
the text box for impact dates =([impact date]) and =([background screening
date])
I only want the information to show up for adults and if it is null to be
left blank.
Thanks!
Judy said:When I run a query all of the information shows up and when I run the
report
with using the query it is missing some information. Usually the third
person's information and the first part of the 4th and 5th person.
What is going on?
Judy said:Yes-I rechecked the datasheet view. I changed the control source and
nothing
changed.
Here is the SQL
SELECT DISTINCTROW [2006 Teams].Division, [2006 Teams].[Team Gender],
[Individual Join].Coach, [Individual Join].[Member #], INDIVIDUALS.[First
Name], INDIVIDUALS.[Last Name], INDIVIDUALS.Address1,
INDIVIDUALS.Address2,
INDIVIDUALS.City, INDIVIDUALS.St, INDIVIDUALS.ZIP, INDIVIDUALS.Impact,
INDIVIDUALS.[Impact Date], INDIVIDUALS.HPhone, INDIVIDUALS.WPhone,
INDIVIDUALS.Birthday, [Individual Join].[Team Rep], [2006 Teams].[Team
ID],
INDIVIDUALS.[Member Type], INDIVIDUALS.Gender, INDIVIDUALS.[Soc Sec No],
INDIVIDUALS.[2006], [2006 Teams].[CT Code], [2006 Clubs].[Team Code],
[2006
Teams].[Club ID], INDIVIDUALS.Email, [2006 Clubs].[Club Name], [2006
Teams].[Team Name], INDIVIDUALS.[Background Screen],
INDIVIDUALS.[Background
Expires], INDIVIDUALS.[Background Date]
FROM [2006 Clubs] INNER JOIN ((INDIVIDUALS INNER JOIN [Individual Join] ON
INDIVIDUALS.[Member #] = [Individual Join].[Member #]) INNER JOIN [2006
Teams] ON [Individual Join].[Team ID] = [2006 Teams].[Team ID]) ON [2006
Clubs].[Club ID] = [2006 Teams].[Club ID]
WHERE ((([2006 Teams].[Team ID]) Between [First Team ID] And [Second Team
ID]) AND ((INDIVIDUALS.[2006])="Y"))
ORDER BY [2006 Teams].Division, [2006 Teams].[Team ID];
Thanks!
Duane Hookom said:Did you re-check your report's record source datasheet view?
Is there a reason why you set control sources to:
Control Source: =([impact date])
rather than just
Control Source: [impact date]
Where did the "..show up for adults..." come in to this issue? Do you
have a
SQL view of the record source you would like to share?
--
Duane Hookom
MS Access MVP
--
Judy said:The text boxes are in the detail section. The report lists coaches and
their
impact certification and background screening dates. The first two
people
both things show up and the third person nothing shows. The fourth and
fifth
person only the background screening date shows up.
the text box for impact dates =([impact date]) and =([background
screening
date])
I only want the information to show up for adults and if it is null to
be
left blank.
Thanks!
:
When I run a query all of the information shows up and when I run the
report
with using the query it is missing some information. Usually the third
person's information and the first part of the 4th and 5th person.
What is going on?
Duane Hookom said:If some values display for some records and not others than there is either
no data to display or code or conditional formatting is hiding the data. Are
entire teams not showing or just individuals?
I don't care much for your table structure but I assume it is working for
you. 2006 should really be a data value in a field in a table and not part
of a table or field name.
--
Duane Hookom
MS Access MVP
Judy said:Yes-I rechecked the datasheet view. I changed the control source and
nothing
changed.
Here is the SQL
SELECT DISTINCTROW [2006 Teams].Division, [2006 Teams].[Team Gender],
[Individual Join].Coach, [Individual Join].[Member #], INDIVIDUALS.[First
Name], INDIVIDUALS.[Last Name], INDIVIDUALS.Address1,
INDIVIDUALS.Address2,
INDIVIDUALS.City, INDIVIDUALS.St, INDIVIDUALS.ZIP, INDIVIDUALS.Impact,
INDIVIDUALS.[Impact Date], INDIVIDUALS.HPhone, INDIVIDUALS.WPhone,
INDIVIDUALS.Birthday, [Individual Join].[Team Rep], [2006 Teams].[Team
ID],
INDIVIDUALS.[Member Type], INDIVIDUALS.Gender, INDIVIDUALS.[Soc Sec No],
INDIVIDUALS.[2006], [2006 Teams].[CT Code], [2006 Clubs].[Team Code],
[2006
Teams].[Club ID], INDIVIDUALS.Email, [2006 Clubs].[Club Name], [2006
Teams].[Team Name], INDIVIDUALS.[Background Screen],
INDIVIDUALS.[Background
Expires], INDIVIDUALS.[Background Date]
FROM [2006 Clubs] INNER JOIN ((INDIVIDUALS INNER JOIN [Individual Join] ON
INDIVIDUALS.[Member #] = [Individual Join].[Member #]) INNER JOIN [2006
Teams] ON [Individual Join].[Team ID] = [2006 Teams].[Team ID]) ON [2006
Clubs].[Club ID] = [2006 Teams].[Club ID]
WHERE ((([2006 Teams].[Team ID]) Between [First Team ID] And [Second Team
ID]) AND ((INDIVIDUALS.[2006])="Y"))
ORDER BY [2006 Teams].Division, [2006 Teams].[Team ID];
Thanks!
Duane Hookom said:Did you re-check your report's record source datasheet view?
Is there a reason why you set control sources to:
Control Source: =([impact date])
rather than just
Control Source: [impact date]
Where did the "..show up for adults..." come in to this issue? Do you
have a
SQL view of the record source you would like to share?
--
Duane Hookom
MS Access MVP
--
The text boxes are in the detail section. The report lists coaches and
their
impact certification and background screening dates. The first two
people
both things show up and the third person nothing shows. The fourth and
fifth
person only the background screening date shows up.
the text box for impact dates =([impact date]) and =([background
screening
date])
I only want the information to show up for adults and if it is null to
be
left blank.
Thanks!
:
When I run a query all of the information shows up and when I run the
report
with using the query it is missing some information. Usually the third
person's information and the first part of the 4th and 5th person.
What is going on?
Judy said:Just individual information is not showing up. How do I go about checking
this?
Thanks!
Duane Hookom said:If some values display for some records and not others than there is
either
no data to display or code or conditional formatting is hiding the data.
Are
entire teams not showing or just individuals?
I don't care much for your table structure but I assume it is working for
you. 2006 should really be a data value in a field in a table and not
part
of a table or field name.
--
Duane Hookom
MS Access MVP
Judy said:Yes-I rechecked the datasheet view. I changed the control source and
nothing
changed.
Here is the SQL
SELECT DISTINCTROW [2006 Teams].Division, [2006 Teams].[Team Gender],
[Individual Join].Coach, [Individual Join].[Member #],
INDIVIDUALS.[First
Name], INDIVIDUALS.[Last Name], INDIVIDUALS.Address1,
INDIVIDUALS.Address2,
INDIVIDUALS.City, INDIVIDUALS.St, INDIVIDUALS.ZIP, INDIVIDUALS.Impact,
INDIVIDUALS.[Impact Date], INDIVIDUALS.HPhone, INDIVIDUALS.WPhone,
INDIVIDUALS.Birthday, [Individual Join].[Team Rep], [2006 Teams].[Team
ID],
INDIVIDUALS.[Member Type], INDIVIDUALS.Gender, INDIVIDUALS.[Soc Sec
No],
INDIVIDUALS.[2006], [2006 Teams].[CT Code], [2006 Clubs].[Team Code],
[2006
Teams].[Club ID], INDIVIDUALS.Email, [2006 Clubs].[Club Name], [2006
Teams].[Team Name], INDIVIDUALS.[Background Screen],
INDIVIDUALS.[Background
Expires], INDIVIDUALS.[Background Date]
FROM [2006 Clubs] INNER JOIN ((INDIVIDUALS INNER JOIN [Individual Join]
ON
INDIVIDUALS.[Member #] = [Individual Join].[Member #]) INNER JOIN [2006
Teams] ON [Individual Join].[Team ID] = [2006 Teams].[Team ID]) ON
[2006
Clubs].[Club ID] = [2006 Teams].[Club ID]
WHERE ((([2006 Teams].[Team ID]) Between [First Team ID] And [Second
Team
ID]) AND ((INDIVIDUALS.[2006])="Y"))
ORDER BY [2006 Teams].Division, [2006 Teams].[Team ID];
Thanks!
:
Did you re-check your report's record source datasheet view?
Is there a reason why you set control sources to:
Control Source: =([impact date])
rather than just
Control Source: [impact date]
Where did the "..show up for adults..." come in to this issue? Do you
have a
SQL view of the record source you would like to share?
--
Duane Hookom
MS Access MVP
--
The text boxes are in the detail section. The report lists coaches
and
their
impact certification and background screening dates. The first two
people
both things show up and the third person nothing shows. The fourth
and
fifth
person only the background screening date shows up.
the text box for impact dates =([impact date]) and =([background
screening
date])
I only want the information to show up for adults and if it is null
to
be
left blank.
Thanks!
:
When I run a query all of the information shows up and when I run
the
report
with using the query it is missing some information. Usually the
third
person's information and the first part of the 4th and 5th person.
What is going on?
Duane Hookom said:Again, I would keep pushing you back to view the report's record source in
datasheet view. If a record/field value is displaying in this view, it
should display in a bound control in the detail section of your report
unless you are filtering out that record.
--
Duane Hookom
MS Access MVP
Judy said:Just individual information is not showing up. How do I go about checking
this?
Thanks!
Duane Hookom said:If some values display for some records and not others than there is
either
no data to display or code or conditional formatting is hiding the data.
Are
entire teams not showing or just individuals?
I don't care much for your table structure but I assume it is working for
you. 2006 should really be a data value in a field in a table and not
part
of a table or field name.
--
Duane Hookom
MS Access MVP
Yes-I rechecked the datasheet view. I changed the control source and
nothing
changed.
Here is the SQL
SELECT DISTINCTROW [2006 Teams].Division, [2006 Teams].[Team Gender],
[Individual Join].Coach, [Individual Join].[Member #],
INDIVIDUALS.[First
Name], INDIVIDUALS.[Last Name], INDIVIDUALS.Address1,
INDIVIDUALS.Address2,
INDIVIDUALS.City, INDIVIDUALS.St, INDIVIDUALS.ZIP, INDIVIDUALS.Impact,
INDIVIDUALS.[Impact Date], INDIVIDUALS.HPhone, INDIVIDUALS.WPhone,
INDIVIDUALS.Birthday, [Individual Join].[Team Rep], [2006 Teams].[Team
ID],
INDIVIDUALS.[Member Type], INDIVIDUALS.Gender, INDIVIDUALS.[Soc Sec
No],
INDIVIDUALS.[2006], [2006 Teams].[CT Code], [2006 Clubs].[Team Code],
[2006
Teams].[Club ID], INDIVIDUALS.Email, [2006 Clubs].[Club Name], [2006
Teams].[Team Name], INDIVIDUALS.[Background Screen],
INDIVIDUALS.[Background
Expires], INDIVIDUALS.[Background Date]
FROM [2006 Clubs] INNER JOIN ((INDIVIDUALS INNER JOIN [Individual Join]
ON
INDIVIDUALS.[Member #] = [Individual Join].[Member #]) INNER JOIN [2006
Teams] ON [Individual Join].[Team ID] = [2006 Teams].[Team ID]) ON
[2006
Clubs].[Club ID] = [2006 Teams].[Club ID]
WHERE ((([2006 Teams].[Team ID]) Between [First Team ID] And [Second
Team
ID]) AND ((INDIVIDUALS.[2006])="Y"))
ORDER BY [2006 Teams].Division, [2006 Teams].[Team ID];
Thanks!
:
Did you re-check your report's record source datasheet view?
Is there a reason why you set control sources to:
Control Source: =([impact date])
rather than just
Control Source: [impact date]
Where did the "..show up for adults..." come in to this issue? Do you
have a
SQL view of the record source you would like to share?
--
Duane Hookom
MS Access MVP
--
The text boxes are in the detail section. The report lists coaches
and
their
impact certification and background screening dates. The first two
people
both things show up and the third person nothing shows. The fourth
and
fifth
person only the background screening date shows up.
the text box for impact dates =([impact date]) and =([background
screening
date])
I only want the information to show up for adults and if it is null
to
be
left blank.
Thanks!
:
When I run a query all of the information shows up and when I run
the
report
with using the query it is missing some information. Usually the
third
person's information and the first part of the 4th and 5th person.
What is going on?