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 Rhinorhino 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 Enigma007

  1. Enigma007

    Using Is Null in an SQL IIF criteria

    I actually just figured it out. I was using the query builder instead of the straight SQL. It was doing an: MyTable.myField = iff(...) This wont work because MyTable.myField = Is Null would naturally create errors. I encapsulated the whole thing in the IIF and did...
  2. Enigma007

    Using Is Null in an SQL IIF criteria

    Basically I have a form control that I want to use as part of the criteria. It would look like this: Iif(Len(Forms![myForm]![myText] & "") = 0, Is Null, Forms![myForm]![myText]) So, if the control is filled in I want that to be the criteria. Otherwise, the user is looking for the null...
  3. Enigma007

    Using Is Null in an SQL IIF criteria

    Heya. Quick question... If I am creating a query and I want to find all records where a field is null I could put: Is Null As my criteria. Unfortunately, if I use a IiF statement, I can't put Is Null as one of the two results of the Iif. It gives me errors. I can put Null, but Null=Null...
  4. Enigma007

    History Table - Query to find Current Locations

    Er... Nevermind. You made it even easier for me by just having to substitue my Table name. I am just an idiot trying to make it harder for myself :) Works perfectly! THanks!
  5. Enigma007

    History Table - Query to find Current Locations

    I'm not sure I understand completely. I have my location table as T1. What would T2 be in this case?
  6. Enigma007

    History Table - Query to find Current Locations

    I just realized that I posted in the wrong forum initially(Access Forms), and have now posted here. Please don't kill me for double posting! It was an accident. In any event. I have a database that I use to keep track of inventory. I am tracking the current location of each item in a...
  7. Enigma007

    History Table - Current Location Query

    Heya. I have a database that I use to keep track of inventory. I am tracking the current location of each item in a history table. The table has a unique autonumber id, a reference to the item, a reference to the location the item now resides, and a date that the item was put in the location...
  8. Enigma007

    Requesting Implementation Recommendations...

    Hehe. They do indeed expect me to perform miracles on a regular basis. I guess it is even easier to convince someone to do the impossible if he does not know what he is getting into. In any event, while I can't create a solid implementation without the schema, I am looking to gain some...
  9. Enigma007

    Problem with iif statement

    Excellent. It does indeed work PH. Thank you, everyone, for putting up with me. I really appeciate all of the help. Sincerely, Enigma
  10. Enigma007

    Problem with iif statement

    Thanks for the response :) Unfortunately, this did not make help fix the issue. Logically, it makes no sense to me. Here is the complete SQL: SELECT [3-0 Unit Purchase].ID, [3-0 Unit Purchase].[PO>] FROM [3-0 Unit Purchase] WHERE ((([3-0 Unit...
  11. Enigma007

    Problem with iif statement

    Hehe. It has indeed been a coffee induced morning. Thanks for the replies. I have never used the Nz function before, and I appreciate the introduction to that. Unfortunately, I am still running into issues displaying my entire list when I use the iif statement. I will attempt to...
  12. Enigma007

    Problem with iif statement

    Okay. To narrow down the problem. Apparently, any field that I have, if I use an iif structure, it removes the NULL values. SO: If I have my query that just displays ID and Purchase Order in [Unit Purchase], It will display all 1200 values. However, if I change the criteria in the [Purchase...
  13. Enigma007

    Problem with iif statement

    I just realized that, not only does this iif statement remove the cases where there is not a purchase order, but it also removes the cases where the supplier is listed as NULL. ANy thoughts?
  14. Enigma007

    Problem with iif statement

    Heya. I have the following relationship set up in my query: [Unit Purchase] -> [Purchase Order] I created the join such that All Unit Purchases are shown, and corresponding Purchase Orders that exist will be shown. Most Unit Purchases have a Purchase Order, but it is not necessary. Purchase...
  15. Enigma007

    Requesting Implementation Recommendations...

    Heya. I am new here as I am new to XML, and I was hoping I could find some guidance. I am in the process of implementing a system that has been outlined as follows: There are 2 databases. The DBMSs being used on both sides are unknown. At this point I have to just work on creating...
See more

Part and Inventory Search

Back
Top