Search results

Thank you very much Alan for your assistance. Really appreciate what you've done :)

the problem is i have 2 source txt files that is updated regularly for my IN and OUT shipment that's why i have the NGK IN and NGK OUT tables. Would this be a problem using the modified DB you created for me?

Hi Alan, Thanks for spending your minutes to do this. Question for you.. 1. If I run Query5 to make the NewTable, the RecordID will disappear since it will overwrite it every time you run Query5. 2. Can we show the DATE OUT table and the PALLET OUT table separately in the NewTable? I guess...

Hi Alan, Sorry I made a mistake in my post. I was able to insert an new COLUMN named ID on both NGK-In and NGK-OUT tables. However, on the FINAL table, the new column ID is removed when I run the NGK FINAL INVENTORY query to create this table. Kindly see my update DB in this post. TIA!

Hi Alan, My problem now is i can't create a UniqueKey in my tables. My source data is a TXT file and I'm just running a TransferText macro to create these tables. Hope you could check my DB if you have time. TIA!

oh ok.. i saw it already thanks!

Hi Alan, I tried opeing your checkbook DB but it is like in Form type only. I can't see any query in the DB. thanks!

Thank you Alan. I will try to work on it. Appreciate your help.

Hi Alan, Thanks for your inputs. I will restructure my DB based on your recommendation. So basically, in my qryRunTotal query, it would call only 1 table with unique identifiers as an additional column? would this be a sort of ID number (AutoNumber)? TIA!

Hi Alan, I'm woking on the qryRunTotal query to make a new BALANCE Column from the QTY in and QTY OUT columns. I've also posted the snapshot of the results I want to achieve in my first post as well. Thanks a lot for your time.

Hi Alan, Thanks for your reply. I really have no idea on how to apply this in my qryRunTotal query. Will it do the add/subtract function in my 2 columns to create the running total? Would you be able to look at my DB? Thanks a lot!

Hi guys, I'm really new to db programming so please bear with me. I need to add a new column (named BALANCE) in my query to sum/subtract my existing 2 columns namely QTY IN and QTY OUT. Attached is a snapshot on what I have in excel using the formula =SUM(A1,-B1) in the 1st row then on the 2nd...

in the query output, it shows the complete contents of the field (261 characters) but when I export it to excel, the contents was stripped down to 255 :(

actually the CONC query we made will just be exported to and excel file. I will not use any form..

sorry.. can you point me where to set this up? thanks!

Hi vbaInet, its me again... I'am being hit by the 255 character limitation bug in the ConcatRelated module. I know there is a workaround using a UNION query.. do you have any idea how to apply this in my requirement? TIA!

oh man!!! I can't thank you enough for your time and effort.. :):) all is working as required! can't believe you hang on this long to help me... :) thanks a lot!!! :):)

ok fixed that :) one last thing.. how can I now show the COUNTS? in this case line 2 should have 2 COUNTS instead of 1..

wow it works!!.. however, the output seems to be incorrect. the output doubles in lines 2 and 3? also, since I called the origTable in this new query, what is the role of the qryTotal wherein I need the summarized count as per my required output. DATE | FIELD1 | FIELD2 | COUNT | Expr1...

I was hoping you will say that :) here it is.. I'm working on the origTable and qryTotal to get my required output. really appreciate all your help...