Search results

More details... Obviously, I need to expand on the details so we can have a clear picture. Forget about the example I gave before. I have an Apartment table, which contains a couple of fields -- StatusID and StatusDate. The StatusID performs a lookup to a Status table, which also has a...

Maybe I wasn't clear enough... What I was saying at the end of the first post, is that this can't be handled in the SQL code. It has to be handled at runtime. Essentially, shouldn't there be an event procedure that is firing every time a new record is output in the detail line of a tabular form?

I have searched high and low for the answer to this question, and yet, nothing... I have a tabular form, which is being populated by a query. One of my fields is unbound, and is derived based upon values of a couple other fields. If my recordset is: Name Address1 Address2...