Recent content by clippertm

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...

Thank you all for your replies, you are very helpful. I am pausing this JOIN work as I read The Evils of Lookup Fields in Tables and I need to redesign the database.

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 David, I can't figure out where to write this Replace() function. Is it after or before SELECT, or FROM? Many thanks,

Hi David, I looked at the help and several websites but it was a bit difficult for me to grasp the logic. Thank you for explaning me.

Hi David, Sorry, I am a beginner, I don't understand the the logic with the Replace() function. I only want to delete one space if there is no middle name. Should it not involve a "IF" function? Like: IF no middle name THEN delete space? Many thanks,

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...