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 bkrike 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: blakey
  • Content: Threads
  • Order by date
  1. blakey

    Multi-level group by clause is not allowed in subquery

    Hi I am using access 97 and have a query the groups some fields, averages others and has a inner select to another table that sums rrequired field. I am consistently calculating averages etc for monthly periods and then annualised averages. When I create the report any fields in the footer...
  2. blakey

    Printing report based on selecting individual records

    Hi I have table that holds all payments. I need to be able to print a report for a group of payments. I do have a common value to select on eg date or supplier but rather need to select random individuals. (not random in the true sense of the word) What I am considering is a screen that...
  3. blakey

    Restricting query to x records

    Hi I need to extract a number of records from sales table. When I use the top predicate it is either by percentage or number in the sql(hard coded). I want the sql to ask the user for the number of records required and ask the user for the sort order. Output would then be for x records in...

Part and Inventory Search

Back
Top