I'm doing a database for our county's Medical Reserve Corps. I have a query made up of 2 tables. The first table has person ID information and some other information. One field asks if the individual has a military obligation in the case of an emergency. A second table has a list of other possible committments like being on staff at a hospital, red cross, etc. The query ends up listing the military obligation for as many entries there are for other committments. Eg,
Name Military_Obligation? Other_Committments
Jane Doe Yes Red Cross
Jane Doe Yes Hospital/Clinic
Now, I would prefer just to add "Military Obligation" to the list of all committments so it doesn't get listed more than once. However, the people I'm doing this for want the fields to match a database the State is doing as closely as possible in the case the State actually makes something useable to the Counties for retrieving data.
So, is there any way to have the query just put in a blank the second time the same data would occur. That would look kind of like a report. I just want it to be more readable to the users. I don't want to do a report because they want to do some querying themselves. Eg,can the query look like this. Thanks.
Jane Doe Yes Red Cross
Jane Doe Hospital/Clinic
Name Military_Obligation? Other_Committments
Jane Doe Yes Red Cross
Jane Doe Yes Hospital/Clinic
Now, I would prefer just to add "Military Obligation" to the list of all committments so it doesn't get listed more than once. However, the people I'm doing this for want the fields to match a database the State is doing as closely as possible in the case the State actually makes something useable to the Counties for retrieving data.
So, is there any way to have the query just put in a blank the second time the same data would occur. That would look kind of like a report. I just want it to be more readable to the users. I don't want to do a report because they want to do some querying themselves. Eg,can the query look like this. Thanks.
Jane Doe Yes Red Cross
Jane Doe Hospital/Clinic