Extract Data

[Guest]

Pls tell me how do I extract records from a Table in Access from Row X to Row Y - pls give me the exact sysntax for the sam

Thanx and Regard
Avijit Sircar

 

[Andrew L.]

Could you be more specific about what you want to do? If you want a query to display certain
records in a sequence, the query design criteria would be something like:- [RECNUMBER]>1000 And
[RECNUMBER]<2000

However if you just want to copy/paste a piece of data in your table, this is best done in datasheet
view, using copy/paste or Ctrl-' for individual fields.

Andrew L.

 

[John Vinson]

Pls tell me how do I extract records from a Table in Access from Row X to Row Y - pls give me the exact sysntax for the same

Thanx and Regards
Avijit Sircar

Ask a vague question, get a vague answer:

With an Append query:

INSERT INTO Table
SELECT * FROM Table
WHERE [Row] = X

Note that Access tables DO NOT HAVE ROW NUMBERS so your question as
phrased is meaningless.

Could you explain in a bit more detail the structure of your table;
what you mean by "row"; and just what you want to do?