If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show data on criteria
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. |
#2
|
|||
|
|||
Show data on criteria
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" wrote in message ... 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. |
#3
|
|||
|
|||
Show data on criteria
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" wrote: 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" wrote in message ... 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. |
#4
|
|||
|
|||
Show data on criteria
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." "Jeroen" wrote in message ... 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" wrote: 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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|