What's the difference b/tween queries

[Troubled]

What is the difference between an append and an update query
I have a table with products and prices. I want to display them in a form in a different order then they are in the table.
I thought I could do it with a query to gather the information I need.
But once I have the results and put them in a form - I need to be able to update the original table
Is that possible
Thanks

 

[Van T. Dinh]

An Append Query is used to add *new* Records.

An Update Query is used to update *existing* Records.

However, what you need sounds more like a SELECT Query and use this Query as
the RecordSource for the Form. If the Query is updateable, then you can add
new Records and update existing Records through the Form GUI.

Suggest you check the Queries chapters in any Access book you have.

--
HTH
Van T. Dinh
MVP (Access)

What is the difference between an append and an update query?
I have a table with products and prices. I want to display them in a form

in a different order then they are in the table.

 

[troubled]

Actually, I've read the chapters several times.
I'm just confused by them.
I actually have this
product description product size pric
same product desc different size pric

I'm trying to display it something like

product description 1st price 2nd pric

I tried a cross-tab query but that's not updateable.

Is there a way to pull in specific values into a form. I'd like to have all of the values at once

I could try to display using a few forms with filters

Thanks

 

[John Vinson]

Actually, I've read the chapters several times.
I'm just confused by them.
I actually have this:
product description product size price
same product desc different size price

I'm trying to display it something like:

product description 1st price 2nd price

I tried a cross-tab query but that's not updateable.

Would it be acceptable to have a Form based on the Product table
(showing the product description) with a Subform based on a related
table, with one record per size? The visual would be more like

Product Description
Size Price
Size Price
Size Price

but it would be updateable and much easier to implement.

I could try to display using a few forms with filters?

I'm not at all sure what you're asking here!