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 Chriss Miller 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. Tsumara

    Caclulating miles for leg of a trip

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

    Caclulating miles for leg of a trip

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

    Caclulating miles for leg of a trip

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

    problem with winfax office 2003

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

    Open report with filter

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

    filtering values in a combo box by previous selection

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

    filtering values in a combo box by previous selection

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

    filtering values in a combo box by previous selection

    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"))...
  9. Tsumara

    filtering values in a combo box by previous selection

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

    Need! Help getting returns on unbound objects

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

Part and Inventory Search

Back
Top