Form to enter criteria for report

[Karen]

Hi,

I have created a form that allows the user the enter beginning and ending
dates for a report. The form I am currently using was created from the
Microsoft Help topic called "Create a form to enter report criteria". I need
to add additional criteria to the form.
The report will also need to return records based on the length of the
characters entered into a particular field called Fund. Besides the date
range, Report Type 1 will return those records with Len([Fund])>4 and Report
Type 2 will return Len([Fund])<= 4. I am having difficulty with how to enter
the parameter into the underlying query.

 

[ManningFan]

Put this behind the Run Report button:

if len([Fund])>4 then
Report Type 1
else
Report Type 2
end if

 

[Karen]

Would the Run Report button be be the OK button on the form? I am not clear

Put this behind the Run Report button:

if len([Fund])>4 then
Report Type 1
else
Report Type 2
end if

Hi,

I have created a form that allows the user the enter beginning and ending
dates for a report. The form I am currently using was created from the
Microsoft Help topic called "Create a form to enter report criteria". I need
to add additional criteria to the form.
The report will also need to return records based on the length of the
characters entered into a particular field called Fund. Besides the date
range, Report Type 1 will return those records with Len([Fund])>4 and Report
Type 2 will return Len([Fund])<= 4. I am having difficulty with how to enter
the parameter into the underlying query.

 

[ManningFan]

Do yourself and your boss a favor; contract out the job to a qualified
Access programmer.

Would the Run Report button be be the OK button on the form? I am not clear

Put this behind the Run Report button:

if len([Fund])>4 then
Report Type 1
else
Report Type 2
end if

Hi,

I have created a form that allows the user the enter beginning and ending
dates for a report. The form I am currently using was created from the
Microsoft Help topic called "Create a form to enter report criteria". I need
to add additional criteria to the form.
The report will also need to return records based on the length of the
characters entered into a particular field called Fund. Besides the date
range, Report Type 1 will return those records with Len([Fund])>4 and Report
Type 2 will return Len([Fund])<= 4. I am having difficulty with how to enter
the parameter into the underlying query.

 

[Karen]

I was going to thank you for the information, since I got it to work. I was
a bit fried yesterday when I replied to the post. Sorry to inconvience you
in any way.

Do yourself and your boss a favor; contract out the job to a qualified
Access programmer.

Would the Run Report button be be the OK button on the form? I am not clear

Put this behind the Run Report button:

if len([Fund])>4 then
Report Type 1
else
Report Type 2
end if


Karen wrote:
Hi,

I have created a form that allows the user the enter beginning and ending
dates for a report. The form I am currently using was created from the
Microsoft Help topic called "Create a form to enter report criteria". I need
to add additional criteria to the form.
The report will also need to return records based on the length of the
characters entered into a particular field called Fund. Besides the date
range, Report Type 1 will return those records with Len([Fund])>4 and Report
Type 2 will return Len([Fund])<= 4. I am having difficulty with how to enter
the parameter into the underlying query.