Recent content by SpindleMania

Hi Neileg, the purchases table is not a direct link to the customers table as all that is recirded is the customers number, which is manually entered. it is the query that links the two tables as it has to reference the customers last purchase date to find which customers havent purchased...

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

wow, thanks guys that works great, thanks for the quick response, thats cut down the records by about 300 due to people have quite a few purchases thanks again

thanks i will give that a try

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

my fault sorry, i renamed the combo box to semester, i think that is where i went wrong. i remade with a new combo box and it now works fine thanks for all your help

for some reason it is not allowing me to add the ,2 please see attached for a screen shot of the error, thanks for your help i appreciate it

date range thanks statsman, that works a charm but the years are wrong in the table i have start date 24/09/2007 end date 14/12/2007 but in the form it puts: start date 31/12/1899 end date 31/12/1899 any ideas? before i forget i can't put the column (#) reference in because it says...

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 Bob, thanks, i'm grateful for your code but i am unsure into which box to insert the code, sorry to be a pain

Thanks i will look into this

Thanks for your quick reply but i am new to this and unsure what you mean?

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