Recent content by Glenn Lieding

Another "handy" feature of the Query Builder is that if you unclick "Show" on a field expression, once you save and close the query Query Builder will delete the field expression "for you". However, it does this even if there is another, SHOWN field expression that depends on the value of the...

I think you found the crux of the problem -- the calculated fields are not defined in the SQL when the Query is converted to an Append Query. But I didn't write any of this SQL. Access did. I still think it's an Access bug!

What else do you find difficult about the naming convention -- the underscores? Matter of opinion. In the SQL, probably.

Thanks. It's hard for me to read, too. I'm not an SQL jockey. I'll try your suggestions. I was doing the step-by-step method as I build the Select Query, assuming it would still work as an Append Query. It doesn't really make sense as an Append Query until all the pieces are in place. But...

I was hoping to spare you the details. I'm just using Query Design in a fairly straightforward way and not customizing the SQL. The Select Query SQL is: PARAMETERS [Primary_First_Name] Text ( 255 ); SELECT First_Name_Usages_1.ID AS First_Name_Usage_ID_1, First_Name_Usages.ID AS...

Access (2013) consistently crashes when using Query Design. I have discovered a workaround: Always save and close the Query you are editing before running it. Never run it directly from Query Design (the Run! menu item or Datasheet view). A little bit of a hassle, but a lot better than...

P.S. I'm using Access 2013 Preview. Do you think this is an Access bug? (I think so!). Maybe it works in earlier versions?

Not exactly the same issue, but I have a similar (but simpler) problem where Access produces different results depending on the mode in which a Query is run. In my case, calculated Field expressions do not work in Append mode. Please, anybody, help me on my thread: showthread.php?p=1230863 Thanks!

I have a Query involving calculated Field expressions that works fine in Select mode but not when run as an Append Query (without any other modifications). When run as an Append Query, Access treats the fields as parameters and asks for their values (and then delivers incorrect results, of...

It still looks like garbage.

I'm an experienced programmer, have worked with other databases before, but am relatively new to Access. I like it a lot -- most of the time. Sometimes it seems to do anomolous, buggy things that I don't understand :banghead:, so I thought this might be a good place to get some help with that --...