Search results for query: *

Thanks for the input. Both solutions worked.

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

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

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

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

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

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

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

Got things working - thanks all for the help

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?

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

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

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

That worked - thanks for the help

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

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

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