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

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

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

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

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

I have a form with 3 combo boxes that I would like to uses to filter records in query. I used the If..Then statement I have written the code to run a query if one of the 3 boxes has value in it and it works. If Not IsNull(Me.[Combo1]) And IsNull(Me.[Combo2]) And IsNull(Me.[Combo3]) Then...

Hello I already applied a dropdown list at the top of my excel worksheet. How do I setup the list to filter records in the worksheet. I only want to use that single cell with the dropdown to filter records. Thanks for your help