Search results for query: *

Wow Thanks dhookom. That works like a charm. I'm glad it is only for a report, this query really bogs my machine down.

Ok, Sorry about the untimely reply. I have two tables tblTrip and tblPickups TblTrip contains TripID, StartDate, EndDate, StartOdometer, EndOdometer,... tblPickups Contains PickupID,TripID(forgin key), Odometer,CustomerID, InvoiceID I want to show the miles between each pickup.

I have a report that displays trip summary information based on a user input date range. In the report detail I display information for each stop on the trip. At each stop on the trip I have an odometer reading. There can be several trips on one report. I want to display the number of miles...

I can not find the addin for winfax for office 2003. When I try to fax from a query in Access 2003, I get one cover page and a page for every record in the query, all as one document. I want a cover page for each record and a one page attachment. Any help woukd be greatly appreciated.

Howdy I think I'm having a simular problem. I have a form and a report based on a query. My form is in continuous view. I have a command button that opens the report on the form. I want the report to only display the records for a specific vendor that has focus or is filtered. I've tried a...

Ok Now I after a container/terms is chosen the query starts returning nothing. Also after a selection is made, and I focus on the next record set the previous selection disappears. The data is still recorded, it's just not displayed. SELECT [ProductID#], ProdName, Terms FROM tblProducts WHERE...

Hi KenReay Ok tblProducts: ProductID#, ProdName, Terms (rental, loan, purchase), Stock#... tblAgreements: Agreement#, CustID# (associated CustID#), ProductID#(=Container), Quanity. Replace Container in initial post with ProductID#. Thanks

Sorry I was so short on the Original Post. My Select Query now looks like this. SELECT tblProducts.[ProductID#], tblProducts.ProdName, tblProducts.Terms FROM tblProducts WHERE (((tblProducts.[ProductID#]) Not In (SELECT Container FROM tblAgreements)) AND ((tblProducts.Terms)<>"Purchase"))...

I have a parent table with Primary key CustID and a child table with a field ContainerType. This field is a query based combo box, on a subform data sheet with 16 values to choose from. After a ContainerType value is selected, I don't want it to be available again for that CustID. Any help...

I have a table tblGenerators with a field/primary key GenID# A table tblPSWMain (primary key PSW#) which is a child of tblGenerators with a linked field GenID# A table tblCtransPickups (primary key Ctrans#), also a child of tblGenerators with a linked field GenID# I have a process that uses a...