Search results for query: *

Thank you for your help. I tried to edit the chart object but I was not able to change the data points to non-numerical values. I also tried to place text fields in between the data points but the chart is dynamic and holds a different amount of data for each report record, the text fields are...

Is there a way to change the data point labels on a chart that is embedded in a report? Component1------------ Component2------------------ Component3 ---------- _____________________ 0 1 2 3 4 5 This is what the chart looks like...

Thank you for the reply. Here is what I'm trying to do: I need to base the color of a rectangle on the data in a text box. If the value of "avgStatus" is between 1-2 the rectagle needs to be red, If the value of "avgStatus" is between 2-3 the rectagle needs to be blue...

Is it possible to specify more than 3 conditions for a single control? Thanks. Cheers.

Hi, I'm trying to create a report which has two grouping levels. I need the details fields to be displayed horizontally, adjacent to the subgroup heading. The number of records in the detail section is variable. (It doesn't really matter if the rows go off of the page). Group1 Sub Group1...

I'm experiencing serious problems with access reports. The problem I'm currently facing: I have 2 crosstab queries: qryCost: FacilityName Date1 Date2 Date3.....Date24 Building1 Cost Cost Cost......Cost Building2 Cost Cost Cost......Cost qryUsage: FacilityName Date1 Date2...

I used the search feature and couldn't find any related posts. I'm trying to create a report which combines 2 crosstab queries. The crosstab queries are similar in layout and the data presented. This is what the queries look like: Facility Date1, Date2... Building One Taxes...

That worked flawlessly. Thank you so much!!! You are a life saver! Thanks.

Hi I have a query which pulls two fields from a table. The fields are: Month Year In the table both of these fields are of data type "Number" In the query I put them together by: Date: [tblArchive].[Month] & " " & [tblArchive].[Year] What I want to do is make the data...

Does anyone know how to refer to the name of a text box with a variable? Here is an example of what I need: If a text box is named txtRate and strTest = "txtrate" I want to be able to refer to the control using the string: me.[strTest].value = whatever