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!

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

Search results for query: *

  1. rcollier5

    left join structure

    It gave me a snytax error starting at the fist count, BTW im using SQL view in MS Access...does it support all functionalities of SQL? Ryan
  2. rcollier5

    left join structure

    Thanks I really apreciate all the help, but i am getting a syntax error you see any reason why...i dont :(
  3. rcollier5

    left join structure

    Thanks,I think I understand, but can you give me an example of an entire statement, cuz im a rookie, and it still isnt working properly....heres a beter picture of what my tables look like ActivityWeekly --------------- Weekending | Facility | ect ____________________________ *all columns may...
  4. rcollier5

    left join structure

    I have a question related to this problem: I have a table with weekending dates and facilities that have submitted reports I also have a table listing every facility there is. is there an SQL statement where i can create a query listing what facilites have not submitted reports for each...
  5. rcollier5

    Combo Box Help

    thanks for the response! I fixed my porblem using an SQL statement and a hidden text box I have another question....when I select a Last Name from a combo box, it populates the First Name Combo Box, If the combo box will only contain 1 First Name for that last name how can I make it...
  6. rcollier5

    Combo Box Help

    You are doing exactly what I am trying to do... How can I use from what is selected from combo box 1 to populate combo box 2? I tried using SQL in the rowsource box in access but it does not work...can someone post some code? here is my problem specificly: *I have a form that inserts all info...

Part and Inventory Search

Back
Top