from Italy - DoCmd.OpenReport

  • Thread starter Thread starter Gianni Catucci
  • Start date Start date
G

Gianni Catucci

Hello everybody! Using Access 2000 in Windows XP
I created a database called CONTATORI.MDB with the table Contatori
including the following fields:

ID as counter
DataOp as date
TipoOp as string
Cliente as string
Indirizzo as string
Comune as string

Comune max 3 cities;
DataOp between the first and the last day of the month;
TipoOp max 3 patterns.

I must print the following reports per each Comune:

all the records with DataOp between the first and the last day of the
month + all the records with one TipoOp

And I try using the following instruction:

DoCmd.OpenReport NomeReport, acViewPreview, , CondizioneWHERE,
acViewNormal

But I can't get the wished result.

Considering that:

- in NomeReport I put the name of the report prepared with a Query
- I don't use any filter
- in CondizioneWHERE I set the string DataOp Between #datainiziomese#
And #datafinemese#

Can anyone give me a hint please?
Thanks
(e-mail address removed)
 
Gianni Catucci said:
Hello everybody! Using Access 2000 in Windows XP
I created a database called CONTATORI.MDB with the table Contatori
including the following fields:

ID as counter
DataOp as date
TipoOp as string
Cliente as string
Indirizzo as string
Comune as string

Comune max 3 cities;
DataOp between the first and the last day of the month;
TipoOp max 3 patterns.

I must print the following reports per each Comune:

all the records with DataOp between the first and the last day of the
month + all the records with one TipoOp

And I try using the following instruction:

DoCmd.OpenReport NomeReport, acViewPreview, , CondizioneWHERE,
acViewNormal

But I can't get the wished result.

Considering that:

- in NomeReport I put the name of the report prepared with a Query
- I don't use any filter
- in CondizioneWHERE I set the string DataOp Between #datainiziomese#
And #datafinemese#

Can anyone give me a hint please?
Thanks
(e-mail address removed)
Click to expand...

Usa la condizione WHERE come parametro dell'apertura della Form.
Leggendo l'Help potrai trovare descrizione ed esempio.
Tieni conto che la Formattazione della Data deve essere in formato Inglese
quindi dovrai usare Format(tuaData,"mm/dd/yy") altrimenti non funziona.
Ciao.
P.S. ci sono NG italiani nei quali forse puoi avere meno difficoltà di
lingua.
 
Hello everybody! Using Access 2000 in Windows XP
I created a database called CONTATORI.MDB with the table Contatori
including the following fields:

ID as counter
DataOp as date
......OMISSIS
Considering that:

- in NomeReport I put the name of the report prepared with a Query
- I don't use any filter
- in CondizioneWHERE I set the string DataOp Between #datainiziomese#
And #datafinemese#

Can anyone give me a hint please?
Thanks
(e-mail address removed)
Click to expand...

I've just found the solution. Thanks everybody. Bye
Gianni Catucci
 
Back
Top