Football report showing dropped out children

[tjsmags]

I have a report that gives me a football roster. One of the FIELDS in the
football players TABLE is for DROPPED OUT children (Yes/No). How do I tell
the football roster report to leave OFF the children names that have dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?

 

[Ron Weiner]

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W

 

[tjsmags]

Since I'm new to this, can you please explain EXACTLY what I do?

In the SQL Statement Query Builder I have:

Field: Football players.*
Table: Football players
Sort:
Show: there's a checkmark
Criteria:
or:

I don't know what to fill in...

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W

I have a report that gives me a football roster. One of the FIELDS in the
football players TABLE is for DROPPED OUT children (Yes/No). How do I
tell
the football roster report to leave OFF the children names that have
dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?

 

[Ron Weiner]

I am just guessing at what your database looks like but:

I am guessing that in your report you have the reports Record Source set to
the name of a table. I think that table name is "football players". I am
also guessing that the Column in the table "football players" that is the
Yes/No column is named "DROPPED OUT".

If all these guesses are correct then copy the line below directly from this
post and paste it into the Record Source of the report you are working on.

SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Save the report and run it. If my guesses were wrong then you will need to
either adjust the names to whatever you have in your data base, or post back
with ALL the details of what you have and what you want.

Ron W

Since I'm new to this, can you please explain EXACTLY what I do?

In the SQL Statement Query Builder I have:

Field: Football players.*
Table: Football players
Sort:
Show: there's a checkmark
Criteria:
or:

I don't know what to fill in...

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W

I have a report that gives me a football roster. One of the FIELDS in
the
football players TABLE is for DROPPED OUT children (Yes/No). How do I
tell
the football roster report to leave OFF the children names that have
dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?

 

[tjsmags]

Great. This worked PERFECTLY. Now, I forgot one more criteria, and I don't
know how to make it work with this. I have a TABLE called Division (Flag,
70lb, 80lb, 90lb, etc). I want this report to pull only children who have
NOT dropped out AND ALSO just FLAG division members (right now it's pulling
ALL football members listed in the Football players table). Can I do this?

I am just guessing at what your database looks like but:

I am guessing that in your report you have the reports Record Source set to
the name of a table. I think that table name is "football players". I am
also guessing that the Column in the table "football players" that is the
Yes/No column is named "DROPPED OUT".

If all these guesses are correct then copy the line below directly from this
post and paste it into the Record Source of the report you are working on.

SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Save the report and run it. If my guesses were wrong then you will need to
either adjust the names to whatever you have in your data base, or post back
with ALL the details of what you have and what you want.

Ron W

Since I'm new to this, can you please explain EXACTLY what I do?

In the SQL Statement Query Builder I have:

Field: Football players.*
Table: Football players
Sort:
Show: there's a checkmark
Criteria:
or:

I don't know what to fill in...

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W
I have a report that gives me a football roster. One of the FIELDS in
the
football players TABLE is for DROPPED OUT children (Yes/No). How do I
tell
the football roster report to leave OFF the children names that have
dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?

 

[Ron Weiner]

The answer to your questions is Probably yes, but without knowing what the
relationship is between the two tables and what the column names are it is
not possible to give you any direction. If you need help to put this
together we will need to know a lot more about how your database is
constructed. Provide that names of both tables, the names all of the
pertinent columns in both tables, and what the relationship is between the
two tables, and I am sure we can get you going.

On the other hand you might want to do a little light reading about using
Queries with Inner (and Outer) Joins to join related tables.

Ron W

Great. This worked PERFECTLY. Now, I forgot one more criteria, and I
don't
know how to make it work with this. I have a TABLE called Division (Flag,
70lb, 80lb, 90lb, etc). I want this report to pull only children who have
NOT dropped out AND ALSO just FLAG division members (right now it's
pulling
ALL football members listed in the Football players table). Can I do
this?

I am just guessing at what your database looks like but:

I am guessing that in your report you have the reports Record Source set
to
the name of a table. I think that table name is "football players". I
am
also guessing that the Column in the table "football players" that is the
Yes/No column is named "DROPPED OUT".

