Obtaining Max value from Access DB

[Luis Medina]

I'm searching for VBA code that allows me read the max value in an Access
table field.

Thanks

Luis

 

[doug]

In an Access query or looking at an access database from
Excel?

if in Access, there's a max statement just like there is
in excel.

if you had field called [prices] in an access table, you
ought to be able to query it like this:

SELECT Max([Tablename].[Prices]) AS [Max]
FROM [tablename];

if you're constructing that in design view, drag and drop
the prices field into your query design, click totals and
set total to Max

 

[Luis Medina]

This is just what I need. Thanks lot

Luis

In an Access query or looking at an access database from
Excel?

if in Access, there's a max statement just like there is
in excel.

if you had field called [prices] in an access table, you
ought to be able to query it like this:

SELECT Max([Tablename].[Prices]) AS [Max]
FROM [tablename];

if you're constructing that in design view, drag and drop
the prices field into your query design, click totals and
set total to Max

-----Original Message-----
I'm searching for VBA code that allows me read the max value in an Access
table field.

Thanks

Luis


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.624 / Virus Database: 401 - Release Date: 03/15/2004


.