Select/Union query wants a field entered, but the Select/Union queries that make it up don't

[Tom Carp]

Thanks Steve,

This system is just hobby and for personal use, but I like conforming to the "rules", even if I stay with Excel front- and back-ending Access. This is as much an exercise in learning as it is "production". I did, at one time, experiment with migrating to Access, but because of where and how the bulk of the journal data is retrieved (e.g. transaction downloads from financial institutions), it kept making sense to use a link strategy on the front end. Older journal data also sometimes changed as I worked on reporting (e.g. adding an entry in the Class field to allow for data retrieval). I also had challenges with reporting via Access. Personal accounting financial analysis and reporting lends itself nicely to Excel functions like SUMPRODUCT and INDEX/MATCH, so kept that in Excel with a link query to the Access query(ies).

[Tom Carp]

Just to acknowledge that it was a corrupted query (q1Query All). Manually recreated and the problem went away.

Thanks

[Tom Carp]

Just a quick status fyi.

Although I'm not sure converting to Access is the best idea for this use, I have started to modify file names, field names, etc. to be more compatible with Access rules.

Appreciate your comments.