How do I move rows in a data sheet table?

W

wendy

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?
 
G

gls858

wendy said:
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?
Click to expand...
You order your data with a query. The order in the table is irrelevant.

gls858
 
J

John Vinson

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?
Click to expand...

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)
Click to expand...

to see just the information for a chosen month.

John W. Vinson[MVP]
 
Top