How to create this query??

[nate0057]

Hi, I'm a french student so pardon my english!

In a report VBA sheet I used flag like that :
'set flag textbox as value of table and catch null value by Nz
flagconp = Nz(DLookup("[CONP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0)
flagblup = Nz(DLookup("[BLUP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0)

In the design view of this previous report I needed to put one text box for one requirement (flagconp issthe flag for the control plan's requirement, etc)
to retrieve the definitions of the flags.
It's work but it's strange.
Someone told me to create a query but I don't know how program it because I'm a begginner. Could you help to program the query??

Thanks a lot.

 

[jdraw]

What exactly is the purpose of the query you want help with?
What is the query for?

 

[nate0057]

I had to define some flags in a report sheet (the code).
When I launched the program, he said to me that he can't retrieve flag's definition. So in the design view, I had to add one texbox for one flag. ( just to retrieve their definition, I hid them).

It's work, but it's not so conventional. So someone told me to use a query to sub for that!

 

[jdraw]

Whether you use a query or vba or functions or flags is Not really the point. In plain English or French WHAT is it you want on your report?

A report is an output mechanism to display data that you retrieve from a Table or tables either directly or via queries and possibly some additional processing. What data do you want on your report?

 

[nate0057]

I have to retrieve the definition of the flags.
I defined all the flags in a code sheet. I added one texbox for one flags in the design view of this sheet.

For exemple: Now I erase the listbox of the blueprint's requirement. When I launch the program, he says to me blueprint aren't defined.

I'm looking for another method to retrieve these data. Maybe it's not with a query, I don't really know.:banghead: