Search:

I have a string of text separated by a semi-colon, maybe 50 separate items.

I want each item to haveits own separate row.

How might this be done?

I found this macro:
Sub MyReplace2()...

I want to send a message to a large group of people at work but would rather not take any responses. Is there a way to do this in Outlook?

I'm gonna try that. Thanks!!

The field I am trying to summarized is the field "altered_consciousness" in table "injury_information_tbl". The field "altered"consciousness" is a lookup field of type Long Integer. The field looks...

Problem: I have a lookup field that holds numbers (options are 0 or 1). In a query, I would like to use the SUM function to add the values. For example, if I have entered two 1's and three 0's, I...

Thanks a lot for your response and that does make it so all records show. But it does lead to another issue, I need to have the report ordered by the last name of the registrant.

So, I want all...

Thanks for sticking with me on this. I have stripped down the DB, including just those records that are not showing. Again thanks, Joe

Yes, the report is grouped by last name. The records show registrants for a dinner and their guest(s). So, one registrant can have more than one guest.

The Hide Duplicates is set to No.

I...

Hello, I have a report that draws from a query. However, the report is not showing all the records listed in the query. If there are records that have the same last name the report is skipping one of...

Thanks, that will do the trick

What I really want is to display all the fields for the record. But I just want to see the records where the EncounterNumber is distinct. Is that possible? Thanks

I know I should know this but I am drawing a big blank.

I want to create a query that pulls a number of fields from a table. But I want a certain field (the EncounterNumber) to be distinct.
...

Thanks, your tool solved the problem. It was my mistake but this was for an Access 2000 issue. Sorry for misleading everyone. Take care

Hello, I built a simple database for a friends dog boutique so she could keep track of her customers.

She told me that when she goes to add a new contact that she receives a message that the...

Thanks, this did the trick.

Hello,
I have a table that records when a user logs into a message board. I have fields that record the userID and the time of their login.

I want to write a query that shows all the distinct...

Thanks Hans, I appreciate you looking at this. I have requested a document that provides more information on this process and will post it when I have it.

This report is completed as a stored procedure on the department's SQL Server. The setup is that there will be a local desktop version that uses Access. The data is then sent to the SQL Server. Is it...

The record being evaluated has to do with surgical data. Each record has 22 fields that are evaluated through a fairly complex algorithm to determine the category in which they belong.

The...

I need to build a query that takes a single record and evaluates it for about 10 different criteria before assigning it a specific category. After it is assigned to a category then I need to do the...

Hi,

Every now and then I design a query on my PC that has a screen resolution of 1600x1280. When a user with a lower screen resolution tries to view that query they often cannot see the grid...

Hello,

I am using Access XP as back end for a Web-based calendar application. I want to be able to enter class information in tblClasses and enter a maximum number of students who can attend...

Thanks, this works and helps with one issue.

Now another issue, how would I write the expression if I wanted to set the month myself rather than ask the user for the criteria.

For instance my...

Hello, I want to sum the number participants in classes we offer for just one month. I can write the query so that all months show but just need one particular month to show.

So I want to write...

Thanks that did the trick!