Search results for query: *

I am having a strange issue regarding a report based in a Crosstab query which uses two datetime fields for arguments. It works fine when you run the query alone, prompts the user once for a starting and ending date, and returns the right result set. When I attempted to create a report using...

Was wondering if anyone had a good code snippet to do this? I would like to allow the user to select their own location to place the file, but don't see a clear example within the VB help.. thx.

Hi All, is there a good method for exporting to an Excel file based on a crosstab query? I can use the Pivottable view to manually extract data but I need to be able to automate this from within the app.. thanks, Mike

Does any have a good method for sorting on a grouped column within a footer? For example, I would like to grab the total values by group, stick it in the group footer, and then sort the report by it.. I was thinking that this could be done within the sql select somehow, but not quite...

Hello all, Fairly basic question, I'm sure..I am trying to create a SQL based query to return all records from the start of the current month only. This criteria below works great for returning a rolling 30 days.... >=(DateAdd("m",-1,Date())) ...but I always want it fixed from the start of the...