Search results for query: *

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

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

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

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

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