Recent content by viral_patel1981

we are pulling the date ranges in from an excel sheet, which we have linked into access. so in effect we enter the two params into excel and then this will link back to the access database and pull the data. the problem we have is we cant think of a command for access to look at the excel table...

I'm entering two parameters i.e date ranges i want to display this on a form or report. can you help please?

I have two fields "F2" and "F4" in table "sheet1". which is a excel sheet linked to access. you enter the parameters in excel and its linked back to access to pull the data. I want to run a query in access that looks at fields F2 and F4 and gives me all the the data in between. i dont know...

i thought as much. thats fine thank you for your help guys. much appreciated

so a total(sum)query will allow me to insert subtotals into my existing query?

yes eventually

I have a simple query with several tables. e.g. rep sales 1 500.00 1 600.00 1 500.00 1 600.00 2 500.00 2 600.00 2 500.00 2 600.00 what i want to do is have this...