how do i set order in a multiple parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a multiple parameter query and sometimes the parameter value i have
overrides the parameter value in another field. for example--my query will
pull up job numbers for dates outside my range of dates i selected. (job no.
is also a parameter value). i've worked on htis for hours, can anyone plze
help?

thanks so much
--
 
A parameter applies only to that field. If you have a date field (formatted
as a date), and you enter as the criteria: Between [Start] And [End], you
will be prompted for start and end dates when you run the query, or when you
open a form or report based on the query. How are you entering the
parameters? Are they built into the query, or are you prompted to provide
them? What parameters seem to be overriding other parameters?
 
my parameters are entered through a form. i have a txt box for beg date and
end date. i have a combo box for job no. when i put --like
[forms]![formname]![controlname]&"*", the dates are correct but any records
that have no entry for job no (null) do not show up. if i put the above
criteria in the query and then --or is null--it gives the right jobs for the
right dates but it also gives all the null records for dates other than what
i had entered

any ideas? i've tried all kinds of combinations for the criteria in the job
no field

thank you
--



BruceM said:
A parameter applies only to that field. If you have a date field (formatted
as a date), and you enter as the criteria: Between [Start] And [End], you
will be prompted for start and end dates when you run the query, or when you
open a form or report based on the query. How are you entering the
parameters? Are they built into the query, or are you prompted to provide
them? What parameters seem to be overriding other parameters?

turkey said:
i have a multiple parameter query and sometimes the parameter value i have
overrides the parameter value in another field. for example--my query will
pull up job numbers for dates outside my range of dates i selected. (job no.
is also a parameter value). i've worked on htis for hours, can anyone plze
help?

thanks so much
Click to expand...
Click to expand...
 
i almost figured it out (maybe). i put the same criteria i had for date and
i copied it into the date "or" criteria section. it works great if i want to
pull up all the entries for certain days. if i input a job no., then it
pulls up all of the records that contain that job# AND all the records that
have blank job #'s for the dates needed. my hair is falling out. is there a
good page that anyone knows of so that maybe i can learn more about criteria?


thank you soooo much,
crazy in indiana
 
Back
Top