Show data on criteria

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

Guest

How to achieve the next item in a report :
I only want to show data when it is in its criteria :

So my datafield is called "Bit_count" where values like "128 BIT", "256 BIT"
can reside.
I Only like to display information in my report when the value is "128 BIT".

How to solve this problem.
Thanks for comments.
 
Jereon,
Sounds like you're trying to restrict the records delivered by the report
to only records with a Bit_Count of "128 Bit"??
What is the RecordSource of your report?
If it's a Table, then change it to a Query (based on that same table),
and give the Bit_Count field a criteria of...
= "128 Bit"

A minor point... if a field is named Bit_Count, there's probably no need
to include the text "Bit" along with value of 128. In fact, Bit_Count would
be better as a numeric field, with values like 128 or 256, instead of "128
Bit" and "256 Bit"
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."
 
Well,

I like to have this variable on my report but ONLY displayed when it is
value 128.
If I put a textfield on my report, I cannot see any posibility to change it
to a query.

So basicly I just want 1 report to display several fields, but the bit count
only when 128.
 
Jeroen,
If I put a textfield on my report, I cannot see any posibility to change
it
to a query.
Click to expand...
I was referring to the query behind the report itself

Here's an example of how to alter what a control displays on a report...
if the Bit_Count = "128 Bit"
Create an unbound calculated field on the report with a ControlSource
of...

= IIF([Bit_Count] = "128 Bit", [SomeField], [SomeOtherField])

Which means...
If Bit_Count = "128 Bit" then display the [SomeField] value here... and
if not... display the [SomeOtherField] value.

--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top