Recent content by nicksource

I've tried in the "Qty" form field on After Update to do: [Qty]*-1 but it doesn't change it. I've also tried just *-1 But it comes up with an error, basically just want to to turn the value I've entered in that form field into a negative for when it inserts into the table.

Thanks guys, I'm pretty much fixed with the DB design, having stock in/out in one field then (out being negative, in being positive) then running a SUM. But I'd like it so in the "Stock Out" form, when I enter it as a number, it converts it to a negative, so I don't have to put the minus sign...

What are the other methods? I can't get this to work. Me.txtQuantity = Me.txtInput*-1 Also tried: [txtQuantity] = [txtInput]*-1 Just doesn't like it in After Update (doesn't update the field).

Thanks Neil & Dave, all I want to do is make it as simple as possible. The most important feature would be the end user being alerted when stocks are low. I was wanting to have on the startup screen a list of products that were near or below the minimum stock level field. Hopefully this new...

But how do I make it a negative? When I enter a number, it's always positive, I guess I have to put the minus in before the number but is there anyway to automate this? I have 2 forms, 1 for Goods In and one for Out.

Thanks a lot guys. I want to do it the easiest way possible, which I think is a single field like you both described. But how do I do the +/- of a field? Is it with a SQL query or something?

Goods is a table. In and Out is a number field to store the stock out/in.

I've nearly got it, I've done this query to list low stock items which works but... it doesn't group the products (by Product.ID). I've tried doing GROUP BY Products.ID but it doesn't work, comes up with an error about an aggregated function. SELECT Products.ID, Products.Product...

Ahh, yeah, that's easy enough. What would the calculated field look like? How would I set that up?

Hi guys, I've made a stock control system, which basically has a "Stock In" and "Stock Out" tables, then using a DSum it calculates the stock level. So it isn't actually storing the stock figure. I have a field for the products that's called "Minimum Stock" - which is simply the level the...

Hi guys, hope all are well. I've tried searching and experimenting but I just can't seem to find a solution. I have several rows on my Continuous Form, I simply wish to have a Combobox, to filter the Form by the fields A-Z or Z-A and so forth. How do I do this? Thanks in advance, Nick.

Thanks, I see the GROUP BY in the query but do not understand what the SUM and COUNT are required for? Here is my query, I wish to group by DateOut: SELECT GoodsOutJob.ID, GoodsOutJob.JobID, GoodsOutJob.DateOut, GoodsOutJob.Reserved FROM GoodsOutJob; Could you explain the SUM and COUNT...

I have a form that has a sub-table in it, it lists loads of dates and the job the goods were sent out to from a table called GoodsOutJob. Under each row, it then lists (using another sub-table) all the products from the GoodsOutProd table for that job/date - with this I can expand and collapse...

If you have something that would help me I'd appreciate it.

I think I understand, I put the expression in the SQL (QBE view) as you have said, then added an existing field to my form, which was this expression, however I get this error: The IDa field is in the form, the expression works fine anywhere else, just not through the SQL so it seems. :( I...