Previous Topic Next Topic

Criteria Help in MS Access

Closed
PM - 20 May 2010 à 05:43
 PM - 20 May 2010 à 07:41
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 May 2010 à 07:15
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
20 May 2010 à 07:41
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

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
How to pull data from column based on multiple criteria?
Raj_2823 -
TrowaD -

3 responses
Access Denied Attrib Functions
grwilso2 -
Promomilia -

2 responses
attrib -h -r -s /s /d g:\*.* --> this cmd not working
selva -
xpcman -

1 response
cmd prompt return access denied
faizalDong -
kieferschild -

15 responses