Viewing certain records and fields

[Guest]

Hi ,
I hvae two questions:

What are the citeria that i should use in a query to view the last 25 rows ?
Is there a way to view the last 7 fields of a query or a table ?

Thanx

 

[Brendan Reynolds]

Last 25 rows - sure, though you first need to consider the question "last in
what order?" See the article "Find the records with top or bottom values in
a field" at the following URL for more information ...

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051880331033

Last 7 fields - no, I can't think of a way to do that. It's a fundamental
principle of relational database design that the order of columns is
irrelevant. Why would you want to view 'the last 7 fields'?

 

[Guest]

I mean the last 25 recordes added to the table

Last 25 rows - sure, though you first need to consider the question "last in
what order?" See the article "Find the records with top or bottom values in
a field" at the following URL for more information ...

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051880331033

Last 7 fields - no, I can't think of a way to do that. It's a fundamental
principle of relational database design that the order of columns is
irrelevant. Why would you want to view 'the last 7 fields'?

 

[Brendan Reynolds]

Access does not store that information automatically. If your table has an
AutoNumber field with the New Values property set to the default value
(Increment) then you can use that to determine the most recently added
records, as long as the database is never replicated. (When a database is
replicated, the New Values property is automatically changed to Random). Or
you can add a Date/Time field with the Default Value property set to Now().
In addition to the article at the URL I posted earlier, see this one ...

http://msdn.microsoft.com/library/d...us/vbaac11/html/acproTopValues_HV05188192.asp