Search results for query: *

I have a table that has fields of ZipCode, Network and Factor. The Network names are duplicated, which is fine, and also some have the same ZipCode, but the factors are either 0 or 53. So example: Network 3digZipCode Factor ABC Inc. 995 0 ABC Inc. 995 53...

Expr10: IIf(IsNull([ACH_AccountChange]),0,[ACH_AccountChange]) saying there's an extra ) paren.??? help. thanks.

Hi all. I have a form with a text box with an input mask like this: AAAAAAAAA;;_ this allows 9 characters. but what if the text is only 8 characters? the users are getting the error 'the value you entered is not appropriate for this input mask' At first the text box was to have only 9 char so...

Hi all, I am using MSAccess 03, win xp. I have a report form with this option button that runs this bit of code to open the report: ElseIf [Forms]![Reports Form]![fReportOptions].Value = 9 Then DoCmd.OpenReport "Cancel Report A", acViewPreview I added this bit of code to the On NoData...

Hi all, Using MS Access 2003, win xp... I have a table with a column for Social Security Number roughly 2500 records. Some users put dashes in the SSN number, others have not. I want to remove all dashes and keep the number uniform like this 123456789, not like 123-45-6789. How do I...

Hi All, I have this bit of code in a Forms Before Update Event: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.BatchDate) Then MsgBox "BatchDate Must Not Be Left Blank!" Cancel = True BatchDate.SetFocus End If End Sub Now I want to add a piece of code to this where...

Hi All, I am using Access 2003. I inherited a database with about 25k records. I was asked to add a new field called BatchDate. Today I was asked to make this field a required field. I went into the Design View of the table and set the field to Required = YES. This works fine except it gives a...

I have 3 databases. They all have the same query. Two of the database work no problem with this function: InStr(Nz([Enter Products or Hit OK for All],[dbo_FinanceLog].[product]),[dbo_FinanceLog].[product])>0 When I put this string of code into one of the databases I get an error message 'the...

I have a form PremRec. There are 2 fields, Policy# and CoName. I have this bit of code to auto fill the CoName when the Policy# is selected from the drop down on the form. Private Sub Policy__AfterUpdate() Dim GroupName As String GroupName = [Forms]![PremRec]![Policy#].Column(1)...

I have a simple query as a command button. I just want to be able to click the button and have the query open in Excel 2003 format. Anyone have an easy solution? Thanks in advance!

Using MS Excel 2003 and Access 2003 on Windows XP. I have an Excel file with 2 columns, ClaimNum and QADate. Both columns have data in them. I have an Access table with the same 2 columns, except the QADate is blank in this table. I want to create an Update Query to say...Take the QADate from...

Hi all. I am trying to mail merge from Excel 2003 to Word 2003. I have a Company name field, say ABC Co. They have a list of Employees. I want to send the letter to the company and list the employee names somewhere in the body of the letter. However, I don't know how to make sure the Employees...

I need to return the weekday name, ie Monday, Tuesday, etc in my query based on a date field. I can't figure out the format. Can someone help? I have Format:([DateField],"ww") but that gives me numbers, I need the weekday name. Thanks.

Hi all, Can someone tell me what I am doing wrong with this Case statement? If I comment out the "between" lines the query works fine. when i put them back in I get the error message 'Incorrect syntax near between'. CASE procedure_code when between '27301' and '27599' then 'KNEE INJ'...

Hi all, Can someone tell me what I am doing wrong with this Case statement? If I comment out the "between" lines the query works fine. when i put them back in I get the error message 'Incorrect syntax near between'. CASE procedure_code when between '27301' and '27599' then 'KNEE INJ'...

I have 2 separate Excel Spreadsheets on a server. Each spreadsheet is updated by separate departments. I combined the 2 spreadsheets into one and put it on the server but was told I couldn't use the combined spreadsheet because it wouldn't be updated. Is there a way to link my combined...

Hi. Need some help. I have 46,000 records, one recrod per member. I have a field labeled Plan, which there are about 300 different plans and there can be several members with the same plan. For my purpose I need a query to just pull the first member from each with a different plan. Would I...

Hi. I am trying to get a formula to work: Here's what im trying to do.. if 499.68*100% is greater than 200, than display 200. if not, then display the product of 499.68*100% say that 499.68 = cell A2 anyone??

Hello. I'm trying to figure out how to write IF the cell contains a "P" anywhere in the word, then I want it to show "IN" otherwise "OUT", ie; PV8O - IN P40 - IN CXWP - IN F40 - OUT CXWF - OUT Can someone help? I've been trying for a while now and just can't seem to get it. thanks!

Hello. I have a text box on a form that has 3 fields, Balance, Recovery and EarnedCommision. I am trying to put this formula into the Recovery box but keep getting the "#Error" message: =IIf([Balance]>0,IIf([Balance]-[EarnedCommission]>=0,[EarnedCommission],[Balance]),0) Am I missing something...