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
|
|||
|
|||
Display blank fields in access
I'm trying to create a query that will show me the activities from various
schools. I have a table that lists each of the 55 schools at which my staff works. I also have 5 separate queries that list the frequency of each of the following activities (intakes,individuals, groups, presentations, mediations). Not all of the activities occur at each school. So of course, if the group query shows no groups at "Freedom School", Freedom is left out of the mix altogether. Is there any way to get the query to display each of the 55 schools, and if one of the "sub-queries"(is that the correct term?) doesn't have any data for that school, to just return a blank or zero value? Sorry, I know that this is probably a pretty elementary question, but I've been searching the help topics for weeks, and I just can't figure it out. Thank you! |
#2
|
|||
|
|||
Display blank fields in access
It will be easier to offer help if you tell us what tables you have and how
they are related. You mention only one table. Where does the list of staff members come from? -Dorian "DeAnna" wrote: I'm trying to create a query that will show me the activities from various schools. I have a table that lists each of the 55 schools at which my staff works. I also have 5 separate queries that list the frequency of each of the following activities (intakes,individuals, groups, presentations, mediations). Not all of the activities occur at each school. So of course, if the group query shows no groups at "Freedom School", Freedom is left out of the mix altogether. Is there any way to get the query to display each of the 55 schools, and if one of the "sub-queries"(is that the correct term?) doesn't have any data for that school, to just return a blank or zero value? Sorry, I know that this is probably a pretty elementary question, but I've been searching the help topics for weeks, and I just can't figure it out. Thank you! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I make blank fields in forms count as zero in Access? | ricker alford | General Discussion | 1 | August 13th, 2005 04:35 PM |
How can I hide blank fields in Access 2003 reports? | DeniseinOC | Setting Up & Running Reports | 1 | June 9th, 2005 06:35 PM |
Blank Fields in reports | Jean | Setting Up & Running Reports | 5 | April 1st, 2005 01:15 PM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |