Need parameter to write data to table: please help!

[Guest]

I have a query that tells me how long each batch will take to make in the
factory.
The fields are: release date, priority, status, work order number, vessel,
vessel group, and total time.

I would like to input the start time for the highest priority (lowest
number) batch for each vessel group. I am going to use a form for this.

How do I write a parameter to only use the start date I input for the lowest
numbered priority in each vessel group?

 

[Guest]

Create your form first. Then wherever you want to use the start date in your
query, just right click and select build.. then browse to your form, find the
control ( textbox, combobox, whatever ) and find the property you want to
display.

Like for a textbox you want to choose .text, it will look something like:
[Forms]![Form2]![text24].[text]

You can use that wherever you could use any field from your tables.

Hope it helps

 

[John W. Vinson]

Create your form first. Then wherever you want to use the start date in your
query, just right click and select build.. then browse to your form, find the
control ( textbox, combobox, whatever ) and find the property you want to
display.

Like for a textbox you want to choose .text, it will look something like:
[Forms]![Form2]![text24].[text]

Actually, it's probably preferable to use the default Value property; you can
do so by just using [Forms]![Form2]![text24] as a criterion in your query.


John W. Vinson [MVP]

 

[Guest]

The only problem is that I don't want it to be the default value for every
record in my query...just for the lowest numbered priority for each resource.

Example:
Priority Start Finish Resource
1 1/1/01 5 am 1/2/01 4 pm 1
2 1/1/01 5 am 1/2/01 1 pm 2
3 1/2/01 4 pm 1/2/01 11 pm 1
4 1/2/01 1 pm 1/2/01 7 pm 2
5 1/2/01 11 pm 1/3/01 4 pm 1

So, the batches with a priority of 1 & 2 start at the same time, because
they have different resources.

I have asked this question in a different format in the Question titled:
"Help with Query", so maybe this is a moot point.

Create your form first. Then wherever you want to use the start date in your
query, just right click and select build.. then browse to your form, find the
control ( textbox, combobox, whatever ) and find the property you want to
display.

Like for a textbox you want to choose .text, it will look something like:
[Forms]![Form2]![text24].[text]

Actually, it's probably preferable to use the default Value property; you can
do so by just using [Forms]![Form2]![text24] as a criterion in your query.


John W. Vinson [MVP]