How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
44910485
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I have an MS access query where the inputs are from a form

Customer Question

I have an MS access query where the inputs are from a form but when I put criteria in there via drop down boxes...it runs and pulls the data for the first 3-4 where statements but then will not pull the rest of the criteria SELECT [Trans Rvsd6292017].emplid, [Trans Rvsd6292017].gender, [Trans Rvsd6292017].dob, [Trans Rvsd6292017].name, [Trans Rvsd6292017].stint, [Trans Rvsd6292017].effdt, [Trans Rvsd6292017].record_type, [Trans Rvsd6292017].hire, [Trans Rvsd6292017].term, [Trans Rvsd6292017].jobchange, [Trans Rvsd6292017].prom, [Trans Rvsd6292017].promtype, [Trans Rvsd6292017].storechange, [Trans Rvsd6292017].ratechange, [Trans Rvsd6292017].demotion, [Trans Rvsd6292017].statuschange, [Trans Rvsd6292017].jobcd, [Trans Rvsd6292017].hrlyrt, [Trans Rvsd6292017].logo, [Trans Rvsd6292017].city, [Trans Rvsd6292017].state, [Trans Rvsd6292017].dm, [Trans Rvsd6292017].vpro, [Trans Rvsd6292017].vp, [Trans Rvsd6292017].class, [Trans Rvsd6292017].code, [Trans Rvsd6292017].reason, [Trans Rvsd6292017].store, [Trans Rvsd6292017].emptype
FROM [Trans Rvsd6292017]WHERE ((([Trans Rvsd6292017].gender) Like "*" & [Forms]![Open Job History Search Form]![gender] & "*")
AND (([Trans Rvsd6292017].effdt) Between [Forms]![Open Job History Search Form]![txtstartdate] And [Forms]![Open Job History Search Form]![txtenddate])
AND (([Trans Rvsd6292017].record_type) Like "*" & [Forms]![Open Job History Search Form]![Record_Type] & "*")
AND (([Trans Rvsd6292017].promtype) Like "*" & [Forms]![Open Job History Search Form]![promtype] & "*")
AND (([Trans Rvsd6292017].jobcd) Like "*" & [Forms]![Open Job History Search Form]![jobcd] & "*")
AND (([Trans Rvsd6292017].logo) Like "*" & [Forms]![Open Job History Search Form]![logo] & "*")
AND (([Trans Rvsd6292017].city) Like "*" & [Forms]![Open Job History Search Form]![city] & "*")
AND (([Trans Rvsd6292017].state) Like "*" & [Forms]![Open Job History Search Form]![state] & "*")
AND (([Trans Rvsd6292017].dm) Like "*" & [Forms]![Open Job History Search Form]![dm] & "*")
AND (([Trans Rvsd6292017].vpro) Like "*" & [Forms]![Open Job History Search Form]![vpro] & "*")
AND (([Forms]![Open Job History Search Form]![store]) Is Null))
OR ((([Trans Rvsd6292017].store)=[Forms]![Open Job History Search Form]![store]));
JA: What programs and versions are you using?
Customer: MS Access 2016
JA: What is your ideal outcome? How can we solve this for you?
Customer: I need it to query based on all the and statements
JA: Anything else you want the programmer to know before I connect you?
Customer: no that is it
Submitted: 2 months ago.
Category: Programming
Expert:  George Sibiya replied 2 months ago.

Hi,

Welcome to JustAnswer and thank you for utilizing our services.

I will be analyzing your query and will post back

Regards,

G

Customer: replied 2 months ago.
George I am needing this for a project that is due today.. Is it possible to solve it?
Expert:  George Sibiya replied 2 months ago.

It is. Is it possible for you to export the "Trans Rvsd6292017" into excel and share?

If not I can still try to test with the blank one that I have created.

If its shareable you may also advice if you'd rather share it privately via mail

Customer: replied 2 months ago.
Sorry I cant share it is proprietary data with personal info
Expert:  George Sibiya replied 2 months ago.

Ok no prob I'll update you when done

Customer: replied 2 months ago.
Thank you!
Expert:  George Sibiya replied 2 months ago.

Just a quick one, what are the datatypes of the fields used in the criteria? , i.e,

gender, txtstartdate, Record_Type, promtype, jobcd, logo, city, state, dm and vpro

Customer: replied 2 months ago.
We missed the deadline. I had to turn it in.