Dmin

[Fred]

I want to do one query with function Dmin but is not work...
is possible to do this?
PF:5,44*[Activa_P]/(576*[POTdec])*DMín([POTdec];[Activa_P]/(24*[n_dias_mes]))
where POTdec,Activa_P, and n_dias_mes are fields to diferents tables

thanks

FRED

 

[John W. Vinson]

I want to do one query with function Dmin but is not work...
is possible to do this?
PF:5,44*[Activa_P]/(576*[POTdec])*DMín([POTdec];[Activa_P]/(24*[n_dias_mes]))
where POTdec,Activa_P, and n_dias_mes are fields to diferents tables

thanks

FRED

Since we do not know anything about your table structure, what's in your
query, what result you want, or what "didn't work" it's more than a bit
difficult to help. More info please?

 

[John Spencer]

First DMIN requires STRINGS.

DMIN("PotDec","SomeTable","SomeField = SomeValue"

Beyond that I have no idea what you are attempting to do.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Fred]

Hi... my query have 2 tables(TB_input, TB_parques) have one relationship
between this fields [Nome_Parque.TB_input] and [Nome do Parque.TB_parques]
I want create one field PF1, where
PF1Mín([POTdec];[Activa_P]/(24*[n_dias_mes]))
I want PF1 return minimum value between POTdec and [Activa_P]/(24*[n_dias_mes]

my query is
Fields: Nome_Parque Ano Activa_P n_dias_mes POTdec
PF1:
Table: TB_input TB_input TB_input TB_input
TB_parques

Activa_P,n_dias_mes and POTdec are numbers

thanks

Fred

I want to do one query with function Dmin but is not work...
is possible to do this?
PF:5,44*[Activa_P]/(576*[POTdec])*DMín([POTdec];[Activa_P]/(24*[n_dias_mes]))
where POTdec,Activa_P, and n_dias_mes are fields to diferents tables

thanks

FRED

Since we do not know anything about your table structure, what's in your
query, what result you want, or what "didn't work" it's more than a bit
difficult to help. More info please?