I tried to make a query in query designer. When i tried to add a table/query, access tried to execute the query! It also prompted for [forms!Myform!text1]. On typing in some data....the acc freezed (not responding) and I had to shut it down. This is so weird! I closed the application, import all objects into new one and still the same. Sth must be bodering acc on the application level... But I don't know what?
Just a bit of a history!
Today I was exploring UNION queries, Data definition and pass-through queries...actually nothing special beacuse I am working on the reporting scheme...
I tried to add a CROSSTAB QUERY and it should be run in order to get the attributes...
access does not execute the crosstab and it does not prompt an error or warning (sth like "You can't add a crosstab query!")
definetly should not freeze!
Ok, this is for now. And now I must explore in detail how this crosstab query work...
This is what I hate with Microsoft...you must read all the details in order not to make a mistake. First major mistake I made in excel with LookUp function. It sounded perfect for me. I implemented it...but you that know the returned value for a2 from table
Now think, that the price for a2 is 10$ and a1 is 4$...