Stocknumber
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 43 articles for 0.303 sec
On Sep 11, 5:18 am, prabhu <pra...@discussions.microsoft.com> wrote: > Hi everybody i prepared a simple DB for my stocks.If the total stock is reach > 1 means the computer gives an alaram(or)msg when i open the database or that > stock table what about in the AfterInsert of your form? You could grab the StockNumber, and use Allen Browne's QuantityOnHand calculation, and return the value somewhere     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Stocknumber in microsoft.public.access.modulesdaovba
Author: pietlinden
Date: Sep 11, 2008 05:19

Many thanks, I'll give that a go! "KARL DEWEY" wrote: I assume you want to use the latest UnitCost so what you have to do is create a totals query for Table B with [Table B].[StockNumber], [Table B].[UnitCost], and Max([Table B].[UnitCost]) AS MaxOfUnitCost. Then use the query instead of Table B in the update query. -- KARL DEWEY Build a little - Test a little
Show full article (0.55Kb) · Show article thread
I assume you want to use the latest UnitCost so what you have to do is create a totals query for Table B with [Table B].[StockNumber], [Table B].[UnitCost], and Max([Table B].[UnitCost]) AS MaxOfUnitCost. Then use the query instead of Table B in the update query. -- KARL DEWEY Build a little - Test a little "thedrumdoctor" wrote: > Thanks very much for the reply, it is appreciated     

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: thedrumdoctor
Date: Aug 22, 2008 05:15

Thanks very much for the reply, it is appreciated. In answer to your questions; The UnitCost values I want to use are all in Table B and all the records in Table B have dates associated with them. I'm guessing that the inclusion of a date field will help eliminate the problem of entering multiple UnitCost values in some way? "KARL DEWEY" wrote: [Table A.StockNumber] has a one-to
Show full article (2.77Kb) · Show article thread
>>[Table A.StockNumber] has a one-to-many relationship with [Table B.StockNumber] There is a problem in trying to do what you want. The will be some StockNumbers that have multiple UnitCost in Table B. Which UnitCost is to be used? Do you have dates associated with the records in Table B? This would be the SQL if you did not have the problem --- UPDATE [Table A] INNER JOIN [Table B]     

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: KARL DEWEY
Date: Aug 20, 2008 07:59

You were right, I did have a typo. Current_Veh_Location should have been Current_Veh_Loc But I corrected that... and I still get the same error message. I'm so close!! I'm Googling for answers, but everything I find points to typo errors. I've looked very closely at the query and find none. Any other recommendations would be greatly appreciated. "Michel Walsh" <vanderghas
Show full article (2.57Kb) · Show article thread
I have a followup question: I didn't explain the table and field names correctly, but I could figure it out from what you wrote. This is your query with the corrected table/field names: UPDATE Products INNER JOIN All_Locations ON Products.ProductStock=All_Locations.Stock_Number SET Products.Actual_Location = All_Locations.Current_Veh_Location WHERE Products.Actual_Location IS NULL; But     

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: thedrumdoctor
Date: Aug 20, 2008 02:21

What is the purpose of the last line? Is it stating "where" that field is blank? And if it isn't blank, do nothing? "Michel Walsh" <vanderghast@VirusAreFunnierThanSpam> wrote in message news:exF9h1WAJHA.4148@TK2MSFTNGP05.phx.gbl... UPDATE tableB INNER JOIN tableA ON tableB.stockNumber = tableA.stockNumber SET tableB.Location= tableA.Location WHERE tableB.Location IS NULL
Show full article (2.11Kb) · Show article thread
I’ll try and simplify this by only including fields from the tables in question which are relevant to the query I want to perform. First of all, I’ll start with Table A: Table A StockNumber (PK, auto number) UnitCost (Currency) Table B StockNumber (Number) UnitCost (Currency) [Table A.StockNumber] has a one-to-many relationship with [Table B.StockNumber] At the moment, [Table     

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: KARL DEWEY
Date: Aug 19, 2008 07:45

I now know how to update a field, with text such as "record found", based on the contents of another field. I use something like this: update tableb,tablea set tableb.blankfield = "found" where tableb.stocknumber = tablea.stocknumber But I need to do something a little different, and I can't figure out how to do this: I have a file with a link to a table in another file. And just as
Show full article (1.66Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: JohnB
Date: Aug 19, 2008 07:28

Show full article (2.94Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: JohnB
Date: Aug 19, 2008 05:56

Show full article (2.14Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: JohnB
Date: Aug 19, 2008 05:48

Show full article (1.63Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: thedrumdoctor
Date: Aug 19, 2008 05:00

Show full article (1.02Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for Stocknumber in microsoft.public.access.queries
Author: JohnB
Date: Aug 18, 2008 12:30

Show full article (0.85Kb)
1 · 2 · 3 · 4 · 5 · next