If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Football report showing dropped out children
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)? |
#2
|
|||
|
|||
Football report showing dropped out children
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" wrote in message ... 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)? |
#3
|
|||
|
|||
Football report showing dropped out children
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... "Ron Weiner" wrote: 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" wrote in message ... 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)? |
#4
|
|||
|
|||
Football report showing dropped out children
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 "tjsmags" wrote in message ... 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... "Ron Weiner" wrote: 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" wrote in message ... 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)? |
#5
|
|||
|
|||
Football report showing dropped out children
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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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... "Ron Weiner" wrote: 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" wrote in message ... 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)? |
#6
|
|||
|
|||
Football report showing dropped out children
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 "tjsmags" wrote in message ... 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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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... "Ron Weiner" wrote: 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" wrote in message ... 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)? |
#7
|
|||
|
|||
Football report showing dropped out children
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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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... "Ron Weiner" wrote: 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" wrote in message ... 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)? |
#8
|
|||
|
|||
Football report showing dropped out children
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 "tjsmags" wrote in message ... 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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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... "Ron Weiner" wrote: 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" wrote in message ... 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)? |
#9
|
|||
|
|||
Football report showing dropped out children
You rock!
"Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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? "Ron Weiner" wrote: 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 "tjsmags" wrote in message ... 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... "Ron Weiner" wrote: 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" wrote in message ... 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)? |
Thread Tools | |
Display Modes | |
|
|