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 Chriss Miller 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 could try that and see what happens. Could you also tell me how to get the extension fiule SnapShot viewer in Access 2007?
  2. 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.
  3. vincentharris

    Query

    Skip: I figured out what I did wrong. I used the wrong table. I used the same table that was dated 7/9/2009 for 12PM instead of using the table for 7/10/2009 for 12PM. I used it and I was able to get me results. Thanks for your help. Could you tell me how I can export a report from Access...
  4. vincentharris

    Query

    YES!! it is a nightmare because I am pulling the data for the Maximo database. I am trying to create an application using Access to automate this but I am not able to create a ODBC link from the maximo database to Access. Any suggestions??
  5. vincentharris

    Query

    Skip: I was able to compare 8AM to 10AM and 10AM to 12PM and 3PM to 5PM. When I try to comapre 12PM to 3PM it gives me the pop up box Enter Paramter Value. I use the formula NewIncident: IIf([Maximo Data 12PM 07102009].[Incident] Is Null,"New Ticket") and it gives me the pop up box. What am...
  6. vincentharris

    Query

    Skip: I used this formula - NewIncident: IIf([Maximo Data 10AM 07102009].[Incident] Is Null,"New Ticket") and it seem to work fine to where it highlighted the blanks as a new ticket. When I tried to compare Maximo Data 12PM to Maximo 3PM with this formula NewIncident: IIf([Maximo Data 12PM...
  7. vincentharris

    Query

    Now it says that the expression entered contains invalid syntax.
  8. vincentharris

    Query

    The two tables I am using are called Maximo Data 10AM 07102009 and Maximo Data 12PM 07102009. The field name is Incident which is in both tables. In both tables the field names are the same. I am just comparing the two tables to see what new tickets that appear from 10am to 12 pm. In this...
  9. vincentharris

    Query

    The box says Enter Parameter value below that it says Maximo Data 10AM 07102009. The below it prompts for a value to be entered. Also how do I attached SnapViewer to Access?
  10. vincentharris

    Query

    I tried that formula and a pop up box comes up and it says Enter Paramter Value....I just want the blanks to say New Ticket. Also how can I get SnapShot Viewer in Access?
  11. vincentharris

    Query

    This is what I have so far Incident:IIF([Maximo Data 10AM 07102009] ="Is Null", "New Ticket")] I am comapring data from Maximo Data 10AM 07102009 to Maximo Data 12PM 07102009 I have 25 blanks meaning they are new tickets. I want it to show "New Ticket" where there is a blank space.
  12. vincentharris

    Query

    Thanks!!! I will test it out. Do you know by chance how I would get the previous date in a report in Access. I know if I use =Now()it will give me the current date but how to get the previous date.
  13. 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...
  14. vincentharris

    Formula

    This is my formula =COUNTIF('DETAILED LIST'!$M:$M,"Incident_"&TEXT(SUMMARY!$A7,"MM/DD/YYYY"))+COUNTIF('DETAILED LIST'!$M:$M,"Ticket_"&TEXT(SUMMARY!$A7,"MM/DD/YYYY"))+COUNTIF('DETAILED LIST'!$M:$M,"Project_"&TEXT(SUMMARY!$A7,"MM/DD/YYYY"))+COUNTIF('DETAILED...
  15. vincentharris

    Formula

    Glenn Are you sure I can use that entire formula?
  16. vincentharris

    Formula

    Glenn: This is what I needed but I do have one question....Once I put the formula in it brings me ot it ask me if I want to box that says update Values: Summary. Am I suppose to click yes to update it?
  17. 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...
  18. vincentharris

    New Formula

    Yes..I am using Excel 2007..I am not sure where to look. I see INSERT at the top between HOME and Page Layout. I am not sure what to look for when you say INSERT.
  19. vincentharris

    New Formula

    On the keyboard?? I see insert on the keyboard but still dont know where to go next. I also see INSERT next to HOME. Still not sure what to do next.
  20. vincentharris

    New Formula

    I am confused...I see INSERT at the tool bar but not sure where to go from that point.

Part and Inventory Search

Back
Top