I'm querying an Excel database into another Excel spreadsheet. I have two
fields where I want users to input into the database. This input data is not
coming across in my data, even though I'm including the field.

Database:

Account Mar Apr Variance Explain Explanation
Printing 546 556 -10 Explain Printed spring catalogue

The explanation field is where the input is, everything else is a formula.
But even if I make the input data into a formula, it doesn't come across in
the query. If I make the input data a number such as 5%, it comes across,
but any text does not.

Any ideas?

Thanks,

--
Suz