Problem with query and report

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

Guest

I have a query that feeds a report. The report shows incidents with points
attributed for each over a period of time. Points can be given by two
different sources. I only need to show records with points.

Initially my query showed records with point values in both fields - which
pointed out an error in data entry - both should not be filled in.

Now the query shows ALL records for the time period - including those with
no points in either field.

I need my query to show records with points in EITHER one of the points
fields. If I use >= 0 (zero can be assigned; it's blank if there are no
incidents)in both of the points fields, I'm back to where it shows the
records with points in each field.

Can anyone help me? Thanks.
 
I need my query to show records with points in EITHER one of the points
fields.
Click to expand...

Use a criterion of

IS NOT NULL

on both fields, on *separate* lines in the query grid.

The fact that you have two mutually dependent fields in your table
design is in violation of relational integrity rules - which is why
you're having the problem! Any chance you could have just one Points
field, since it's illegal to fill in both of them anyway?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John -

Thanks for your assistance. That did work. For some reason, the programmer
that assisted me in the design of this database said I needed the two fields.
They are on different screens and are attributable to different committee
levels - which is why both should not be filled in.

Thanks again for your help.

Mary
 
John -

Thanks for your assistance. That did work. For some reason, the programmer
that assisted me in the design of this database said I needed the two fields.
They are on different screens and are attributable to different committee
levels - which is why both should not be filled in.
Click to expand...

I'd say the solution would be to have ONE field, displayed on two
different controls.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top