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: *

  • Users: awesomeBA
  • Content: Threads
  • Order by date
  1. awesomeBA

    Select statement/ this ones easy

    Ok I am very rusty and under a deadline. I need syntax help with the following Query. Select * From SvyDtl Where SvyDtl.SdPrjnum = ClsdPort.CpPrjNum. Any and all help is appreciated.
  2. awesomeBA

    Combine Results

    I'd like to use the results of two querys to create a table. Both contain the same column names and properties. Can you help with the best approach? I tried teh wizard it was a not go? Pprobably ID10T user error :)
  3. awesomeBA

    Syntax for Joining on a range

    I would like to create a join using a range. Do I need to indicate that the match will be a range of the field in the second table?
  4. awesomeBA

    Sort and Count

    Good Morning!- I need to create a query or report that will sort a table by building_code and return/display the total. The table doesn't currently have a numeric field to use to count.
  5. awesomeBA

    Access Query returning more rows than in queried data base

    I created a query in Access using the wizard that returns more rows than in the queried DB. It is a inner join using the address field from two tables. Fairly new DB user, (Obviously). Please help!

Part and Inventory Search

Back
Top