Search results

Thanks for your reply. Could you mind elaborate a little bit more as I cannot get it work

How to hide main report if there is no data in the subreport?

Try to add a code to after update event Me.Requery

Hi all I would like to default the subform go to new record when the main form is opened. How can I do this? Thanks in advance

Thanks for the reply. How to do auto-allocation? Use VBA or a query?

I would like to know how come is the "X" in the [qryAllocation]? And also the meaning of field [LotID]? Because I'm quite new and know little about Access. Any help will be highly appreciated. Thanks in advance.

I'm a newbie to Access. Can you explain in detail?

Thanks, I've got some idea. The cause of the problem is due to the result of [A] & [B], it should be value, not text. Thank you for your kind help

But my result of [A] & [B] comes from the result of query. I have tried to change the data type to numeric, but it doesn't work.

Thanks stopher, the information is very useful. But I still cannot get the return I want. I would like 100(column A) + 200 (column B) = 300 (new column). I have tried to C: [A]+[B], but the return result is 100200. I have formatted [A] & [B] in numeric. Is there something wrong with my query...

Hi, I'm a newbie to Access. I have created a query showing the result base on other calculation. The returned results are in numeric. I would like to know how to sum up the returned results on row to a new column. A b new column 100 200 300 200 150 350 Your kind...