Search results

Hi All, i have a Query that references 2 tables, a customers table and a purchase table. i have a query that looks up customers who have not purchased within the last 7 months. i would like to make a seperate form / query / macro / script or whatever that will prompt the user to enter the...

Hi All, i have a database that i am trying to clear out old customers that have't bought something in the last 6 months. i have a table with the customer details in and another table with the purchases in. i have been using the folowing criteria: Not Between Date() And #01/05/2007# but i...

mornin all, i have a databse with 2 tables ticketsales and T_semester semester contains 3 columns: ID (primary Key) Semester (description shown in combo drop down box) Start Date end date ticketsales is a customer database of sales along with other fields it also has the semester (lookup...

Hi All, i have a slight problem i have a access table which has the following fields: Name Photocard ID Purchase Date Photo Cashsaver Zone Valid From Period of Validation Expiry the period of validation field has a lookup to another table with the folwing values: 28 Days, 3 Months, 6 Months...