Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by amauricio2

  1. amauricio2

    Is this possible

    Well I guess my question is really can I put it into another query, remember that was just one field in a query, if i run the SQL it does the job now i just need to make it a field this is what I believe it to be something like for the field: NewStatus: (SELECT MZtest.[DISPLAY LOCATION]...
  2. amauricio2

    Is this possible

    Thank you Duane for the direction I really appreciate it, Remou your suggestion was PERFECT, now what I need to know from either one of you would be how to Nest, include, add to my bigger query??? Thanks guys
  3. amauricio2

    Is this possible

    good question and GREAT ANSWERS but if you will notice I am merely a novice at this don't know where it would go.. .In the query or the code and then where would i put it and how. Thanks alot Remou I really appreciate your help on this
  4. amauricio2

    Is this possible

    attachment now includedhttp://www.box.net/shared/ieav4uxs31
  5. amauricio2

    Is this possible

    ok sorry for submitting too early without sufficient info, but here goes I uploaded a sample of the query are you able to look at it? The fields are in the upload have the field currently in my DB Actually the post 11 Dec 08 11:47 does have actual data to the right and i am just wanting a way...
  6. amauricio2

    Is this possible

    DISPLAY LOCATION REQ ENDCAP REQ SIDESTACK REQUIRED RANKING DISPLAY STATUS wine endcap 1
  7. amauricio2

    Is this possible

    I have this in a query but it wasn't not working only because I need to add one more thing a criteria, I need the Display_Status to look at another field called Display location where one of these fields names is located and then run the comparison based on the field. so for example: "Ranking"-...
  8. amauricio2

    Is this possible

    ok here goes I uploaded a file to better assist. I am using a query called BDMSSQBS and the end result is the report called ZZPlanner_StoreNEW the table is called MTCQ, The Display Location will decide which field to compare to the Ranking field. Does that make sense? and thanks for even trying...
  9. amauricio2

    Is this possible

    ok I will start by stating the I already know that the table structure is all wrong,I know. So here goes masters. I have a query that would like to have a create query field evaluate field data in a field called "Display location" then I would like based on the content of Display location field...
  10. amauricio2

    problem running Macro

    That did it!! I can't believe it thanks alot you solved more than just the problem I initially had, Thank you very much MakeItSo
  11. amauricio2

    problem running Macro

    Allright I tried that I am am not quite getting. So let me tell you what the tables and fields are and maybe you can help me on this one MakeItSo. First I am populating a Demographic form with all demographic information to include a Social. So from the Command click the macro runs to create a...
  12. amauricio2

    problem running Macro

    No all the Command does is run the macro to open several forms then sets a value to create a new record in each form, the Macro closes the forms and returns to the original form. So I am not designing anything just populating data. hey thanks for replying, I really appreciate it.
  13. amauricio2

    problem running Macro

    Hello everyone this is my first time up to bat, and I hope someone can help.... please. I have users clicking a command button that runs a macro that populates several tables with a Social, no problem but when I have multiple users I get this message "You do not have exclusive access to the...
See more

Part and Inventory Search

Back
Top