Search results

personally i would create a small pop up form that you can call by double clicking the customer id and using that action as the query criteria - example [Forms]![F_Sales]![Cust_id] then create a macro calling the sub form.

Assuming you have a customer 'id' field and a sales table you can create a query that simply groups the customer id and then a count of products.

You see, this is why i use this wonderful forum. So many brains so willing to help the mentally challenged. Thank you Brian, your help as always is appreciated.

Have attached the fruits of our labour in case anybody else finds useful. The Margin calc was my own work but thanks should be made to Plog for the markup calc. Plog - my margin calc is pretty ugly, maybe you can improve upon?

Plog - Apologies you are correct, i was just being lazy. Had i actually plugged the equation i woudl have realised sooner. I bow to the bigger brain - Thank you.:)

You appear to have used the cost price in the calc??? You cannot use the cost price in the calculation it HAS to be the product of the calculation. You can only use the selling price of 10.00 and the markup price of 25% to derive the correct answer (8.00) Believe me i've tried and always come up...

Hi all, this has been buggin me all day and i still cannot solve it - Anyone up for a challeng? Your challenge is this - Calculate the Cost price of an item by entering the selling price and a markup percentage. Seem simple? god i wish it was.... If you started with a COST price of 8.00 and add...

A guy goes to the supermarket and notices an attractive woman waving at him. She says hello. He's rather taken aback because he can't place where he knows her from. So he says, 'Do you know me? To which she replies, 'I think you're the father of one of my kids.' Now his mind travels back to...

A nun gets into a cab and the cab driver won't stop staring at her. She asks him why is he staring and he replies, "I have a question to ask you but I don't want to offend you." She answers, "My dear son, you cannot offend me. When you're as old as I am and have been a nun as long as I have, you...

One fine sunny morning, a priest took a walk in the local forest. He had been walking by the small stream when he noticed a sad, sad looking frog sitting on a toadstool. "What's wrong with you?" said the priest. "Well," said the frog, "the reason I am so sad on this fine day is because I...

Another Golfing term prevelant in these here parts - A Sally Gunnell - Ugly but a good runner !

Why females should avoid a girls night out after they are married.... The other night I was invited out for a night with the girls. I told my husband that I would be home by midnight, I promise! Well, the hours passed and the margaritas went down way too easily. Around 3 a.m., a bit loaded...

Figured it about time we had some blonde jokes !! Not sure if any of these have beeen posted before but here goes - Q. How do you make a blondes eyes light up ? A. Shine a torch in her ear ! Q. How do you drown a blonde ? A. Glue a diamond to the bottom of a swimming pool !

We've all had trouble with our animals, but I don't think anyone can top this one: Calling in sick to work makes me uncomfortable. No matter how legitimate my excuse, I always get the feeling that my boss thinks I'm lying. On one recent occasion, I had a valid reason but lied anyway, because...

Check out this article - http://www.mirror.co.uk/news/topstories/2008/05/27/road-tax-increase-will-hit-ordinary-families-89520-20430957/

NO SPEAKAH DE ENGLISH A bus stops and 2 Italian men get on. They sit down and engage in an animated conversation. The lady sitting next to them ignores them at first, but her attention is galvanized when she hears one of them say the following: 'Emma come first. Den I come. Den two asses...

yes he was Dan-Cat, and i agree totally that gas guzzlers should pay more. I also agree with what Scott said about "this money grabbing Government" as it is perhaps the only reply i have read so far that reiterates my original sentiment. Perhaps i was a little unclear in my earlier posts - i...

I agree, well said Scott !

An 86-year-old man walks into a crowded doctors' waiting room and approaches the desk. The receptionist says, 'Good morning, sir. Can you please tell me what the problem is and why you're here to see the doctor today?' 'There's something wrong with my dick,' he replies. The embarrassed...

For a great quaffing wine try "Jacobs Creak Grenash Shiraz" you wont get a much better ( in my uneducated opinion )