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 derfloh 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: *

  1. vincentharris

    Update Table

    I have a query that I have created. How would I make this query into a table. I then have that table as my main table because I will create a report in Access from it.
  2. vincentharris

    Query

    I have a query that I created. I took two tables: Table 8AM and Table 10PM. I do a comparison to see how many new tickets were created between 8AM and 10 AM. In this case it was twelve. I got 12 by scrolling down in the query and where I see a blank in under the 8AM column that is counted as...
  3. vincentharris

    Formula

    I have a spreadhseet with two tabs. One tab has all of the details. The second tab has a summary of the first tab. I have a formula as follows:=COUNTIF('DETAILED LIST'!$M:$M,"Ticket_"&TEXT(SUMMARY!$A7,"MM/DD/YYYY")) This formula is counting and summarizing TICKET that is listed on the first...
  4. vincentharris

    New Formula

    I have a spreadsheet that reads as follows: Status Tier OpenDate ResolveDate SLA ServiceLevel I wrote the following formula for Service Level and it worked just fine: =IF(F2="Tier 3","Next Business Day",IF(F2="Tier 4","3 Business Days",IF(F2="Tier 2","4 Hours",IF(F2="Tier 1","8...
  5. vincentharris

    Excel Formula

    Hello: I have a spreadsheet with the following info: SUMMARY AGENCY DNR- HD reaction is slow IBM GDC - User's having computer issues. IBM GTA-New Laptop needs visio IBM User Called stating her computer is slow IBM DHR-...

Part and Inventory Search

Back
Top