How do I move rows in a data sheet table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wendy - 07 Apr 2006 22:37 GMT

I have created a database with 15 columns, input info, saved, had more info
to input opened found my July info in the middle of my April info, copied,
pasted back where it belonged, saved, deleted the extra rows, saved again,
closed, reopened, July back in the middle of April again, How do I fix?

Reply to this Message

gls858 - 07 Apr 2006 22:54 GMT

> I have created a database with 15 columns, input info, saved, had more info
> to input opened found my July info in the middle of my April info, copied,
> pasted back where it belonged, saved, deleted the extra rows, saved again,
> closed, reopened, July back in the middle of April again, How do I fix?

You order your data with a query. The order in the table is irrelevant.

gls858

Reply to this Message

John Vinson - 08 Apr 2006 02:44 GMT

>I have created a database with 15 columns, input info, saved, had more info
>to input opened found my July info in the middle of my April info, copied,
>pasted back where it belonged, saved, deleted the extra rows, saved again,
>closed, reopened, July back in the middle of April again, How do I fix?

A Table is an unordered "sack" full of data. There IS no meaningful or
useful order of records in a table, and you shoulnd't be opening the
table datasheet in any case.

Create a Query based on the table. Sort by your date/time field. Hey
presto, your records are now readable in chronological order! You can
base a Form or Report on this query.

You can also base a Form or Report on a parameter query with a
criterion such as

>= DateSerial([Enter year:], [Enter month number:], 1) AND < DateSerial([Enter year:], [Enter month number:] + 1, 1)

to see just the information for a chosen month.

John W. Vinson[MVP]

Reply to this Message