Access query work days function over 20 days

D

dbwong88

If select Days Elapsed over 20 days by adding >20 as criterion for the field
below.
DaysElapsed: DateDiff("y", [OrderDate], [ShippedDate])
Access will ignore the condition >20, still display all records.

If use WorkingDays ( ) function, Access through out error:†data type
mismatch in criteria expressionâ€, although the function DOES return “Integerâ€
 
J

John W. Vinson

If select Days Elapsed over 20 days by adding >20 as criterion for the field
below.
DaysElapsed: DateDiff("y", [OrderDate], [ShippedDate])
Access will ignore the condition >20, still display all records.

If use WorkingDays ( ) function, Access through out error:” data type
mismatch in criteria expression”, although the function DOES return “Integer”
Click to expand...

Please open your query in design view, use View... SQL to switch to SQL view,
and post the SQL of the query; and also the VBA code of your WorkingDays
function.

John W. Vinson [MVP]
 
R

ROMINA INES

escribió en el mensaje de noticias:si me van a mandar un mensaje q sea en
castellano no se hablar en ingles ok.
 
J

John W. Vinson

escribió en el mensaje de noticias:si me van a mandar un mensaje q sea en
castellano no se hablar en ingles ok.
Click to expand...

Si tienes pregunta sobre la programma Microsoft Access, puedes escribirlo en
microsoft.public.es.access en castellano.

Hay otros grupos por otras programmas.

John W. Vinson [MVP]
 
Top