Search results for query: *

Thanks Duane, I'll give that a shot. Mike

Duane, can you explain how this would avoid the extra prompting? Thanks, Mike

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

Thank you blorf, this worked great with a little massaging! --Mike

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.

Thanks PH..I've tried that, for some reason creating a blank 4K Excel file..no data whatsoever. Mike

Hi Duane, thanks, I know that will work with a query, but at the risk of sounding lazy :) I was hoping to be able to export from a report that's already formatted. Appreciate the quick reply. Mike

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

That worked beautifully! Thanks.

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