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

Criteria Help in MS Access
Ms access download - Download - Databases
How to access google usa - Guide
Attrib access denied ✓ - Hard Drive & SSD Forum
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Access and downloading - Guide

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.

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.

Similar discussions

My facebook account is unable to access i need my account

How to gain access to my hacked facebook account

Can’t access settings for a few days lock out

HACKED FACEBOOK ACCOUNT

Hello, I have a problems on accessing to my Facebook account

Similar discussions

Subscribe To Our Newsletter!