Max of field

[Roger Carlson]

Max.

How do you want to use it?

 

[Joan Wild]

You can use the Max function. For example, in a query
SELECT Max(Quantity) AS MaxOfQuantity
FROM [Order Details];

 

[krrs]

What is the function or command in Access to return the Max of a numeric
field?

Thanks
Roy

 

[krrs]

Thanks for the reply. I'm trying to replace my Paradox3.5 [for dos] with
Access. I've used it 12 years and it looks like it might take me that long
to figure out
how to get it done.

In a subform I have a numeric field "ItemNumber" that keeps repairs stored
together and I want to get the max value so that no matter what line I'm on,
when that line is complete I add a new blank record with the next available
"ItemNumber"

Thanks Again
Roy





----- Original Message -----
From: "Roger Carlson" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 8:59 AM
Subject: Re: Max of field

Max.

How do you want to use it?

----- Original Message -----
From: "Joan Wild" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 9:20 AM
Subject: Re: Max of field

You can use the Max function. For example, in a query
SELECT Max(Quantity) AS MaxOfQuantity
FROM [Order Details];


--
Joan Wild
Microsoft Access MVP

What is the function or command in Access to return the Max of a numeric
field?

Thanks
Roy

----- Original Message -----
From: "Roger Carlson" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 8:59 AM
Subject: Re: Max of field

Max.

How do you want to use it?

----- Original Message -----
From: "Joan Wild" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 9:20 AM
Subject: Re: Max of field

You can use the Max function. For example, in a query
SELECT Max(Quantity) AS MaxOfQuantity
FROM [Order Details];


--
Joan Wild
Microsoft Access MVP

What is the function or command in Access to return the Max of a numeric
field?

Thanks
Roy

 

[Roger Carlson]

Actually for this, you want to use the DMax() function. On my website (see
sig below) is a small sample database called "AutonumberProblem.mdb" which
illustrates how to do this.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Thanks for the reply. I'm trying to replace my Paradox3.5 [for dos] with
Access. I've used it 12 years and it looks like it might take me that long
to figure out
how to get it done.

In a subform I have a numeric field "ItemNumber" that keeps repairs stored
together and I want to get the max value so that no matter what line I'm on,
when that line is complete I add a new blank record with the next available
"ItemNumber"

Thanks Again
Roy





----- Original Message -----
From: "Roger Carlson" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 8:59 AM
Subject: Re: Max of field

Max.

How do you want to use it?

----- Original Message -----
From: "Joan Wild" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 9:20 AM
Subject: Re: Max of field

You can use the Max function. For example, in a query
SELECT Max(Quantity) AS MaxOfQuantity
FROM [Order Details];


--
Joan Wild
Microsoft Access MVP

What is the function or command in Access to return the Max of a numeric
field?

Thanks
Roy

----- Original Message -----
From: "Roger Carlson" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 8:59 AM
Subject: Re: Max of field

Max.

How do you want to use it?

----- Original Message -----
From: "Joan Wild" <[email protected]>
Newsgroups: microsoft.public.access.gettingstarted
Sent: Wednesday, March 10, 2004 9:20 AM
Subject: Re: Max of field

You can use the Max function. For example, in a query
SELECT Max(Quantity) AS MaxOfQuantity
FROM [Order Details];


--
Joan Wild
Microsoft Access MVP

What is the function or command in Access to return the Max of a numeric
field?

Thanks
Roy

What is the function or command in Access to return the Max of a numeric
field?

Thanks
Roy