Previous Topic Next Topic

Criteria Help in MS Access

Closed
PM - May 20, 2010 at 05:43 AM
 PM - May 20, 2010 at 07:41 AM
Hello,

I need to know how to write some criteria in MS Access in order to search for the word "FLAT" in a set of data and group this data together instead of showing each indiviual entry that contains the word "FLAT"

Example:

Criteria needs to find data like: "FLAT 1" or "23 FLAT" or "building 1 FLAT 10"

Then i need it to show the count as X number entrys that contain the word "FLAT" instead of 1 entry contains FLAT 1 and 1 entry contains 23 FLAT...etc

Hope someone can help

Thanks in advance




Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 20, 2010 at 07:15 AM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , etc and post back here the link to allow better understanding of how it is now and how you foresee.
0
PM
May 20, 2010 at 07:41 AM
Hi Rizvisa1,

I have found some code that does what i want however i need to incorprate a "like" function in it.


FLAT: Sum(IIf([Table]![Address 1]="FLAT",1,0))


This code finds any exact match. I need put in this line of code: =like "*FLAT*" as you would normally do on criteria.
0

Similar discussions

My facebook account is unable to access i need my account
Arbinlamxane -
karenren08 -

7 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
How to gain access to my hacked facebook account
ccantrell03 -
Hamza -

9 responses
HACKED FACEBOOK ACCOUNT
Sebolelo50 -
Gnanmani -

2 responses
Hello, I have a problems on accessing to my Facebook account
Gcina -
HelpiOS -

1 response