Selecting Records to Print Based on Criteria

  • Thread starter Thread starter TitansFan
  • Start date Start date
T

TitansFan

The Access "Help" doesn't make this clear for me. I want
to print a report containing five fields from two
different tables but I only want the detail line to print
if one of the fields is greater than zero. How can I do
this easily? Thanks.
 
I must not be saying this properly. I'm not talking about
a query, I'm talking about a report. There is no place to
put a criteria under the field that I can see. What am I
missing? I open the report in design mode but there is no
place to enter criteria. Thanks.

Stu Miller
 
Duane, thanks for trying to assist. Wow, Crystal Reports
is a lot easier for selecting criteria to print than
Access is! I double-clicked on a report selector to open
the property sheet. I tried to build a query specifiying
only to print the detail line if a particular field in one
table is not equal to a field in abother table.. I
thought I had that right. I saved the thing but when I
opened the report, it started asking me for all sorts of
parameters that have nothing to do with criteria.

Let me give you the example. For simplicity sake, there
are two tables, one called Clients and one called Invoices.

Clients has two fields (it has more but not needed for
this); ClientID, ClientName

Invoices has four fields (it has more, but we don't need
them for this): ClientID (the relationship), InvoiceAmt,
PaymentAmt

I want a report (Open Invoices) that will print
ClientName, ClientID, InvoiceAmt and PaymentAmt but ONLY
if PaymentAmt is not = to InvoiceAmt. I want all clients
that match the criteria so I don't want to select any
parameters there.

Can you give me a quick pointer, please? Believe it or
not, I'm a fairly experienced IT guy but this is my first
go-around with Access 2000. Thanks very much. (I tried
your email address but it was rejected.)

Stu Miller
 
I would expect that your reports recordsource contains both tables and a
join line between the ClientID fields. Add the required fields to the query
grid and set the criteria under the
Field: PaymentAmt
Criteria: <>InvoiceAmt
 
Many thanks!
-----Original Message-----
I would expect that your reports recordsource contains both tables and a
join line between the ClientID fields. Add the required fields to the query
grid and set the criteria under the
Field: PaymentAmt
Criteria: <>InvoiceAmt

--
Duane Hookom
MS Access MVP





.
Click to expand...
 
Back
Top