Search results

I need a formula to use in a excel spreadsheet... Cell A1 could be any number between 0 and 12. I need the formula to reflect this in Cell B1: If 0 Then 0 If >0 and <= 8.5 Then 8 If >8.5 and <= 9.25 Then 9 If >9.25 Then 11 I'm sure its a simple way to do this without using VBA. I guess my...

I have a chart that I need grouped. It shows only the summary chart for each grouped line. Here is the chart SQL: SELECT qry_focus1.[Main Section], Sum(qry_focus1.Hours) AS [Delay Hours-Summary], Sum(qry_focus1.Occurrences) AS [Delay Count-Summary] FROM qry_focus1 WHERE...

I use this on most queries where I need to return all results if the form field is left blank. Works like a charm every time... Like [Forms]![frm_main_menu]![Week] & "*" Or Is Null except for this time... I need to filter by week number (52 weeks in a year)... problem is if I enter week "1"...

Hi All, I recently ran into a problem with closing excel. This code has worked for over a year running 5 times a day with no problem. Recently Mircosoft office and XP SP3 updates came through on my PC. Now the code will not close my excel process. :( I am using Access 2007 and Windows XP...

I export data on a daily basis from Access 2007 to Excel 2007 with no problems. Okay... this works and places the data in the first worksheet of the document. MySheetPath = "T:\Dept\HotDogs.xlsx" I have a application where I need to place the data in the second sheet of the document. I tried...

Hi All, I have a module that I call when loading forms to eliminate the need for repeatedly asking of IDs and passwords for ODBC connections. This exact same module works fantastic on over a dozen databases that I have built. However I have one database I simply can not get this to work on...

I know this is probably explained in this forum somewhere but I just can't find exactly what I am looking for. What I want is to update 2 millisecond time fields bases on a comparision between a current row field and a previous row field. In the attached JPEG I would want the results to...

Can I highlight certains cells in a particular column using VBA? I have attached a simple example. I want to highlight "Due Date" cells that are older than 30 days that do not have a date entered under "Date Complete". So in the attached example the only cell that should highlight would be A5

I am trying to get a end date based off of a next row in sequence for each person by job in my query. My query results keep repeating the same end dates for eack of my persons jobs. I think the attached picture and database will make things pretty clear. Please let me know if I haven't...

but I can't seem to figure it out. All I get is Null values when I run the query. I have a form with a start text box and a end text box. I use the form name sucessfully in the criteria row so I know there is no problem with the form name. I also know there is no problem with the qry name...

Our company has many access databases. I would like to create a main form that would allow me to open other databases with the click of a button. I have been able to do this with no problems for excel files (see the example below). I just don't know what to do to get the access databases to...

I need to find the nearest dates between two tables. Table1 contains dates 11/1/2006 to 11/30/2006 Table2 contains only two dates: 11/5/2006 11/19/2006 I want Query1 to produce the nearest date in Table2 beside each of the dates in Table 1. Example: Date Nearest Date...

How can I get a make-table query to run in a report?

My new job requires me to use access so I'm learning as I go. :confused: I have already used previous threads from this forum to answer another problem I encountered. Thanks for providing this forum to the public! I am attemping to run a query that will subtract military time. (I am not...