Recent content by Clearsky24

Is this helpful? I guess what I need to find out, is why that column, I want to show, the total amount of money that customer has spent with us, so a total of the unitprice column should do it.... but.... instead it tells me the total of the unitprice column times the number of records they have...

Yesterday I got help when I was building a query to show the last order by a customer. That way I could quickly see an email and phone number of customers who haven't used us in the last four months. I couldn't figure out how to show only the last order date.... but we figured it out by doing...

ohhh I forgot to hit view ...sorry I think we got it I told you it was easy, thank you so much

On the grid I can choose: Sort Show critieria or and sort only gives me ascending and descending for instance we have 625 customers...... so I should have 625 results each customer and the date of their last order..... but instead I am getting each customer listed and every order they have...

Howdy all, any help appreciated. Ok, here is what I want to do, I to make a querry that sorts all the customers and shows when there last order was. I have an customer table with a subform that is the orders table (I think that is irrelevant). I think the important info is this..... There are...

You RULE!!!!!!!!!!!!!!!! I don't know what makes people be so nice that come to this site maybe it's for their charma, maybe you were a bad person in a previous life and are trying to make up for it, Thank you so much!!!! It works like a charm.

so far so good That is exactly what I have, I love baby steps

Here is where I stand, I know so little that I don't know if I am posting to the right category, I know this is possible, and probably relatively easy, where do I find info on this. I have 2 tables in an access data base, Orders and Customers The Orders table contains a yes/no check box in the...