Hello,
I am trying to use an access database to convert .xml files with a bunch of tables in them into a flat file with just one line of information to export to a real database. My plan is to use a bunch of queries (when there is more than one line) to pull data and then query the queries to get everything onto one master table.
for one page of fuels there will always be one line for electricity, sometimes one line for natural gas, and sometimes one line for an additional fuel. when the natural gas or third fuel is not there then the query comes up blank which totally kills the master table.
query one: criteria electricity
query two: criteria natural gas ( but needs contingency for null)
query three: not "electricity" and not "natural gas" (this needs a contingency display for null, and possibly a contingency for if there is not any type of third record in the table at all - does this count as null or something else?
i have been trying to nest iif and isnull statements but cant get it to display a word if there is no match. Also am a little confused as to whether it is better to put the expression in the field or criteria boxes.
I really appreciate any help either on the specific question or advice on the overall strategy.
Sincerely,
Alex