catpuring data

  • Thread starter Thread starter Nelson
  • Start date Start date
N

Nelson

Hello,

I would like to know if anyone can help me with a capture
of data from a query.

For example, I would like to query a table between two
dates entered by the user. Thus, on the criteria I
type "Between [Please enter initial date] and [Please
enter final date]". It works the way I want, but now I
would like to capture those dates entered so that I can
use them in a report. Any idea?

Thank you in advance.
 
Hello,

I would like to know if anyone can help me with a capture
of data from a query.

For example, I would like to query a table between two
dates entered by the user. Thus, on the criteria I
type "Between [Please enter initial date] and [Please
enter final date]". It works the way I want, but now I
would like to capture those dates entered so that I can
use them in a report. Any idea?

Thank you in advance.
Click to expand...

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & [Please enter initial date] & " and " &
[Please enter final date]

The text within the brackets must be identical to the bracketed text
in the query.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On the report create a TextBox. Make its ControlSource property like
this (watch out for line-wrap):

="From " & Format([Please enter initial date],"mmm d, yyyy" & " to " &
Format([Please enter final date], "mmm d, yyyy")

This will place the entered dates in a sentence like so:

From May 2, 2004 to Oct 31, 2004



--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIb1k4echKqOuFEgEQIfjwCg5slJ0DqbHKy2shmcGVc6Wnjd+k4AnjjY
JuF7hcPNrOmAw4JKft2JtzIz
=OtNM
-----END PGP SIGNATURE-----
 
Won't this make the user enter the dates twice? Once
when the query is run and then again when the report is
opened?
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On the report create a TextBox. Make its ControlSource property like
this (watch out for line-wrap):

="From " & Format([Please enter initial date],"mmm d, yyyy" & " to " &
Format([Please enter final date], "mmm d, yyyy")

This will place the entered dates in a sentence like so:

From May 2, 2004 to Oct 31, 2004



--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIb1k4echKqOuFEgEQIfjwCg5slJ0DqbHKy2shmcGVc6Wnjd+ k4AnjjY
JuF7hcPNrOmAw4JKft2JtzIz
=OtNM
-----END PGP SIGNATURE-----

Hello,

I would like to know if anyone can help me with a capture
of data from a query.

For example, I would like to query a table between two
dates entered by the user. Thus, on the criteria I
type "Between [Please enter initial date] and [Please
enter final date]". It works the way I want, but now I
would like to capture those dates entered so that I can
use them in a report. Any idea?
Click to expand...

.
Click to expand...
 
I've tried, it works, thank you!
-----Original Message-----
Won't this make the user enter the dates twice? Once
when the query is run and then again when the report is
opened?
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On the report create a TextBox. Make its ControlSource property like
this (watch out for line-wrap):

="From " & Format([Please enter initial date],"mmm d, yyyy" & " to " &
Format([Please enter final date], "mmm d, yyyy")

This will place the entered dates in a sentence like so:

From May 2, 2004 to Oct 31, 2004



--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIb1k4echKqOuFEgEQIfjwCg5slJ0DqbHKy2shmcGVc6Wnjd
Click to expand...
+
k4AnjjY
JuF7hcPNrOmAw4JKft2JtzIz
=OtNM
-----END PGP SIGNATURE-----

Hello,

I would like to know if anyone can help me with a capture
of data from a query.

For example, I would like to query a table between two
dates entered by the user. Thus, on the criteria I
type "Between [Please enter initial date] and [Please
enter final date]". It works the way I want, but now I
would like to capture those dates entered so that I can
use them in a report. Any idea?
Click to expand...

.
Click to expand...
.
Click to expand...
 
Back
Top