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

    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?


    Seweryn

  2. #2
    seweryng is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2010
    Posts
    5
    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