D
davie
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 | wk1en
1/1/2003 | 7/1/200
table
partno | count | dat
a-1 | 1.4 | 2/1/200
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 ???
ie:table1
wk1start | wk1en
1/1/2003 | 7/1/200
table
partno | count | dat
a-1 | 1.4 | 2/1/200
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 ???