If all these guesses are correct then copy the line below directly from
this
post and paste it into the Record Source of the report you are working
on.

SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Save the report and run it. If my guesses were wrong then you will need
to
either adjust the names to whatever you have in your data base, or post
back
with ALL the details of what you have and what you want.

Ron W

Since I'm new to this, can you please explain EXACTLY what I do?

In the SQL Statement Query Builder I have:

Field: Football players.*
Table: Football players
Sort:
Show: there's a checkmark
Criteria:
or:

I don't know what to fill in...

:

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W
I have a report that gives me a football roster. One of the FIELDS
in
the
football players TABLE is for DROPPED OUT children (Yes/No). How do
I
tell
the football roster report to leave OFF the children names that have
dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?

 

[tjsmags]

The TABLE with all the football members and their pertinent data is called
Football players. I have FIELDS within this table called Dropped Out (Yes/No
data type) and Division (Text data type with display control=combo box, row
source type=table/query, row source=SELECT Division.Division FROM Division).
I also have a separate TABLE called Division that lists your drop down
choices of Flag, 70lb, 80lb, etc.

Does this help?

The answer to your questions is Probably yes, but without knowing what the
relationship is between the two tables and what the column names are it is
not possible to give you any direction. If you need help to put this
together we will need to know a lot more about how your database is
constructed. Provide that names of both tables, the names all of the
pertinent columns in both tables, and what the relationship is between the
two tables, and I am sure we can get you going.

On the other hand you might want to do a little light reading about using
Queries with Inner (and Outer) Joins to join related tables.

Ron W

Great. This worked PERFECTLY. Now, I forgot one more criteria, and I
don't
know how to make it work with this. I have a TABLE called Division (Flag,
70lb, 80lb, 90lb, etc). I want this report to pull only children who have
NOT dropped out AND ALSO just FLAG division members (right now it's
pulling
ALL football members listed in the Football players table). Can I do
this?

I am just guessing at what your database looks like but:

I am guessing that in your report you have the reports Record Source set
to
the name of a table. I think that table name is "football players". I
am
also guessing that the Column in the table "football players" that is the
Yes/No column is named "DROPPED OUT".

If all these guesses are correct then copy the line below directly from
this
post and paste it into the Record Source of the report you are working
on.

SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Save the report and run it. If my guesses were wrong then you will need
to
either adjust the names to whatever you have in your data base, or post
back
with ALL the details of what you have and what you want.

Ron W

Since I'm new to this, can you please explain EXACTLY what I do?

In the SQL Statement Query Builder I have:

Field: Football players.*
Table: Football players
Sort:
Show: there's a checkmark
Criteria:
or:

I don't know what to fill in...

:

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W
I have a report that gives me a football roster. One of the FIELDS
in
the
football players TABLE is for DROPPED OUT children (Yes/No). How do
I
tell
the football roster report to leave OFF the children names that have
dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?

 

[Ron Weiner]

Try this:

SELECT * FROM [football players] WHERE [DROPPED OUT] = False AND Division =
'Flag'


This assumes that the Column Division is a text field that has the text
Flag, or 70lb, or 80lb, or whatever in it.


Ron W

The TABLE with all the football members and their pertinent data is called
Football players. I have FIELDS within this table called Dropped Out
(Yes/No
data type) and Division (Text data type with display control=combo box,
row
source type=table/query, row source=SELECT Division.Division FROM
Division).
I also have a separate TABLE called Division that lists your drop down
choices of Flag, 70lb, 80lb, etc.

Does this help?

The answer to your questions is Probably yes, but without knowing what
the
relationship is between the two tables and what the column names are it
is
not possible to give you any direction. If you need help to put this
together we will need to know a lot more about how your database is
constructed. Provide that names of both tables, the names all of the
pertinent columns in both tables, and what the relationship is between
the
two tables, and I am sure we can get you going.

On the other hand you might want to do a little light reading about using
Queries with Inner (and Outer) Joins to join related tables.

