Access 365 Query

[Badger51]

I am using Access 365 on Windows 10 PC.  My database is in Access 2016 format.

I haven't used Access in some time and am perplexed by my difficulty in successfully designing a query.

I have a list of members of a legislature. One of the fields is office type; the choices are Legislative Office, Constituency Office or Ministry Office.

I have tried multiple options in my Simple Query to obtain a list of Legislative offices.

No matter what I've tried, I get  blank results with a syntax error message.

Among my attempts where "Legislative", "Legislative Office" and "not C"

None have been successful.

Screenshots attached show table format, query design view and syntax error.

Please point me in the right direction.

Thanks in advance

   

[#2 · Accepted solution]

Criteria would be "Legislative Office" or for partial match LIKE '*Legislative*'. Attach a sample db for further clarification. You may also share db via OneDrive and then share a link downloadable file.

[#3]

Is that a Lookup Field? If so, you must filter on the Foreign Key field, not the description field.

[#4]

No, not a looku field

@George_Hepworth 

[#5]

@Harun24HR 

Thanks, that worked.....

Always looking for a shortcut !!

I tried "legislative" but not like "legislative !