Help - Simple Query

[Artemis]

I have a SQL database which I am trying to run some simple queries on in MS Access. The first field contains Compamy Names:

Activ Technology Services Limited
Active Network Solutions Ltd Group
Active Technology Systems
Acute Sales Limited
Wave-form Solutions Limited
Addwell Business Equipment
Cunningham Cash Registers Ltd
Advanced Labelling Systems Limited
Advance Labels & Print Ltd Group
Advanced Laser Systems Ltd Group

If I run a simple query that trys to find "Active *" or "Active %" no results are displayed.

I am sure this is something simple but I cannot work it out. Am I going about this the wrong way?

Any help would be grately appreciated.:banghead:

 

[pr2-eugin]

Artemis, can you show the entire search Query you have used?

 

[Artemis]

SELECT dbo_tbContacts.[Company Name], dbo_tbContacts.[Contact Source]
FROM dbo_tbContacts
WHERE (((dbo_tbContacts.[Company Name])=[Enter Company]));

 

[pr2-eugin]

To use WildCards, you need to use LIKE operator, not EQUALS.. Also you only have to use the word, the wildcard character is embedded in the Query design itself..

SELECT dbo_tbContacts.[Company Name], dbo_tbContacts.[Contact Source]
FROM dbo_tbContacts
WHERE (((dbo_tbContacts.[Company Name]) [COLOR=Red][B]Like[/B][/COLOR] [Enter Company] [COLOR=Red][B]& "*"[/B][/COLOR]));