access tables

[kmayo503]

i am looking for a way to copy down information in an access table that is the same.

 

[sawedoff]

I would be interested in seeing what other users come up with. I have only been able to do this by exporting the table to Excel, entering the data as I want it, then importing it back to Access.

Sawedoff

Give me ambiguity or give me something else.

 

[bluedragon2]

Why not do a find duplicates query?



Blue

If I wasn't Blue, I would just be a Dragon...

 

[sawedoff]

I don't know about KMAYO, but I was talking about new data, where perhaps the name is different, but the city is the same, you have to put the city into each record individually, instead of a single paste to several records.

Sawedoff

Give me ambiguity or give me something else.

 

[kmayo503]

i have the same data that needed to get copied down to a select group of fields.

 

[xlbo]

Would an update query not do that ???

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[kmayo503]

its not that complicated that it requires somthing like that and the range fluxuates. its never the same set cells. i just have to copy two fields of names down to a certain program. or the month to certain types of programs. but they all say the same thing. so its just a matter of copying info to a few cells.

 

[xlbo]

That's the thing with access - there is no concept of "Cells" and there's nothing tricky about an update query....


Set Tablename.Fieldname = "Result"
where Tablename.Fieldname = "criteria1" and Tablename.Fieldname = "criteria2"

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244