Results 1 to 4 of 4
  1. #1
    gpierce9 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    NJ
    Posts
    19

    Qry criteria has trouble with Form picks


    I seem to have 2 problems for my crosstab.

    In the attached file, from a Form, I want to pick a Rep and a Customer for a report 8120.

    1 - Looking at Qry8120, I used what I thought was a normal criteria to get a RepID based on the form:
    [forms]![frm8100Finance]![cboRepID]
    and for the Customer:
    [forms]![frm8100Finance]![cboCusID77]

    I even used a Where. Not sure if I should have. Please refer to Qry8120.
    It does not like my two criteria lines.


    2 - Next, in qry8135, I hardcoded the repID to 36 and the CusID 246. The qry 8135 worked fine.
    However, a 2nd problem popped up in this crosstab. There is no data for months 2, 3, 4, 6, 11 and 12.
    So when I try to use the report 8135, It bombs out because those months had zero Qty.

    I appreciate your help. I made a mini file to follow better.
    It is called DB1.zip Glen.
    Attached Files Attached Files

  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
    21,612
    This should help with both:

    http://allenbrowne.com/ser-67.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    gpierce9 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Location
    NJ
    Posts
    19
    Quote Originally Posted by pbaldy View Post
    This should help with both:

    http://allenbrowne.com/ser-67.html
    Thanks alot. I will read this article. Sounds like up my alley for this problem. glen

  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
    21,612
    No problem.
    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. Replies: 4
    Last Post: 08-04-2015, 01:44 PM
  2. Replies: 5
    Last Post: 10-01-2014, 07:51 AM
  3. Replies: 7
    Last Post: 11-30-2013, 08:45 PM
  4. Replies: 1
    Last Post: 08-29-2013, 06:14 AM
  5. trouble creating correct criteria
    By pshawk in forum Queries
    Replies: 1
    Last Post: 02-12-2010, 01:52 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 - Senior Forums