Search results

It says "syntax error in FROM clause" when I try to close it.

Should I put it at the end?

It didn't work. I might have typed it into the wrong place. I put TOP 10 TBL-Inventory.Cost as the field. I also tried putting into Table but that didn't work either

I don't really understand what you are trying to say. This is what I have so far: Field: Cost Table: TBL-Inventory Sort: Show: Checked Criteria: Or: What exactly would I type in?

How can I make a querie that finds the ten most expensive items in my table?:confused:

What is a combo box?

How can I put a button on my form that makes a prompt from a qwery pop up?

It worked. Thanks for your help. Do you know how I can get the results I am looking for if for example I type in Celll instead of Cell.

I have a database for my book collection and I want to make a qwery that searches for a book by it's title. I got it to where it finds the book but I have to type the title into the prompt exactly as I have it in my table. Is there any way that I can make the qwery show results even if I don't...

I figured it out.

I can't send you a copy, but do you have any idea of what might be wrong with the database?

It is an mdb file.

I checked the properties and it is not set to read-only, it is set to archive.:confused:

I had a database sent to me. I am supposed to make some changes to a report in this database but access will not let me edit it. I can't even view the toolbox or right click on anything. I can open the report in design view and I can edit existing text boxes but I can't add new text boxes. I...