UpdateQuery Question

A

AnyNews4Me

Hi,

How do i "transfer" values from a list-box (first column) to another
table? I've been trying for weeks now without any result.
The problem is as followes, I have listbox filled with product numbers.
These numbers (in the first column) need to be transfered to another
table together with a value from a textfield.
E.g.: Listbox has 10 productnumbers and the textfield has a value 20.
I would like to have the 10 numbers put into the table "calculate" with
the values 20. (so another query calculates the price).
I've tried this several times (for weeks now) with an "update-query"
but so far without any positive result.
Does anybody have any (other) suggestions or idea's to accomplish this.??

Thanks in advance for helping,

Ant.
 
G

Guest

Update queries modify date that already exists in a table.
does the table exist yet. if not then you will need a make
table query. you can use the same query that populates the
list box and file>save as>new name. then turn it into a
make table query. if the table already exits then you will
need an append query. append querys add new data to a
table.
 
A

AnyNews4Me

Thanks for reacting,

The table exists and i guess i had overseen the Append-query option.
Problem however remains cause i do not know how to 'select' only
the product numbers from my list-box. It has 5 columns and the product
numbers are in column 1. Problem is also that i do not know how to
"append" only those numbers listed in my list-box. there are about
14000 articles in one table and need to select (with the list and combo-box)
certain products to be put into another table. (which exists already)
It is more a problem for me to type the right criteria in the append-query
i guess.
Any help will still be much appreciated.
Greets,
Ant,.
 
G

Guest

hi again,
i still see no real problem for you. how is the list box
selecting its records? use that as an example to write the
append query's criteria. you just need to use the part of
the combo box query that selects the numbers.
 
N

News

Thanks for your time in advance,

The list-box selects records based on a combo-box (this one is filled with
173 brands)
So when selecting a brand form the combo, lets say Epson, the list-box gets
filled with all the products from Epson. The listbox shows ProdNr,
Descr.,Packaging, Price.
The idea is to "transfer" these ProdNr (not the other fields) to a table
called "calculation"
This table exists and has two columns ( ProdNr | Calc ) .
So the Prodnr's in the listbox together with a calculation value (textfield
on my form)
needs to be transffered to the table Calculation.
Somehow i don't seem to get the query criteria right (the syntax).
Hope this makes anything clearer, i'm from the Netherlands, so you'll have
excuse
my louzy English.

Thanks again,
Greets
Ant.
 
Top