Count part of the string value reappearing in many records of a field in simple query

[learner1]

in a select query field 'FullName' data comprises of FirstName, MiddleName,LastName and PetName. Now part of the full name is reappearing as firstName or MiddleName or LastName in different sequence in more than one record. I want to count one such specific part of the FullName in all the records of this field.

[jimatqsi]

learner1,
Welcome to Bytes. We'd all like to help you but we cannot know anything about your code that you don't tell us or show us. Help us help you by showing us what you have done.

In the query editor go into SQL view mode. Copy what you find there and paste it here. Be sure to click the [Code/] button and paste your code between the tags.

Jim

[learner1]

Thanks Jim,

Code for joining the different fields is as given below,however now I am interested in as to how any part in this combined field can be counted .

SELECT Table1.ID, Table1.FirstName, Table1.MiddleName, Table1.LastName, Table1.PetName, " " & [FirstName] & " " & [MiddleName] & " " & [PetName] AS FullName
FROM Table1;
 

[jimatqsi]

A new question is a new question in a new thread. Please start a new thread if you are no longer seeking help for the same problem. Please take the time to make a complete and clear request. Brevity is not helpful, we need to understand the problem fully.


Jim

[NeoPa]

As each part is held in separate fields anyway, the counting would be done for whichever field you're interested in. The function for counting in SQL is Count(). You should read up what this does and how to use it from the help system or on the web.

It's fairly basic stuff, but your question has so little detail that helping you further at this stage is not possible without further back and forth which should not be necessary - and isn't when you expend a little more effort asking the question clearly in the first place.

I know this sounds like criticism, and it is a little, but in reality we do understand that getting this right early on is very rare. We just think it's a good idea to make you aware of this because going forward with new questions you will benefit greatly from the extra effort up front preparing a question we can answer. Obviously it helps us too, but at the end of the day we have loads of other questions we can look at if yours is unworkable.