Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-28 : 08:26:25
|
| Ana Luisa Stevens writes "Hi !In Access 2000I need throw the value of a select count into a variableWhat can I do ?this is my sentence:SELECT Count([FESTIVOS].[FECHA]) AS CuentaDeFECHA FROM FESTIVOS WHERE [FESTIVOS].[FECHA]>=DATEVALUE(inicial) and [FESTIVOS].[FECHA]<=DATEVALUE(final); " |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-01-28 : 09:32:07
|
| A variable? are you using VBA? The DCOUNT() command should do what you are looking for.- Jeff |
 |
|
|
|
|
|
in Access ...I need throw a select count into a variable