Search results

I see this question is asked a number of time but I tried to use the code that is suggested but it doesn't work. Can someone please give me advise on the proper code to prevent duplicate records in my form? I'm using: Private Sub Ctl_Lname_BeforeUpdate(Cancel As Integer) Dim dupCount As...

Can you tell me how to run a report to show a Client if one or of the following fields are blank or unchecked(Yes/NO? Fields Client Assessment Date(Null) Placement Fee Paid(Check Box)(No) TJ Completed(Check Box)(No) So basically, if one of the above fields are null or unchecked, please show...

Please help, I'm trying two add a field in a report that totals two Summed fields in which I already calculated. I thought this would be simple: :banghead: Any clues would be helpful. Ex. =Sum([Field1]) =Sum([Field2]) Total: =Sum([Field1]) + =Sum([Field2]) Thanks Chris

In my report I added a text box in the header of the report to show the payment method I selected from the parameter query. So it shows: check, cash, PayPal, etc. I have other parameters in other fields I select for the report. Sometimes, when I run the query I leave the "pymt method" field...

Hello, I working with different business groups who have vendors assigned to them. I have table of vendor names for each business group. I'm getting data from different sources with vendor names that are unlike table. example: ABC company, ABC. Even through these are different they are they...