Recent content by ludakrishna420

  1. L

    SQL Popup in Access

    The following is the Code i have in Access in SQL. I've just started to learn it and wanted to see if anyone could help. All of the code works to perfection like it should. however, i wanted to know if it was possible to have a Code which would ask for two numbers in the beginning and would...
  2. L

    Yet another question but i promise that it will be the last.....for a week

    That is exactly what i want to do but at a company like Boeing, change is never welcomed easily.
  3. L

    Yet another question but i promise that it will be the last.....for a week

    Actually, i already have a database with all those tables in it already. They are already named and the only difference between each of them is the first three number. Besides that, they are identical down to the column headers. I just wanted to create a query which will ask for the first the...
  4. L

    Yet another question but i promise that it will be the last.....for a week

    1 query for multiple tables. So i have just completed my database and everything works fine. Now, my managers wants me to go back and do it again for other internal companies. Mind you that we have over 100+ and i am not in the mood of going through and doing something that is not my job...
  5. L

    Concatenate and LOOKUP help…

    Got it to work.
  6. L

    Concatenate and LOOKUP help…

    If i could, it would put up the tables but they are proprietary info. Bust essentially, i want to run a vlookup in access. I'll try your suggestion. Thanks.
  7. L

    Concatenate and LOOKUP help…

    Thanks for the help, i got the 1st part done and you were right, i just needed to reference the group, however, the second part stopped to work now. This is what i have entered. This query lookes into multiple tables and then gathers the data that is incomplete and presetns it to you. The...
  8. L

    Concatenate and LOOKUP help…

    Here’s my goal. 1.) I have one column and want to add a 633 in front of if. a. Expr3: "633 " & [Grp] & "" b. This only shows 633 and asks for an entry for the GRP? Why? I want the format to be 633 xxx. If I do add, lets say, 123 in the popup, all of the columns are 633 123. 2.) After...
  9. L

    IFF Help

    that's the exact same thing i've had people telling me. I guess i will just buy a BIG umbrella and tough it out during the gloomy months of the year which unfortunately are all months except june july and august. Thanks alot for the help. And btw, i have relatives in Sacramento and they says...
  10. L

    IFF Help

    I know that this may be getting a bit personal but i just have a quick question. What do you like better, IDS or Boeing Commercial airplanes. I currently have an offer to go to IRVINE for Defense with a Pay of $79000 or stay in Seattle with a pay of $70000. I don't know if the extra 9000 is...
  11. L

    IFF Help

    I am actually from Portland but currently @ at internship with Boeing in Seattle.
  12. L

    IFF Help

    WOW, i can't believe i didn't try that before. Thanks alot Bob. Its kind of ironic i got help from a fellow Oregonian.
  13. L

    IFF Help

    I am currently a newbie when it comes to Access but I am really proficient with excel. I have been given the task to update our query in a database in which everything that is blank has the work "empty" in the field. I get the entire query to work but can't get the iff statement to work. I...
Back
Top Bottom