Results 1 to 4 of 4
  1. #1
    sk88 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    183

    date parameters export in crosstab queries


    I have a crosstab queries and a form that with a click of a button will export to excel. However, the date parameters is not working. I would like users to be able to choose the date and export those data only. Any suggestions how I can go about doing this?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    What does "not working" mean exactly? Is it:

    Crosstab Query with a Parameter
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    sk88 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    183
    Quote Originally Posted by pbaldy View Post
    What does "not working" mean exactly? Is it:

    Crosstab Query with a Parameter

    Thanks pbaldy.

    Yes, that's what I tried (Parameter, Data Type) and it is not working . What did I do wrong here?

    [Forms].[Form1].[StartDate] Date/Time

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    It would be nice to know what "not working" means. Can you post the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Particular Crosstab Query Problem (w/ parameters)
    By McArthurGDM in forum Access
    Replies: 14
    Last Post: 12-29-2014, 02:46 PM
  2. Replies: 3
    Last Post: 10-24-2014, 12:15 PM
  3. Replies: 5
    Last Post: 12-04-2012, 02:46 AM
  4. Crosstab and Export Form example
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-24-2010, 12:30 AM
  5. Crosstab Criteria or Parameters
    By lukewarmbeer in forum Access
    Replies: 3
    Last Post: 08-11-2010, 09:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums