Search results for query: *

This is how it looks in Excel, how do I need to change it for Access? =IF(MONTH(A2)+1=13,IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,(MONTH(A2)+1)-12&"/1 and newer",MONTH(A2)&"/1 and older")),(IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,MONTH(A2)+1&"/1 and newer",MONTH(A2)&"/1 and...

I have an Excel sheet where the date for field O83 is formatted General. In Access I want the query to only pull up the records where that field has data. I have tried: Is Not Null >01/01/2000 <>"" "*" "/" Like "*/*" Nothing changes it. Unable to change format in Excel because the file is...

Is it possible to change a date format from: yyyy-mm-dd 00:00:00 to mm/dd/yy in a query? And also to have the today's date in the field if the field is empty? The data is linked to an Excel file so I'm not able to make changes from within Access. So would that prevent the query from changing...

Currently I have: IIF (ISNULL([first_pmt_effective]),"1st Pay N/A",IIF([Age Days]<68,Month(now())+1&"/1 and newer",Month(now())&"/1 and older")) and it works except when it is December, then I get a "13/1 and newer" result. How else can I phrase this to just use the correct months? In Excel...

I need to have several table linked together and know the source of the data. Is there a way to have one of the fields contain the file name from which some of the data is pulled?

Someone told me if I create a worksheet in Excel 2007 and use the Publish feature to Create Document Workspace the Sharepoint that is created can not be shared by mulitple users although the Excel file is. Is that correct? It just seem to me the whole foundation of Sharepoint is multiple users...

I discovered how to pull unique values from a list of names by using: {=IFERROR(INDEX('Daily Fails'!A:A,MATCH(0,COUNTIF($B$1:B2,'Daily Fails'!A:A),0)),"")} but it runs much too slow. Is there another way to pull only unique values from a list of indeterminate length? I'm working with names...

I've created a very complex pivot table which I want to convert to formulas. I have everything completed except for the filters. If there is an option chosen in the filters there's not a problem, but if the user does not choose an option and wants to view all the data for that filter and maybe...

I think this may be an impossible circular reference but I really need a second opionion. My cell has the following formula in it: vlookup(c2,equipdata,7,FALSE) but now I'm told that equipdata will be changing and the original data will be lost. Therefore, the information that the vlookup...

I have a small program that displays a timer which shows how long it took to complete the task. Can I add sound? The timer works great but I can't seem to find a way to have it play a small wav or mp3 when the timer says Well done. $timer.html('Well done, it took ' +...

I have a simple program that allows kids to follow-the-dots. At the end the photo appears and I would like a train whistle to sound. I have the following code which works great for the image to appear: .circle { background: url('start.png'); play-during: url('train.wav')...

I would like to have the mouse trace a very simple picture on the screen. The picture would be a horizontal or vertical line, circle, triangle or square. The user would use the mouse to trace the line and if the user traces the line correctly from beginning to end they are rewarded with a sound...

I have a formula that I copy and paste down the A column: ="Q:"&Sheet1!A30 ="A:"&Sheet1!B30 ="A:"&Sheet1!C30 ="A:"&Sheet1!D30 ="A:"&Sheet1!E30 But when I start the copy process over again the next time I paste the row will have changed to 35 instead of 30. How can I make it change to 31...

I'm trying to create a simple calculation. I have the calculation part working correctly but I want to compare the result and have a message appear based on the result. I've tried several examples such as: if (P.toFixed(0)) == 1 $("#coolingneed").val('1 ton unit'); else if (P.toFixed(0)) >= 2...

I copy data from several sheets to one sheet and use that data to create pivot tables. When I record the macro to create the pivot table I go to the sheet with all the data and use Ctrl+Shift+A to select all the data on the sheet for the pivot table. But, as sheets are added to the Excel file...

I have an Excel file that looks like this: Column A - A part of a waste disposal system used to disburse the waste water into the ground. Column B - Abstract of Title Column C - Absorption Trench Column D - Abstraction Method Column E - Abut Column F - 2 But I need it to look like this...

This Excel formula is throwing me for a loop. I am trying to determine the tax amount for monies received. Yet sometimes the monies received have to have a late fee deducted. After the late fee is deducted I then find the tax amount. That's the problem. If I say =(50.45-20)-(50.45-20)/1.09 the...

I have a multiple choice quiz in excel where the question is in cell A, the correct answer in cell B and three other choices in cells C-E. Is it possible to have a sheet that would display the question and rotate the answers so that the correct answer was not always the first one?

I have this code: Private Sub Worksheet_Change(ByVal Target As Range) ActiveWorkbook.FollowHyperlink "http://maps.google.com/maps?f=d&source=s_d&saddr=650+9th+Ave,+AL+35020&daddr=" _ & Replace(Target.Value, " ", "+") End Sub Which provides directions from the office to the address...

Is it possible to have an address in an excel sheet and have google maps link to the same sheet to provide driving directions and a map on the same sheet?