Search results

I ran Access's compact and repair tool and got the size down. Here it is. You can see the queries are both returning 1308 records, should be more like 3700.

I would attach my database but it's 8MB and the forum won't allow it. I can't figure out why it's so much bigger than yours. It only has the one table just like yours.

I can and I have, but would like to know what's wrong with my database so I can avoid it in the future.

2013 (adding words to satisfy the forum :) )

Your SQL works when I put it into your database, but still gets the same results in mine???

I don't see a difference, even the query is the same.

Connor, I need it to return records if any of the L fields start with D, not just L1. My problem is that with the OR statement I wrote, it still seems to be checking only L1.

Not sure what the correct protocol for sharing tables on here is, but here it is in Excel. Thank you.

Thanks for replying Murph. The QBE grid is more confusing to me than just writing code. I cannot, however, figure out what the problem is here. And it's working for you? I don't know what to do...

Hello, I need to write a query that shows all records if any 'L' field starts with D. I have written this, but it's only pulling records if L1 starts with D. SELECT Item, Description, L1, L2, L3, L4, L5, L6, L7, L8, L9, L10, L11, L12 FROM Table5 WHERE ((L1 LIKE 'D*') OR (L2 LIKE 'D*') OR (L3...