Not print a record with a NULL field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB that records law enforcement activities by pursuit car # activity
for a shift. At the end of the shift the report is completed and submitted.
The report prints the following fields: date, pursuit car #, #arrests,
#stolen Veh, etc. and a memo field. I do not want to print the record if the
memo field is NULL (blank); ie, I only want to print records with info in the
memo field. I welcome any suggestions! Running Access 2002 on WinXP Pro.
 
Just adjust your query (used as the record source of your report) to only
pull records where that field is not null.
 
Rick B said:
Just adjust your query (used as the record source of your report) to only
pull records where that field is not null.
Click to expand...


I have the same type of problem but do not understand the answer to "adjust
your query to only pull records where that field is not null." How do I do
that? There is nothing wrong with the query - it's the report that shows the
null/blank field and I want to not report on these.
 
RichK said:
I have the same type of problem but do not understand the answer to "adjust
your query to only pull records where that field is not null." How do I do
that? There is nothing wrong with the query - it's the report that shows the
null/blank field and I want to not report on these.
Click to expand...

Forget the report for now. The problem seems to be that the
query is returning records you fo not want in the report.
Run the query by itself and adjust it as I suggested in your
other post. When the query is returning only the records
you want in the report, then run the report and see where
things stand.
 
Marshall Barton said:
Forget the report for now. The problem seems to be that the
query is returning records you fo not want in the report.
Run the query by itself and adjust it as I suggested in your
other post. When the query is returning only the records
you want in the report, then run the report and see where
things stand.
Click to expand...
Marsh,
I actually got the solution from going through some other posts finally. I
created a query against the original file, excluding null values for the
Installation Date field. I then used that file as input to the report and
voila - those values were not included. Thanks very much for your help on my
behalf and on behalf of those who are looking to expand our knowledgebase.
 
Back
Top