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 derfloh 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. k9handler

    Getting too many records

    Thanks for the input. Both solutions worked.
  2. k9handler

    Getting too many records

    Thanks to both of you for the ideas. I'm trying dhookom's first. My first query is (with some unnecessary fields removed): SELECT ItemMaster.ItemID, Max(PurchasesInvoice.TranDate) AS MaxOfTranDate FROM ItemMaster INNER JOIN (PurchasesInvoice INNER JOIN PurchasesInvoiceDetail ON...
  3. k9handler

    Getting too many records

    The above were just some items selected from a "test file". The code is: SELECT ItemMaster.ItemID, ItemMaster.ItemDescription, PurchasesInvoice.TranDate, PurchasesInvoice.Reference, PurchasesInvoiceDetail.Quantity, PurchasesInvoiceDetail.Cost FROM ItemMaster INNER JOIN (PurchasesInvoice INNER...
  4. k9handler

    Getting too many records

    Here are some records. Item ID[tab][tab][tab]Item Description[tab][tab]TranDate[tab][tab]Reference[tab][tab]Quantity[tab][tab]Cost FBPC 1X.5[tab][tab][tab]FBG PC 1 X 1/2[tab][tab] 12/31/2011[tab][tab]Beg Bal[tab][tab]2544[tab][tab]0.79 FBPC 1X1[tab][tab][tab]FBG PC 1 X...
  5. k9handler

    Getting too many records

    Thanks for the idea PHV, but it did not work either. I only have 751 unique items in the master table, so this desired query should only return a max of 751 records. Each item has at least one date; (1) the date of the beginning qty or (2) the date of a subsequent purchase. I get 719 records...
  6. k9handler

    Getting too many records

    I have query to find the last transaction for the purchase of an item. The date is stored in a purchases header table and the item and the date are stored in a detail table. (This allowed the date to not have to be re-keyed on each item.) The query using MAX on the date field returns the last...
  7. k9handler

    Displaying data on a subform

    That worked great! It not only solved the current situation, but opened up other possibilities to the usage of combo boxes. Many thanks!
  8. k9handler

    Displaying data on a subform

    I have a transaction form, [frmJobTrans], that contains a subform, [sfrmJobTransDetail], of detail items in the transaction. The main form contains transaction dates and a job number to which the transactions are assigned. The subform contains an ItemID, quantity, cost and a calculated value...
  9. k9handler

    Running a report from a form

    Got things working - thanks all for the help
  10. k9handler

    Running a report from a form

    The form not being open looks like the problem. I opened the form, selected my reference and then ran the report. Worked fine. So, the question is - How do I open the form "FindReferences" before I click on the report?
  11. k9handler

    Running a report from a form

    This is the SQL. The query works when I request the report. But uses the standard parameter query dialog box. SELECT JobMaster.JobID, JobMaster.JobDesc, JobTrans.TranDate, JobTrans.Reference, JobTrans.TranType, JobTransDetail.ItemID, JobTransDetail.Quantity, JobTransDetail.Cost...
  12. k9handler

    Running a report from a form

    Thanks for the information. The suggestion is what I had already used in my query. I still get the same "standard MS Access" parameter box instead of my form. It's almost as if Access does not know the form is out there. Any ideas? I'm not even sure what additional information about my database...
  13. k9handler

    Running a report from a form

    I've created a form [JobTrans] with a subform [JobTransDetail] to record transactions. The linked field is [Reference]. I'm trying to add a button that runs a report based on the current record on the form including items from subform. I designed a report "JobTrans-Ref" based on a query with a...
  14. k9handler

    Calculating an average cost to update master file

    That worked - thanks for the help
  15. k9handler

    Calculating an average cost to update master file

    I'm new at designing access databases and need some help with a query. I'm using Access 2010 but saving database as Access 2007 format due to some end user restrictions. I've created an inventory database and need to run a query to calculate the average cost on an inventory item and then update...
  16. k9handler

    Select Case syntax

    Thanks - that solved my problem. This newbie appreciates it!
  17. k9handler

    Select Case syntax

    I'm a newbie in Crystal. Currently using Crystal XI. I'm needing to compare invoice numbers and based on the invoice range, assign a "Company Name" whcih is to be used to group a report. My code is Select {ART_CURRENT__TRANSACTION.Invoice} Case {ART_CURRENT__TRANSACTION.Invoice} in "100000" to...

Part and Inventory Search

Back
Top