Query Numbers

[jsonne]

I need to query from a table numbers that go like:

81307-2050 to 813007-8010
81308-1000 to 81308-2090

so if I only want information for anything in the 81308 rows - how do I set the criteria?

I tried "81308*" but no luck
thanks for the help

 

[Joe4]

Your criteria should look like:

Like "81308*"

Notice that you need the word "Like" in there.

 

[jsonne]

Tried the Like "81408*" but it returned nothing. The table's field name is Docket ID, Data Type-Number with Combo Box and Row Source set as
SELECT [Docket].[ID], [Docket].[Docket] FROM Docket;

My main objective was just to isolate all the 81408's.

Thanks for any further help.

 

[Joe4]

Where's the criteria (WHERE statement) in your SQL statement? It should look like:

SELECT Docket.ID, Docket.Docket
FROM Docket
WHERE (((Docket.ID) Like "81308*"));

I created a database like you described, set up some examples, and tested the above code and confirmed that it does indeed work.