Results 1 to 2 of 2

Thread: Using variables in data reports

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jun 2006
    Posts
    22

    Using variables in data reports

    hi, i am using access as my database and i have a question. i want to create a report that will show all the products from my table where the userfield is equal to the current user.
    Now, the userid is held in a global variable but when i use it in my sql builder in the data report it doesnt work, but if i write the number in my sql e.g 344mm it works.
    anybody help please?
    thanks

  2. #2

    Thread Starter
    Junior Member
    Join Date
    Jun 2006
    Posts
    22

    Re: Using variables in data reports

    my guess is that for a post not having a reply then it should be very difficult to answer. anyways if anybody comes up with a solution let me know.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width