Running select and append queries to find data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to run a macro from a command button that allows for a
specific data set to be found and then appended to a seperate table. I have
a central table that holds all info, and i want to ne able to type in
'surname' for example and access the relevant data set which wold then be
appended into a subsiduary table. Any help would be great!!!
 
How far have you progressed? Do you have an append query created? Do you
know how to add criteria to a query so that only specific records/rows are
returned from the query?
 
i am quite confident (i think) about writing the append tabel, to run from
the select query that hopefully will run earlier in the macro. It is the
selct query i am unsure of as the criteria for selection will be entered
manually when a record is being located. does this sound sensible?
 
I'm not sure how you expect users to select/filter records and why they
would append and keep duplicates.

Your questions are really vague so it is difficult to provide any
assistance.
 
Back
Top