472,378 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,378 software developers and data experts.

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
1 1886
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

66
by: Darren Dale | last post by:
Hello, def test(data): i = ? This is the line I have trouble with if i==1: return data else: return data a,b,c,d = test()
6
by: Stewart Allen | last post by:
Hi, I'm having trouble with the DMin function in finding the next date in the table that is greater than or is the same the date entered; The dates in the table's field are 04/18/02 06/16/02...
8
by: Gompie | last post by:
Why does the function DMin("Abs(!- #" & & "#)";"SomeTable") not work properly with datefields. It always finds the closest difference with a later date only, if an earlier date in the table is...
5
by: D. Shane Fowlkes | last post by:
This may be a very basic question but it's something I've never done before. I've looked at a couple of my favorite sites and books and can't find an answer either. I can write a Function to...
16
by: Nikolay Petrov | last post by:
How can I return multiple values from a custom function? TIA
8
by: aleksandar.ristovski | last post by:
Hello all, I have been thinking about a possible extension to C/C++ syntax. The current syntax allows declaring a function that returns a value: int foo(); however, if I were to return...
4
by: Ed Marzan | last post by:
Greetings, I have a query that returns varying prices for the same item in the following manner. Item1 Price1 Item1 Price2 Item1 Price3 Item1 Price4
2
ADezii
by: ADezii | last post by:
The incentive for this Tip was an Article by the amazing Allen Browne - I considered it noteworthy enough to post as The Tip of the Week in this Access Forum. Original Article by Allen Browne ...
4
by: Jonathan | last post by:
I have a SQL stored procedure for adding a new record in a transactions table. It also has two return values: CounterID and IDKey. I want to create a webservice that accepts the 10 input...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
2
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
0
DizelArs
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...
0
by: F22F35 | last post by:
I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.