Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Tetol
  • Order by date
  1. Tetol

    Update script is changing the number of records for the values updated each time I run the 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...
  2. Tetol

    How do I show duplicate row values on a matrix report

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

    Switch or IIF

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

    Switch or IIF

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

    Switch or IIF

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

    Switch or IIF

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

    Query: Have content of one drop down column depend on another column

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

    Query: Have content of one drop down column depend on another column

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

    Plesae Help: Names of columns are repeated when I export to Excel

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

    Plesae Help: Names of columns are repeated when I export to Excel

    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?
  11. Tetol

    Report Footer Issue

    dhookom - Thank you so much. It worked perfectly.
  12. Tetol

    Plesae Help: Names of columns are repeated when I export to Excel

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

    Report Footer Issue

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

    Report Footer Issue

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

    How to stop column names from repeating when U export to Excel

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

    How to stop column names from repoeating when export to Excel

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

    Assigning multiple parameters using a form in vb

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

    Assigning multiple parameters using a form in vb

    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]...
  19. Tetol

    Assigning multiple parameters using a form in vb

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

    Assigning multiple parameters using a form in vb

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

Part and Inventory Search

Back
Top