Show data on criteria

[Jeroen]

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.

 

[Al Campagna]

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."

 

[Jeroen]

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.

 

[Al Campagna]

Jeroen,

If I put a textfield on my report, I cannot see any posibility to change
it
to a query.

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."