Reports..blank fields

[Guest]

Hi,

I want to create report and want to show only those fields which met the
criteria. All other fileds which don't have that value I am looking for I
don't want them to appear in the reports/query.

Like in my query I have criteria set for Job location, BA, BS, MA. Now I
want to run query by job location say MD and I want who have BS degree as
Yes. When I run my query I see all the fields..job location as MD and BS
degree as Yes but there will also be BA, MA as No. I just want to see job
location and BS only. or if I want to see job location and MA degree..so I
should only these two fields met criteria..other fileds with 'No' should not
appear in the query or report.

How can I do that? I would appreciate your help. Thanks you so very much.

 

[Duane Hookom]

Please provide
-your table structure(s)
-Some sample records
-How you would like this to appear in your report
-How are you setting the criteria

I expect that you have been committing spreadsheet by placing values into
field names.

 

[chinita18]

Hi I think I have the same concern about creating a report with a criteria.

My database is for an online school. And i wanted to create a report for inactive students (those who have not submitted any assignment for given period of time or for the month.

I have created a query that has Student Name, Attendance Date, Status (which has values to choose from like Enrolled, Received Task, Marked Task etc.) and then the task submitted. I've already created 2 additional fields for the query which is fieldmonth and fieldyear so we can choose which month and year they are inactive. The only problem I have is how can I generate the criteria for those students who are inactive? I am thinking I have to create a criteria under the Status field...but I am not sure.

In the report I only want the names and phone numbers of the students, I guess..

I hope you can help me. Thanks!