Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Pamula

    Need most current date

    Thanks. I see that now. It works GREAT! Thank you very much!!
  2. Pamula

    Need most current date

    I am receiving a syntax error in the From clause. Here is the actual SQL Code: SELECT A.* FROM [2010 Medtronic SD] AS A INNER JOIN (SELECT [ITEM #], Max([PO-DATE]) AS LastDate FROM 2010 Medtronic SD GROUP BY [ITEM #]) AS L ON (A.[ITEM #] = L.[ITEM #]) AND ( A.[PO DATE] = L.LastDate) Any...
  3. Pamula

    Need most current date

    Using Access 2002. I have a table that shows each time an item was ordered along with the date it was ordered and the cost. Generically, it looks like this: Item # Date ordered Cost 000455 1/1/2006 45.67 000455 2/15/2006 45.67 000455 10/20/2006 49.00...
  4. Pamula

    Count once in a running total

    I have no idea how it worked, but it did. Thanks Tonz!
  5. Pamula

    Count once in a running total

    Sorry about the confusion. Crystal 9 is the version. I have two tables: POLINE where I get line detail from, and from POLINE I link to PURCHORDER where I get the PO date and Print total. I group the report by buyer and I need a total dollar value for all PO's issued by a specific buyer...
  6. Pamula

    Count once in a running total

    I am quite new to Crystal and found the solution to my 'problem' on this web site. However, I am a little confused. I have a group for PurchOrder. Within that group I have POLINE table information. Because of the way the tables work, I have to pull the PO Total from the PurchOrder table and...

Part and Inventory Search

Back
Top