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 bkrike 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: *

  • Users: Enigma007
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...

Part and Inventory Search

Back
Top