Search results

Hmm that one seems more doable. I normally program in java but vba seems piece of cake for that. I will try that and let you know if it worked. Thanks again

Hello, I have a report connected to a query. That query has an expression column that concatenates several fields. 1 memo and like 8 text. As you understand concatenation causes characters beyond 255 to be truncated since access treats them as text during the concatenation and not as memo. I...

In my subform I put it to show my query which includes the calculated values I want. The answer I guess was way more simple than I thought. But are you sure that its more of a waste to store a number in a field instead of having computer to calculate 100.000 records every time? [this post...

So I guess I lied about spending hours searching in various forums. Anyway I did have a query that was summing up the Exports and Imports for each item and also had an Expr1 subtracting exports from imports and each Item from the parent field had its correct amount on the Expr1: column. Problem...

Hello everyone. I feel that this might be common but I browsed around the net for hours and didn't solve my problem. I'll cut to the chase. I have two tables. Parent and child. Child table keeps records with quantity on 2 fields. One field is for imported quantity and one field for exported...