Search results

Thanks pbaldy. That did the trick.

I have a query set up to sum 2 fields to a 3rd field, for example, I have field1, field2, and field3. Fields 1 and 2 are data from a table. In Field3 I have an expression: Field3: [Field1] + [Field2] This works fine except when either Field1 and/or Field2 contain no data, then the sum does not...

Keith; thanks to your help I got it figured out. Thanks again. Dennis

Adam: You were right, I was really making a lot more out of it than it needed to be. It seems to be ok with one exception. What I need to have is the name of the town or village listed next to the zip code: # zip code Location 3 12345 Smallville 7 12346 Jefftown Creek...

Thanks Adam: I'll see if I can figure that out and give it a try.

Keith: I've attached an example dp. I have a query which pulls a lot of other data from this table, and I want to pull information on zip code like this: Number of Clients Served by Zip Code: # zip code 3 12345 7 12346 etc. Assume I...

Hello: I'm trying to generate a form which lists, among other information, the number of clients that have called in over a certain time period, by their zip code. In other words, each zip code in the county would have the number of call ins listed next to it. I developed a separate query for...

The Access Find and Replace function defaults to matching the whole field. Is there a way to change the default to "Any part of the Field"? Thanks.

Thanks Bob. That did the trick. As always, your responses are quick and right on the money.

No, I only have the one group, sorted on Client_Name. It sorts by the first character correctly, the "a's" , "b's", etc. are sorted, but the names within each group are not. Is there a way to do another sort within each group?

Hello: I have a report that lists client's names alphabetically. I have it grouped by first letter of their last name. In other words the "a's" are grouped together, then the "b's", etc. The report is based on a query that has the names sorted alphabetically ascending. What I need is to have the...

How do I get a form to open with the cursor located in a specific field? For example, if I have a field named "Customer_Name" which is in the middle of the form, I would like to have the cursor located there when I open the form. Thanks

Thanks linq. Appreciate the effort.

Any other suggestions? Thanks.

I have a report with a Text Box based on a memo field in a form. Data is not always entered into this field. If data is entered I need it to show on the report. If not data is entered, I would like to have the field not show on the report, including the label. Is there a way to do this? Thanks,

The problem I'm having is that I need to insert that code on the onclose of the access "find and replace" box and I don't know how to get to the properties of that box. See the attached image. When the user closes the "Find and Replace" box, I need to have that warning message popup. Thanks for...

I have a form that my users enter information from client call-ins. They frequently use the "Find and Replace" function to find records of previous calls, then they copy that record to a new record and simply change the necessary information (new date, etc.). Unfortunately they frequently forget...

Thanks neileg: I kind of knew I had to do something like that but wasn't exactly sure of the steps. Your advice was right on the money. depawl

I have a Table that is used to collect data from client’s phone calls. There is a field for the Client’s name and another for the date the client called (There are a whole lot more fields, but for simplicities sake let’s focus on these two). I have sorted the table on date and indexed the date...

Thanks Bob, I knew that Access had that capability but couldn't remember where to find it.