consultation with field for multiple criteria

[fabiobarreto10]

Gentlemen,


I have a subform with the following fields: name of the step, the scheduled date, place and date rescheduled date. I'm having trouble making a statement in a query
that has the following criteria: need to know what the step is smaller than today's date between the date scheduled and rescheduled date and the date performed without value.
if there are any other dates scheduled and rescheduled less than today, I need to know only the name is the first step with the date due.
I think I need to create a field in the query to the term, but I'm not getting. Any help is welcome. Thank you.

 

[NickHa]

need to know what the step is smaller than today's date between the date scheduled and rescheduled date and the date performed without value

Can you provide some context to your question and provide sample data, please? I don't understand what "the step" means and there is no indication of its data type. How is this related to the dates?

 

[fabiobarreto10]

Thank you for responding, for help. I'm trying to make an appointment to make a report
by each assessor.
I have a form where there is a comboBox with the names of advisors. After selecting a name, I'm trying to
open a report with all the companies and products, and won every step of their product. the difficulty
I'm finding is this: for example, may have one or more steps losers, I just need to know
first step is unsuccessful, according to each product and their company's advisor.
I need to have a field in the report (or query, then use the report), with the date of the step
is unsuccessful, the date can be scheduled or rescheduled date. If the date field is populated place, the
step is ok. Sorry for not having prepared better. I am sent images that may facilitate the understanding of
my problem.

Again thank you very much.

 

[NickHa]

I still don't understand what you are trying to do. I have studied the images you posted, but even with the explanations, I can't decipher the part which relates to your original question. It doesn't help that I don't understand the language on the form (sorry ).

I'm having trouble making a statement in a query that has the following criteria: need to know whatthe step is smaller than today's date between the date scheduled and rescheduled date and the date performed without value

Can you define what you mean by a 'step', please? Is this a workflow step or something else?
What is the field type for step - your question above implies it is a date?
Is [date scheduled] always in the past?
Can [rescheduled date] be in the future, as well as past?

if there are any other dates scheduled and rescheduled less than today, I need to know only the name is the first step with the date due

What does this mean? What other dates are you referring to?
Do you have a table of steps which provides the names - if so, is this in order of execution (if it's a workflow)? I can't open your DB, so couldn't look at the tables)

 

[fabiobarreto10]

Nickha, Sorry for being slow to respond, was having problems in my broadband.

Actually my problem was a bit complex, but managed to solve by making three appointments, one from the other.



I appreciate the help and attention, I will mark as resolved.

Again, thank you.