Search results for query: *

Let me try to explain better. The first problem I am having is trying to merge the FirstName and LastName (two separate columns) so I have no duplicates. In doing so, I want it to add up all the BeginningMiles and EndingMiles and then subtract the total EndingMiles from the total BeginningMiles...

I am trying to figure out what I need to merge all of the multiple values on the same line of FirstName and LastName into one FirstName and LastName column for every name and in doing so add all the BeginningMiles and EndingMiles and have a calculation subtracting EndingMiles from...

SELECT Addresses.Name, Addresses.Address, Addresses.CityStateZip, Addresses.Phone, Addresses.DemoPerson, Addresses.DemoDate, Addresses.Purchased, Addresses.Notes FROM Addresses WHERE (((Addresses.Name)="*" & [Enter Name] & "*"));

You would have to go in and create a macro and select close and select the forms to close.

didn't work. showed up as blank.

I now have it set to where i have only one name field, and have the query searching for that name.I tried 20 different ways of typing it in the critera to have, for example: john farmer in the field, entering farmer in the box and it include that record. If i only type the last name, that's all...

I need to set up a command button so when they put a first and last name into a text box, it separates them so the names can be looked up in fields, and then pull up the cooresponding information in a new window of the same form.

I need to be able to enter a date and have the cooresponding information come up into the reports so i can print it. Any ideas?