Search results

Thank you, that is what I was after. It works like a charm. This is a great forum and brilliant that there are contributors like yourself willing to help people like myself solve access problems. I am new to the forum, but really keen to learn more about access so that I can hopefully also...

Hi Bastanu Thank you for creating the referrals db. That is almost there, I had to tweak it a little bit to meet some of the criteria I am after. In the qryToBeRewarded Query, records should only show if they pass the following criteria 1. Only referrals from customers are allowed, in other...

Hi Minty Thank you, that sounds vaguely familiar from what I had seen, I thought it did includ a count somewhere. Sorry, I am only beginning to learn how to get around access, so forghive me if i don't fully understand. How would I achieve this, I don't suppose you would mind showing an example...

Hi Ranman Thank you for the information, I see that it will make the database look tidier and that all the data would be in the customer table. So I still need to be able to only show the unique referrals and hide any duplicate referrals that were submitted after the original one. I'm sure I...

Hi, I wonder if somebody could please help with a query I am trying to figure out. Basically I have 2 tables, one named “Customer” and the other named “Cust_Refer” The (Customer) table is a list of customers who have purchased a product containing fields “EntryID” “Customer_Name” and...