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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.