Results 1 to 2 of 2
  1. #1
    seweryng is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010

    Query. Extra column.

    I have a small problem. Iíve enclosed a database to explain it clearly.
    I have 3 tables and 3 queries.
    3 tables contain data from 2008, 2009 and 2001.
    The first and the second query (owner, places) compare data for columns WL_KI and MJS_WID and if value is different return column IsERROR .

    Firstly, I don't know how to add another column, let's call is IsERRORdecision, which will have 2 values Yes/No. Combo filed, value list, checkbox? Whatís more, default value for isERRORdecision must be the same as for column IsERROR.

    Secondly, Iíve created a query (jointly) that gathers information from the first and the second query, but it is impossible to change values from this level in my source tables. Is it doable?


  2. #2
    seweryng is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    I reorganised my db so, help is no longer necessary.

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

Similar Threads

  1. Replies: 5
    Last Post: 12-03-2010, 01:39 PM
  2. Extra data
    By newtoAccess in forum Reports
    Replies: 14
    Last Post: 11-28-2010, 12:05 AM
  3. extra detail sections
    By kroenc17 in forum Reports
    Replies: 10
    Last Post: 10-08-2010, 11:35 AM
  4. Extra space added
    By allenf in forum Forms
    Replies: 2
    Last Post: 07-25-2010, 06:57 AM
  5. Replies: 7
    Last Post: 04-27-2010, 02:47 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