Results 1 to 2 of 2
  1. #1
    iamraja5 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    16

    Simple query Question, please Help

    Hi
    Let me put this question in a simple way,
    I have a form name : FORM_A
    Combo Name : Opera
    Note: Combo linked to a table full of Operators i.e <, >, <=, etc.
    and there is a Text box called units, user can enter units

    1) How in a query, I can write a statment for the following?
    in the Qty field,
    take the oprator sign from the FORM_A and the qty whater the user entered on the form?
    Combine two paremeters from the FORM_A to the query block?

    I tried like this, but not working, getting an error msg, complex formmula.


    Forms![FORM_A]![Opera] & Forms![TAN Main]![units]


    Please help, this driving me crazy..
    Thanks

  2. #2
    iamraja5 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    16
    attached is the DB.


    Thanks
    Last edited by iamraja5; 03-16-2010 at 09:09 AM.

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

Similar Threads

  1. Simple question
    By KenM in forum Queries
    Replies: 1
    Last Post: 11-10-2009, 03:32 PM
  2. Simple question?
    By roads.zx in forum Access
    Replies: 0
    Last Post: 10-15-2009, 04:56 PM
  3. Very simple question!
    By fiddley in forum Programming
    Replies: 2
    Last Post: 04-28-2009, 02:16 AM
  4. Should be simple Query Question
    By brj1 in forum Queries
    Replies: 2
    Last Post: 03-04-2006, 01:11 PM
  5. Probably a simple report question
    By gmurrie in forum Reports
    Replies: 1
    Last Post: 12-28-2005, 09:19 PM

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