How to suppress printing a value in a field depending on the value in another field.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Julian Allsopp (ng_at_removecrusade.demon.co.uk)
Date: 11/14/04 

Date: Sun, 14 Nov 2004 17:05:23 +0000

Please can someone help.

I have a report, based on a query, in which for each record I want to
print a value in Field A only if Field B contains a specific value.

The fields are text fields and although Field A will always contain a
value, that value should only be shown on the report if the text in
Field B is, for example "Valid".

How can I achieve this. I guess it's going to need a VB procedure but
I'm not yet experienced enough in VBA to handle this.

I'm running Access 2000 on XP Professional.

With thanks in advance. 

-- 
Julian Allsopp
Northampton
UK

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)