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 TouchToneTommy 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: *

  • Users: bournes
  • Content: Threads
  • Order by date
  1. bournes

    Data Type Mismatch in Criteria Expression problem

    I've checked the threads and the faqs but haven't been able to get my query to work right. The basic sql is: SELECT DISTINCT T.AcctNum, T.Date, T.Time, T.SiteId, CDbl([Qty]) AS Qty1, tblAccountDiff.EffectiveDate FROM (qryTransactionFieldsForQueriesWithPriceDateAndDiff AS T INNER JOIN tblPrice...
  2. bournes

    Automate Excel2k subtotals from Access2k

    I am exporting to Excel sales information and would like to automate subtotals in the target worksheet. Can anyone advise me how to do this? Thanks, Bear

Part and Inventory Search

Back
Top