Search results

Hello Everybody, I have attached a sample database. Basically I am trying to make the form combo box select only one field and hide all the others when the query is run, and the text box filter the results of the records of the selected fields: return all records equal or greater than the...

Hello, Let's say there is one simple table, table1 like the below, that stores the type of fruit and their price: type ; price apple ; 10 orange ; 5 pear ; 15 Then there is another table, table2, that stores simple transactions (this table looks into table1 to get what type of fruit it is...

Hi Everyone, I am learning how to use access 2007 and am making a small book database for this purpose. In my table "books" there is a lookup for the "author" field, which import the data from another table (the "authors" table). This lookup displays the value from 3 different fields: last...