Recent content by Zonie32

Sorry. Things got changed around, field names changed, fields were added....

The LOB field actually has the 0 and 53's in it, not Factor field like I previously had. Sorry about that. SELECT MASTER.Network, MASTER.[Zip], Max(MASTER.LOB) AS theLOB, MASTER.Date, MASTER.St, MASTER.PPOID, MASTER.Factor FROM MASTER GROUP BY MASTER.Network, MASTER.[Zip], MASTER.LOB...

They all appear to be the same, no extra spaces or anything. There are other columns as well...maybe that is the difference. There is a Date field, an LOB field and a State field. The dates can be different on the rows too.

PHV, I ran this and it didn't quite give me the results I need. Here is what I get: What I need from this is if the Network and Zip are the same but the factors are 0 and 53, I only need the 53. But I do need the other networks as well that may only have 0's. Network Zip...

Thank you for the quick response! Was very helpful. Now, another question...going another route here...how would I write the query to say... Give me ALL the rows with zeros but if there is the same zipcode and network that has a ZERO on one line and a 53 on the other line, I just need the 53...

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'm not sure of either. I don't know Access very well to understand how to look for this sort of thing. Any suggestions/hints? thanks!

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

The policy# is not a key field. I inherited this db from someone who created it years ago. I was asked if I could make this 'little fix' to this form to auto fill the policy number when the user selects the CoName from the drop down. This database is quite complex. Whoever did this spent a lot...