Search results for query: *

I have a a query result set in a temp table1 with 5 columns. AcctNum, Location, GroupName, Count1, Count2. Columns Count1 and Count tow has 1s and nulls in it all the way through. I intend to sum these columns and group by Location, GroupName in a later step. I need to update the GroupName...

Please help. On a ssrs matric report, the values on subsequent rows are blank when the values are the same. How do I make changes to have it display even when the valuyes are the same Thank you

Yep - That was the issue - Percentages. It worked this time. Thanks for your patience and help.

Ok so with this code =IIF(Fields!FieldA.Value = 0.00, "White", IIF(Fields!FieldA.Value < Fields!Target.Value, "Red", IIF(ABS(Fields!FieldA.Value - Fields!Target.Value) <= 10, "Yellow","White" ))) Target FieldA Actual Result Desired Result 60% 35.16% Red...

Plesae see below what I tried but it still did not work. All values of FieldA greater than Target turned yellow but I want FieldA to turn yellow only when the difference between FieldA and Target is <= 10. =IIF(Fields!FieldA.Value = 0.00, "White", IIF(Fields!FieldA.Value < Fields!Target.Value...

I am trying to contruct a switch or IIf statement compare values in two fields to higlight cells on a report to eith White, Red or Yellow. The part I has the issue is if field FieldA is within +-10 of the Target field, to make the cell yellow. I have also tried using the field option but it's...

MajP...Thanks you, that's what I thought also. I have Access 2007 and I could not figure a way to do this except if I set it up on an Access form. What I was really trying to do is create a query/table that I could base an InfoPath form on. Then the form can be emailed to recepients who...

I have a States table and a Cities table with a one to many relationship. Can I have a query such that when I choose a state in the states' drop down column, it will show only the cities for that state in the cities' drop down column. I know how to do this in a form but i would like to do...

Sorry, I should refine my question below. My original report has a subreport in it. The main report and subreport are based on two different tables. The reason I wanted to export the report to excel is so I would have the records from the two tables in one file. So I cannot export one...

Thanks folks. My next question is how do you export a table/query to excel by just the click of a form button? Can you set this up using a macro? Thanks again?

dhookom - Thank you so much. It worked perfectly.

Hello- I have Access 2007. My report has a subreport in it and when I export the report to Excel, each time the records in the subreport is more than one page, Excel displays the column names again. This does not look good. How do I stop the column names from repeating in excel. The...

This would be nice but how do you make it invisible on all but the last page? If possible, this should solve my issue Thank you.

I have access 2007. My report footer contains a legal disclaimer. However, it doesn't print on the last page of the report, at the very buttom. So the disclaimer usually ends up in diffrent positions on the last page depending on the lenght of the records. How can I get the report footer...

I have Access 2007. My report has a subreport in it and when I export the report to Excel, each time the records in the subreport span more than one page, Excel displays the column names again. This does not look good. How do I stop the column names from repeating in excel. The subreport is...

Hello- I have Access 2007. My report has a subreport in it and when I export the report to Excel, each time the records in the subreport span more than one page, Excel displays the column names again. This does not look good. How do I stop the column names from repeating in excel. The...

FYI - The tip by PHV also worked but would still be interested in the other method. Thank you

Here are the details - Combo1 is a date data type e.g. 02/2011 Row Source: SELECT DISTINCT qryReportingPeriod.ReportPeriod FROM qryReportingPeriod; Combo2 is a text data type e.g. Alab, Miss Row Source: SELECT tblA.StateCode, tblA.StateName FROM tblA ORDER BY tblA.[StateCode]...

FYI Combo1 is a date data type Combo2 is a test data type combo3 is a text data type Thanks

Aceman1 - I just got back to this issue toay. Thanks for the responses. However I have a question for each of the methods we have tried. For the first method: The code below is now working except when the value has a ' in it as in "St. Mary's" or "St Joseph's". If the value is "St. Mary"...