Find the last entry in a coloum?

[David_Skov]

I hope it's simple. I figured out how to make my query formula and make it work. Now I just need a formula to get the last entry in a specific coloum. Is there such a formula in query? ray:

 

[Norie]

What do you mean by 'last entry'?

 

[David_Skov]

What do you mean by 'last entry'?

I mean I need to find the number in the 3. coloum and the last row. If I have 16000 rows the last row is 16000, so the last entry is in 3. coloum and 16000. row

It's just an example. I need to be able to retrieve that last entry each time I import more data to the database

Hope that makes sense

 

[David_Skov]

The coloum I talk about consist of week-numbers and to automate the process as much as possible I need to be able to get the weeknumber in the last record in my database since that's a parameter for my YTD indication

 

[bat17]

is there any thing that would distinguish the last record IE. autonumber? Access does not really see records in the same way as excel.

You can always calculate the week number for the current date though.

Peter

 

[mdmilner]

Looks like this is being answered in this thread:

http://www.mrexcel.com/board2/viewtopic.php?t=103566

What Bat is suggesting/describing is this. Access does not really look at records like Excel does as rows. Lets say you import 16000 rows from Excel. Just because a given row is #15550 in Excel does not mean it'll be the same row number in Access during an import.

The only way to guarantee it is to avoid the import wizard, open excel with VBA code and import it line by line. Could also cut n paste it in manually.

But, Access still won't look at a given row as always being a given number. The Access fix is to number each row (record). And, Autnumber does it for you.

Mike