Arcadio
Diamond Member
I need to create one database with the following fields:
Name
Date
Company
Amount1
Amount2
Total
That's the easy part. Now I need a way to generate views sorted by whatever fields I specify. For example, I need an easy way to sort the data in the database by date like this:
10/30/09
John Doe Company X $34 $56 $90
Alice Company Y $32 $56 $58
Bob Company X $35 $33 $68
10/31/09
Alice Company Y $12 $36 $48
Jane Company Y $39 $82 $121
Or an easy way to sort the information by name, like this:
Alice
10/30/09 Company Y $32 $56 $58
10/31/09 Company Y $12 $36 $48
Bob
10/30/09 Company X $35 $33 $68
Is this possible with Access 2007? Thanks in advance. I've never been good with MS office programs.
Name
Date
Company
Amount1
Amount2
Total
That's the easy part. Now I need a way to generate views sorted by whatever fields I specify. For example, I need an easy way to sort the data in the database by date like this:
10/30/09
John Doe Company X $34 $56 $90
Alice Company Y $32 $56 $58
Bob Company X $35 $33 $68
10/31/09
Alice Company Y $12 $36 $48
Jane Company Y $39 $82 $121
Or an easy way to sort the information by name, like this:
Alice
10/30/09 Company Y $32 $56 $58
10/31/09 Company Y $12 $36 $48
Bob
10/30/09 Company X $35 $33 $68
Is this possible with Access 2007? Thanks in advance. I've never been good with MS office programs.
