Recent content by Enigma007

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...

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...

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...

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!

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

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...

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...

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...

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

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...

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...

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...

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?

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...

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...