Register to reply

Consultation with field for multiple criteria

by fabio2012
Tags: consultation, criteria, field, multiple
Share this thread:
fabio2012
#1
Feb24-12, 07:48 PM
P: 2
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.
Phys.Org News Partner Science news on Phys.org
New model helps explain how provisions promote or reduce wildlife disease
Stress can make hard-working mongooses less likely to help in the future
Grammatical habits in written English reveal linguistic features of non-native speakers' languages
jtbell
#2
Feb24-12, 10:30 PM
Mentor
jtbell's Avatar
P: 11,594
Which database / programming language / development environment / whatever are you using?
fabio2012
#3
Feb25-12, 12:01 PM
P: 2
Thank you for responding, for help. I'm using access 2007. 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.
http://dl.dropbox.com/u/53793430/Desktop.zip
Again thank you very much.


Register to reply

Related Discussions
Generalise the magnetic field of multiple current loops Advanced Physics Homework 5
The field due to multiple concentric solenoids with water Advanced Physics Homework 1
Electric Field due to Multiple Point Charges Introductory Physics Homework 1
Calculating the electric field, multiple point charges Introductory Physics Homework 10