JustAnswer > Computer
Ask A Question|Register|Login|Help
JustAnswer

Computer

Ask a Computer Question, Get an Answer ASAP!

Have your own Computer question?

28 Tech Support Specialists are Online Now
characters left:
Not a Computer Question?
Bookmark and Share

Question

I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?

Submitted: 627 days and 7 hours ago.
Category: Computer
Value: $9
Status: AWAITING CUSTOMER ACTION
+
Read More

Optional Information

Optional Information:
Browser: IE

Answer

Hi,

You can use this query to get the TradeID and the lowest price from the table.

SELECT TradeId,MIN(TradeValue) from Trade Group By TradeId;

Trade - Table Name

 

Expert: ColdBreeze
Pos. Feedback: n/a
Accepts: 
Answered: 3/6/2008

Computer Software Engineer

Master In Computer Applications

+
Read More

Related Computer Questions

  • i want my old bebo profile back i tried loggin in and was to...
  • My problem that I posted half an hour ago was not completely
  • Just posed my question - reperred to Carl Poersch. Answer
  • error states: Stop: c0000218(Regitry file failure) The regi...
  • I got a new HP with the Windows Vista operating system and
  • In order to transfer from one Outlook profile to another, I
  • New Z2300 Logitech Speakers The left channel is much qui...
  • I have a Vostro 200. The faxing facility does not work, thou...



Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
Question List | Become an Expert | Terms of Service | Security & Privacy | About Us
© 2003-2009 JustAnswer Corp.