467,162 Members | 944 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,162 developers. It's quick & easy.

Can DMIN return multiple values

I need to write an update query that will return the earliest date to a
table based on the data of a different table.
I have a labor table that looks like this

TableLabor
JobCode WorkORder Sequence Date Hrs LinkedField
A B100 4000 3/1/04 5 AB1004000
A B100 4000 2/1/04 8 AB1004000
B A100 2000 3/3/04 10 BA1002000
etc...

In my other table i need to show for each instance of Jobcode,
Workorder and sequence the earliest date.

TableBaseline
Jobcode Workorder Sequence Date LinkField
A B100 4000 2/1/04 AB1004000

Basically i need an update query to take the earliest date from
TableLabor and input it into the Date field of the TableBaseline field.

I created a query for each table with a linked field that contains
JobCode, Workorder and Sequence (is that right?) so the link field
would be AB1004000 and so on... I then used a query based on the
TableBaseline table and used the following function to update my
table...
dmin("[date]","tablelabor","[linkedfield]=[linkedfield]")
But it doesnt work...HELP please

Nov 13 '05 #1
  • viewed: 1564
Share:
1 Reply
turtle wrote:
I need to write an update query that will return the earliest date to a
table based on the data of a different table.
I have a labor table that looks like this

TableLabor
JobCode WorkORder Sequence Date Hrs LinkedField
A B100 4000 3/1/04 5 AB1004000
A B100 4000 2/1/04 8 AB1004000
B A100 2000 3/3/04 10 BA1002000
etc...

In my other table i need to show for each instance of Jobcode,
Workorder and sequence the earliest date.

TableBaseline
Jobcode Workorder Sequence Date LinkField
A B100 4000 2/1/04 AB1004000

Basically i need an update query to take the earliest date from
TableLabor and input it into the Date field of the TableBaseline field.

I created a query for each table with a linked field that contains
JobCode, Workorder and Sequence (is that right?) so the link field
would be AB1004000 and so on... I then used a query based on the
TableBaseline table and used the following function to update my
table...
dmin("[date]","tablelabor","[linkedfield]=[linkedfield]")
But it doesnt work...HELP please


Maybe use a totals query and get the Min of the date.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

66 posts views Thread by Darren Dale | last post: by
6 posts views Thread by Stewart Allen | last post: by
8 posts views Thread by Gompie | last post: by
5 posts views Thread by D. Shane Fowlkes | last post: by
16 posts views Thread by Nikolay Petrov | last post: by
8 posts views Thread by aleksandar.ristovski@gmail.com | last post: by
4 posts views Thread by Ed Marzan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.