Search results for query: *

I could try that and see what happens. Could you also tell me how to get the extension fiule SnapShot viewer in Access 2007?

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.

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

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

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

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

Now it says that the expression entered contains invalid syntax.

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

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?

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?

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.

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.

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

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

Glenn Are you sure I can use that entire 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?

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

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.

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.

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