Search results

Hi! I would like to make a query that searches for keywords instead of an exact match. Let's say that I have a record that has "mountain giant" as one of the fields. I want the query to pick this record out whether I put "Mountain", "Giant" or both, or only the some of the letters Thanks alot

Hi! I have a VERY simple problem, but I cannot solve it. I was struggling since last night! I have a table which contains items and their quantities in stock. Now, I have a query that contains all the items that are more than one in stock. Now, I want to create a report. When the report has...

Ok, i have a query and a report that are linked to each other. On the report, it displays what has been looked for. For example, if i typed in 1.00 in the popup query box, it shows 1.00 when the report is opened. I am using the control source, to actually create a query for the report itself...

I am using this to make a quesry: Criteria: [Specify the height] When the popup question comes up, how to I enter this: Less than or equal to 1.5 And how do i enter this (another query): More than or equal to 0.5 Thanx guys

I have a query already made. Now using the [criteria] i can make a popup box appear asking for the keyword. The problem is that is the keyword is misspelt, then nothing appears. Is there a way of putting a dropdown box so that you can choose the query. No forms are involved in this

I have a question to do with both tables and forms in access since they are connected in some way. The thing is this: I am creating a book list. I want the following fields: -Number (Autonumber) -Name (Text) -Type (text) -Do i have it (yes/no) -Rating (Number) I have two questions. 1.How to i...