Dmin

  • Thread starter Thread starter Fred
  • Start date Start date
F

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
 
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
Click to expand...

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?
 
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
'====================================================
 
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
PF1:DMí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


John W. Vinson said:
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
Click to expand...

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?
Click to expand...
 
Back
Top