Ron W

Great. This worked PERFECTLY. Now, I forgot one more criteria, and I
don't
know how to make it work with this. I have a TABLE called Division
(Flag,
70lb, 80lb, 90lb, etc). I want this report to pull only children who
have
NOT dropped out AND ALSO just FLAG division members (right now it's
pulling
ALL football members listed in the Football players table). Can I do
this?

:

I am just guessing at what your database looks like but:

I am guessing that in your report you have the reports Record Source
set
to
the name of a table. I think that table name is "football players".
I
am
also guessing that the Column in the table "football players" that is
the
Yes/No column is named "DROPPED OUT".

If all these guesses are correct then copy the line below directly
from
this
post and paste it into the Record Source of the report you are working
on.

SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Save the report and run it. If my guesses were wrong then you will
need
to
either adjust the names to whatever you have in your data base, or
post
back
with ALL the details of what you have and what you want.

Ron W

Since I'm new to this, can you please explain EXACTLY what I do?

In the SQL Statement Query Builder I have:

Field: Football players.*
Table: Football players
Sort:
Show: there's a checkmark
Criteria:
or:

I don't know what to fill in...

:

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W
I have a report that gives me a football roster. One of the
FIELDS
in
the
football players TABLE is for DROPPED OUT children (Yes/No). How
do
I
tell
the football roster report to leave OFF the children names that
have
dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?

 

[tjsmags]

You rock!

Try this:

SELECT * FROM [football players] WHERE [DROPPED OUT] = False AND Division =
'Flag'


This assumes that the Column Division is a text field that has the text
Flag, or 70lb, or 80lb, or whatever in it.


Ron W

The TABLE with all the football members and their pertinent data is called
Football players. I have FIELDS within this table called Dropped Out
(Yes/No
data type) and Division (Text data type with display control=combo box,
row
source type=table/query, row source=SELECT Division.Division FROM
Division).
I also have a separate TABLE called Division that lists your drop down
choices of Flag, 70lb, 80lb, etc.

Does this help?

The answer to your questions is Probably yes, but without knowing what
the
relationship is between the two tables and what the column names are it
is
not possible to give you any direction. If you need help to put this
together we will need to know a lot more about how your database is
constructed. Provide that names of both tables, the names all of the
pertinent columns in both tables, and what the relationship is between
the
two tables, and I am sure we can get you going.

On the other hand you might want to do a little light reading about using
Queries with Inner (and Outer) Joins to join related tables.

Ron W
Great. This worked PERFECTLY. Now, I forgot one more criteria, and I
don't
know how to make it work with this. I have a TABLE called Division
(Flag,
70lb, 80lb, 90lb, etc). I want this report to pull only children who
have
NOT dropped out AND ALSO just FLAG division members (right now it's
pulling
ALL football members listed in the Football players table). Can I do
this?

:

I am just guessing at what your database looks like but:

I am guessing that in your report you have the reports Record Source
set
to
the name of a table. I think that table name is "football players".
I
am
also guessing that the Column in the table "football players" that is
the
Yes/No column is named "DROPPED OUT".

If all these guesses are correct then copy the line below directly
from
this
post and paste it into the Record Source of the report you are working
on.

SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Save the report and run it. If my guesses were wrong then you will
need
to
either adjust the names to whatever you have in your data base, or
post
back
with ALL the details of what you have and what you want.

Ron W

Since I'm new to this, can you please explain EXACTLY what I do?

In the SQL Statement Query Builder I have:

Field: Football players.*
Table: Football players
Sort:
Show: there's a checkmark
Criteria:
or:

I don't know what to fill in...

:

Use a Select statement (query) as the record source for the report.
Something like:
SELECT * FROM [football players] WHERE [DROPPED OUT] = False

Ron W
I have a report that gives me a football roster. One of the
FIELDS
in
the
football players TABLE is for DROPPED OUT children (Yes/No). How
do
I
tell
the football roster report to leave OFF the children names that
have
dropped
out (i.e. there's a checkmark in the yes/no box for dropped out)?