Search results

Of course! It seems so obvious now... Pat, Thank you again for your time.

Storing a parameter? (sorted) Hello, I am designing a query as i have been advised in the following Quote: Doc Man I am able to get "inventory of X at archiving date" and append the results to a temporary table but I can't see how to append the "archiving Date" data itself to the same table...

Thanx, The purpose of the queries would be archiving the inventory and keep only relevant data in the dB. The actual inventory amount becomes stock on hand transaction (All transaction prior cut off date) + sum of all subsequent transactions. Then archive tables can be backed up by exporting...

Hi ScottGem, Thanks for your reply, I did change the field 'name' and 'date' as you advised. For the method I am using for stock on hand i am not entirely sure as for the above example I have been following advice from an other experienced user: Quoted: Query #1 - Compute stock on hand as of...

Hi, In the example attached below how can I see the "cut off date" that I am prompt to enter in the fourth field of query1-a (I would like to see it for each one of the record that are displayed when the query is run and then append it to a table) Cheers,

Thank you very much Doc man I am really gratefull. This will be really helpfull and I am gonna try to see if I can use such a system to my needs or maybe adapt it in the way I want. However, What i meant by the quantity declared was the quantity declared on the Supplier delivery note; you see we...

Hi, I don't want to abuse anybody's patience but I have yet a couple of other quick question about transaction table. I am using a summation query for the stock on hand where by keeping it simple: stock = sum of movement in the table. What hapens if a simple function is used to...

Hi, Well, Ithink that you need to be sure that your new text box is bound to one of the field belonging to the table or query linked to your form. In the properties of your text box, go under Data, Control source and click the drop down arrow on that line, then choose the field. if the field is...

Thanx Pat,

Since the latests post I have received from The Doc Man, Pat Harman and ScottGem I have been spenfding a lot of time on stock, really interesting and challenging indeed. (Thanks very much for the advice) I've design a database with a working transaction table. But by using this method, there...

More stock confusion After the post by Scottgem I' ve been spending a large amount of time looking at Stock control, Inventory and transaction table and now feel a bit confused (an other one...). If I used a transaction table, I need to use one record for one stock movement. I...

Hello, I have been struggling to see on a new form data calculated on a different form. What I mean is that I have calculated a stock balance using a subform where the balance=[QuantityReceived]-NZ([Stock record table Subform].[Form]![SumQtyIssued]) Now, I woud need to see the balance value...

Superb! Merci a toi Newman et vive le Quebec!

This is a code I used for a stock control form: "Balance" =[QuantityReceived]-[Stock record table Subform].Form!SumQtyIssued It is just a simple substraction between a record from a field and a sum of records from an another field contained in a subform. The code is working fine apart for the...

Thanks for the advice, I just realised that I was thinking totally in the wrong way. Now that I look at the way I wanted to do the Calculation I almost feel embarassed. Thanks again, PS: Sorry for the double post, I didn't mean to do that. I also think that the "need, help please" is not...

Thank you very much, This will be very helpfull.

Hello, I have been learning how to use Ms Access in order to design my own Database, I have done quiet a bit but i found myself kind of stuck witth the following issue. My question is pretty simple (I think…) Please, can someone help me? :o I need a field that update itself automatically for...