Select first five letters

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

I have an invoice table and i only want to have my query select only the
invoices that begin with south. How do i design this?
 
Set the criteria for the invoices field in your query design to

Like "South*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
Query Help Please 3
Sum & Group By 1
Update query with autonumber field 4
GROUP BY question 1
Select Query with an IIf 2
Append Invoice 22
Searching for Missing Data 1

Back
Top