Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47

    Unanswered: Referencing values in another table

    I have created a table with a date,partnumbers and count fields. In another table i have a date ranges table which i need to call to see if the part when counted fall in between.
    ie:table1:
    wk1start | wk1end
    1/1/2003 | 7/1/2003

    table2
    partno | count | date
    a-1 | 1.4 | 2/1/2003


    if the date entered falls in the start and end value, it needs to be counted once for every time that part number falls in the dates. and recorded in another query.The values of the of the dates must be kept in their own table so they can be edited later.I have managed to create they query by :>1/1/2003 and <=7/1/2003 which works, but i need to reference the other table with the values in and use the same expression. Plz can any one help ????



    Print | Copy URL of this post

  2. #2
    Join Date
    Nov 2003
    Location
    Makati City, Philippines
    Posts
    14

    Wink Re: Referencing values in another table

    Hi there, i'm not sure if i get your problem clearly but here it goes.

    are you trying to run this on a query? if yes, here's an answer based on your sample tables. i'm also assuming that you have placed both tables in the qbe area. first click "View" / "Totals" (or the E icon on the toolbar) and then try the attachment. what it does is it sums up the count field per partno group.

    hope that helps,
    Reggie



    Originally posted by davieboy_xr
    I have created a table with a date,partnumbers and count fields. In another table i have a date ranges table which i need to call to see if the part when counted fall in between.
    ie:table1:
    wk1start | wk1end
    1/1/2003 | 7/1/2003

    table2
    partno | count | date
    a-1 | 1.4 | 2/1/2003


    if the date entered falls in the start and end value, it needs to be counted once for every time that part number falls in the dates. and recorded in another query.The values of the of the dates must be kept in their own table so they can be edited later.I have managed to create they query by :>1/1/2003 and <=7/1/2003 which works, but i need to reference the other table with the values in and use the same expression. Plz can any one help ????



    Print | Copy URL of this post

  3. #3
    Join Date
    Nov 2003
    Location
    uk
    Posts
    47

    Smile

    sorted now! thanks any way

Posting Permissions

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