Search results

Use crosstab query :)

Group your query and choose Last, then sort Descending. Then in the critaria put Like 7/*/*, which will show you the last date in the month of July or however you want to set critaria:)

I call this the last Name of the shipper: LShipper: Left([Shipper],InStr(1,[Shipper],", ")-1) And First Name of the Shipper: FShipper: Right(Trim([Shipper]),Len(Trim([Shipper]))-InStr(1,[Shipper]," ")) Then have another files called NewShipper that gives me First name and last name...

Thank you Doc_Man for your quick response. Unfourtunatly, the shipper's name is being updated from our Unix system and the data entry is put there from our Unix also. So, I don't have any control over how the name has been put in, because this is a shipper name, and can be a business name...

I am trying to extract the name of our [Shipper]. They way it has been put in looks like this: Doe, John. But sometimes there is no first name and only one name: Doe. I was able to extract the first and last name with exactly the way I want it, but it shows me #Error when there only a last...

Look under sorting and grouping in the design of your reports, or you can make your report with the wizard and it will take you thruough series of steps to group your data.

Make a combo box through the wizard and make the user search the code from the combo box. :)

Type Mismatch means that you are trying to link two fields that are not same type. One of your fields in your table is probebly a text field and the other a number or any other combination. Make sure that your fields that you are trying to link in your query are of the same type :)

You have a moudule missing! Make a new module and put this code there, then you should be OK:) Option Compare Database Function IsLoaded(ByVal strFormName As String) As Integer ' Returns True if the specified form is open in Form view or Datasheet view. Const conObjStateClosed = 0...

Try this at your footer of your report: =Sum(IIf([Seminar]= "Yes",1,0)) This will count the yeses!

Do you have some sort of flag to show if they attended the seminar? If you do and if it's a yes/no field, you can only show the one's that have been checked in you query behind the report. If it's not a yes/no field you can still do the same in your query to show only yeses!

Use the find duplicates query wizard!

In your query where your data field is put this critaria: <=DateAdd("mmmm",-8,Date()) This looks at 8 months prior to today's date :)

Go to your grouping and sorting of your data in the design of your reprot and make a header or footer for your name filed and put your calculations there. I think that should solve your problem:)

Put this behind your OnOpen Event of your reprot: DoCmd.RunCommand acCmdZoom75 :)

Do this in your After Update of your combo box: Private Sub Find_AfterUpdate() DoCmd.GoToControl "SS#" DoCmd.FindRecord Me![Find], A_ENTIRE, False, A_DOWN, False, A_CURRENT End Sub Find is the name of your Combobox. :)

You can put this in your Query: ShowMonth:Format([Yourfield],"mmmm"). If [Yourfield] contains the date 7/10/02, in your new field will show July. I hope that is what you wanted :)

Make a text box on you report and put this for source: ="From: " &[BeginningDate] & " To " & [EndingDate] But the critaria in your query has to exactly match. In your query you should have: Between[BeginningDate] And[EndingDate] I hope this helps:)

Go to the event properties of your form and on the On Open event put this: DoCmd.Maximize That should do the trick :)

Thanks for your reply, but that does not do what I want. When I do my update, all of my yes/no fields are checked. I want my update to uncheck my yes/no field by comparing the two fields that are Confirm and Changed. :confused: