report 1

[eshaan]

I have form. User can enter start date and end date on text boxes, and select data from three comboboxes.

User can select from first combobox dept name
seccond combobox person name
third combobox is completed evaluation or processing evaluation or incompleted.


I created a query .
In query date crieteria I entered
>=[forms]![tfrmsname]![txtstdate]and<=[forms]![frmname]![txtenddt]
for firstcombobox [forms]![frmname]![combboxname]
for second combobox [forms]![frmname]![comboxname]
I ran query and entered values on each prompting parameter it is working but when I entered values through form it is printing empty report.

Actually the third combobox values are dates on table. I am selecting from query Isnull is incompleted, isnotnull is completed etc. for third combobox i don;t know how to enter in crieteria.
through form.

Please help me ,

 

[nq]

There may be several reasons for an empty report.
It would be best to use the following syntax

Between [forms]![tfrmsname]![txtstdate] And [forms]![frmname]![txtenddt]

On your form make sure the two date boxes are formatted for short date (or whatever you want).


Your query may need parameters specified. Edit the query and under Query | Parameters enter the appropraite data
eg
Parameter - [forms]![frmname]![combboxname]
Data Type - Text

You need to do this for every parameter on your form

I'm not sure about the third combo problem. It seems that you want to make three decisions from date information. Using "Is Null" in a criteria will only give you two decisions.

Hope that helps
Nigel.

 

[eshaan]

Thank you. I will try today to set data types date and text.
If i choose two options on third combobox how can I enter in criteria?

if user choose from third combobox "completed " It has to be isnotnull
if user choose from third combobox "incompleted" it has to be isnull.

How can i enter in criteria above two.

 

[PHV]

WHERE Nz([field name],'?')=IIf([Forms]![frmname]![third combo]='completed',[field name],'?')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[eshaan]

Hi PH,

Thank you,

I want to put both completed and incompleted

if combobox = completed it has to be isnotnull if combobox = incompleted it has to be isnull. How can i enter both in where conditions. what is the Nz after where ?

 

[eshaan]

It is not working . Please specifiy where can I define data type as text?

Also Third combobox.

Urgent please.

 

[eshaan]

Hi PH,
where nz([completion date],'?')=iif([forms]![testfrm]![Cmbproc]='completed',[completion date],'?')

I entered above in where clause giving error The expression you entered contain invalid syntax.

 

[PHV]

This is SQL syntax not to be used in query grid but in the SQL view pane:
WHERE Nz([completion date],#1900-01-01#)=IIf([Forms]![testfrm]![Cmbproc]='completed',[completion date],#1900-01-01#) AND ...


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[eshaan]

Hi PHV,

It works well thank you. I have another question.

IOn the Form n combobox I entered values ( "all, dept1,dept2,dept3 ") . If user select in combobox "all " it has to print all departments information or If user select "dept1" it has to print only dept1. In department table there is no value for All but dept1, dept2 filled with values.

IF First combobox selected value "all" , second combobox selected person "lastname"

First combobox selected "dept.name" and second combobox selected value is "all"

How can i specify in query grid.

 

[PHV]

=[Forms]![form name]![dept combo name] OR [Forms]![form name]![dept combo name]='all'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[eshaan]

Hi,

I have problem for another combo box that is this values are all numbers. If user select particuler code it will print that code only that is printing fine, but how can I allow user on the form to to select all print all codes .

Also I have another combo box on the form those values are coming from table because I tried to enter values it saying It is too long. There is not choice for user to select all .
also if user select values from 2 comboboxes and user doesn't select any values from third combobox, values are not printing on the report it is printing empty.