Newbie, print date with parameter critiriea

  • Thread starter Thread starter verci
  • Start date Start date
V

verci

Hi

I use the following query for the reports record selection, using the
parameters Between [Fecha Inicial:] and [FechaFinal:] to filter records:

SELECT FacturaDetalle.FacturaID, Factura.NumFactura, Factura.FechFactura,
Factura.Nombre, Factura.Retencion, FacturaDetalle.Importe
FROM Factura INNER JOIN FacturaDetalle ON Factura.FacturaID =
FacturaDetalle.FacturaID
WHERE (((Factura.FechFactura) Between [Fecha Inicial:] And [Fecha Final:]));


How can I grab this parameter values to print in my report?

Best regards
 
In your report create 2 text boxes, one will have control source =[Fecha
Inicial:] and the other =[Fecha Final:], however, I recommend you use a form
that prompts for the parameters and then have you report's text boxes have
their control source =[Forms]![MyForm]![FechaInicial]
 
Hi

I use the following query for the reports record selection, using the
parameters Between [Fecha Inicial:] and [FechaFinal:] to filter records:

SELECT FacturaDetalle.FacturaID, Factura.NumFactura, Factura.FechFactura,
Factura.Nombre, Factura.Retencion, FacturaDetalle.Importe
FROM Factura INNER JOIN FacturaDetalle ON Factura.FacturaID =
FacturaDetalle.FacturaID
WHERE (((Factura.FechFactura) Between [Fecha Inicial:] And [Fecha Final:]));

How can I grab this parameter values to print in my report?

Best regards
Click to expand...

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & [Fecha Inicial:] & " And " & [Fecha Final:]

The text within the brackets must be identical to the bracketed text
in the query parameters.
 
Back
Top