Search results

Thank you very much. I will read them, I know your articles are always informative

Oh, yes, so simple as it is. Thank you

Hello everyone, I have the main and subform that both use same table TBLPRODUCT. The subform is a continous form so that list out all products name while mainform show the product detail which is currently selected on subform. If the table TBLPRODUCT is empty, somehow the subform (and other...

is that OK with function abs here? It might return the record with greater than "textbox" input date...

Sorry to make you confused, I should correct it to "closest and smaller". The "CreatedDate" field is actually the Order creadted-date of products. Each product would have many orderIDs therefore many "CreatedDate". I want query's result with productIDs and orderdate which made before...

Hi Everyone. How to build a query that select ProductID with the closest date to a dynamic entered date (from a textbox) as picture below Please help me Thank you.

With very little db experience, this is really useful information for me. The running sums play the role of database checksum, it detects if data has been changed I am gonna redesign my table for saving calculated data.... Thank you!

I need it in both form and report, I will try your suggested technique

The Average_price and inventory BalanceQty at a point in the past dont depend on today price. So saving them to table is fine. I can save them by recordset method at the time the transaction is being proceeded. However, they are calculated values, so most ppl suggest not saving them to table, it...

Hi CJ_London I was not confident with my english, too long post may not emphasize my need. Yes, i need "average pricing" calculation scheme. I did not understand much about accounting terms, too. I am aware that the calculated value will be stored at some certain point to re-use later. However...

Looks promising, I will try it.

I am doing inventory access project, where user can trace back an item's data at any time in the past. I am trying to extract these info from ORDER and ORDERDETAIL table For example, customer randomly desires to view the info of item A in Q2 (Mar/01 to June/31) - ImportQty, Import_Amount, -...

Should I work it out with recordset method? it's likely simpler

Hi everyone, I have table/query which includes 4 fields as below picture. Intype field indicates import to or export from inventory. I want a make an extra column - Balance Qty which is actual quantity at each time. How can I make a such query? If that is hard or complicated with multiple...

Thank Agnelgp, my main_table ID is an autonumber :(, so I will not include it in the query

Thank Hartman In general it shoud be left join and right join as you suggested. Luckily, it is most likely set of ID (A) = set of ID (B) and they are both subset of table_main.

Hi everyone. I would like to consolidate date from FieldData1 and FieldData2 from 2 separated tables into Table Main. What is the most efficent solution (short execution time) to do that? I do write VBA code to copy one by one consecutively with recordset method, but I think query might be...

Yes bro, I had been noticed ealier that the "OR" operator of article is on table JOINs, while my code uses "OR" in WHERE clause (I think I have emphasized it in my first post). I was not sure about OR operator performance no matter where it is being used. Until now, from your posts I am pretty...

Yes, I have changed my VBA code, life is simpler than what i think... :)

Yes, this is simple logic AB + AC = A(B+C). Thank for saving my code