Search results for query: *

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

Set up two hidden fields for year and month for the cancelled date. Add the same criterior you have for your existing fields to the new fields but in one line down on the grid. This will make use of the "OR" condition in the query. cheers

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

Thanks for the response. I had sort of figured out that it could not be done directly in sql and would need some form of a routine. When I work it out I will let you know. Cheers

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