SQL code error! (1 Viewer)

[smelly]

Running out of time and getting desperate. Please forgive me for posting in tables forum also.

I am trying to do a parameter query and I am getting this SQL error when I run the report off the query. The query works by itself.

Here is the error...

The specified field '[LAB ID]' could refer to more than one table listed in the FROM clause of your SQL statement. (Error 3079)

And here is my SQL code...

SELECT Table1a.*, Table1a.[LAB ID]
FROM Table1a
WHERE (((Table1a.[LAB ID]) Between [ENTER BEGINNING LAB ID] And [ENTER ENDING BBC ID]));

I don't see the problem here. Do you?
Thanks!!!!!!!!

 

[simongallop]

You are selecting LAB ID twice (once with the wildcard *)