Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Create update query for remaining records in microsoft.public.access.queries
Started 4 weeks, 1 day ago by accesshacker
Need to create an update query that will add records to a table that when summarized equals the amounts in another table when compared. I know how many units I need to add, the problem comes in when I need the update query to not over allocate the units. Basically, in one table I know I have one record that shows 20 units that I need to...
Site: Discussions in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile
Forum: microsoft.public.access.queries  microsoft.public.access.queries - forum profile
Total authors: 2 authors
Total thread posts: 7 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

KARL DEWEY replied 4 weeks, 1 day ago
Post the table name, field names, datatype, and sample data. How do you expect to allocate 20 into 39? 5 into 39? -- Build a little, test a little. "accesshacker" wrote: > Need to create an update query that will add records to a table that when > summarized equals the amounts in another table when ...
Size: 1,517 bytes
Customize:  Customize "<b>Reply 1</b>: Create update query for remaining records in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

accesshacker replied 4 weeks, 1 day ago
Table #1(ALLOC_UNITS) Table #2(ITEM_ALLOC_TEST) Fields/Type Fields/Type Deal – Text Deal – Text PO# - Text PO# - Text Item – Text Item - Text Units - Number SN – Text Remain – Number T_TYPE – Text Rank – Number TALLOC - Number Data Table #1 Deal PO # Item Units REMAIN CARO ...
Size: 3,576 bytes
Customize:  Customize "<b>Reply 2</b>: Create update query for remaining records in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

KARL DEWEY replied 4 weeks, 1 day ago
>>Currently, it populates all 21 with 1. I do not see anything populated with one. What field(s) in table1 gets reduced to zero? Units or REMAIN? What field in table2 has a quanity from table1 add to it? -- Build a little, test a little. "accesshacker" wrote: > Table #1(ALLOC_UNITS) ...
Size: 4,319 bytes
Customize:  Customize "<b>Reply 3</b>: Create update query for remaining records in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

accesshacker replied 4 weeks, 1 day ago
The query I have been working on is populating the 1. No fields are being reduced to zero. Table #1 is only a holder for what is remaining. I am testing right now and only using one Item from one PO#. There are a total of 1,753 items across several PO#s. I have allocated the majority of units and in some instances still have some ...
Size: 5,592 bytes
Customize:  Customize "<b>Reply 4</b>: Create update query for remaining records in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

KARL DEWEY replied 4 weeks, 1 day ago
>>I was trying to add the 1 in the query until it equals the 20 and then stop. What field in table 2 is it being add to? How about posting the SQL of your query. -- Build a little, test a little. "accesshacker" wrote: > The query I have been working on is populating the 1. No fields are being >...
Size: 6,411 bytes
Customize:  Customize "<b>Reply 5</b>: Create update query for remaining records in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

accesshacker replied 4 weeks, 1 day ago
It will be added to TALLOC in Table #2 Here is the SQL SELECT ITEM_ALLOC_TEST.Deal, ITEM_ALLOC_TEST.[PO #], ITEM_ALLOC_TEST.Item, ITEM_ALLOC_TEST.SN, ITEM_ALLOC_TEST.ST_TYPE, ITEM_ALLOC_TEST.Rank, FNEGR() AS ADDL FROM ITEM_ALLOC_TEST INNER JOIN NEG_ALLOC_UNITS ON (ITEM_ALLOC_TEST.Item = NEG_ALLOC_UNITS.Item) AND (ITEM_...
Size: 8,049 bytes
Customize:  Customize "<b>Reply 6</b>: Create update query for remaining records in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"

 

Top contributing authors

Name
Posts
accesshacker
4
user's latest post:
Create update query for...
Published (2009-11-05 17:13:00)
&nbsp; It will be added to TALLOC in Table #2 Here is the SQL SELECT ITEM_ALLOC_TEST.Deal, ITEM_ALLOC_TEST.[PO #], ITEM_ALLOC_TEST.Item, ITEM_ALLOC_TEST.SN, ITEM_ALLOC_TEST.ST_TYPE, ITEM_ALLOC_TEST.Rank, FNEGR() AS ADDL FROM ITEM_ALLOC_TEST INNER JOIN NEG_ALLOC_UNITS ON (ITEM_ALLOC_TEST.Item = NEG_ALLOC_UNITS.Item) AND (ITEM_ALLOC_TEST.[PO #] = NEG_ALLOC_UNITS.[PO #]) AND (ITEM_ALLOC_TEST.Deal = NEG_ALLOC_UNITS.Deal) GROUP BY...
KARL DEWEY
3
user's latest post:
Create update query for...
Published (2009-11-05 16:47:00)
&nbsp; &gt;&gt;I was trying to add the 1 in the query until it equals the 20 and then stop. What field in table 2 is it being add to? How about posting the SQL of your query. -- Build a little, test a little. &quot;accesshacker&quot; wrote: &gt; The query I have been working on is populating the 1. No fields are being &gt; reduced to zero. Table #1 is only a holder for what is remaining. I am &gt; testing right...

Related threads on "Discussions in microsoft.public.access.queries":

Create queries in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Create queries in microsoft.public.access.queries
Create queries in microsoft.public.access.queries
A field on a query has a value in it I'd like to use to...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile A field on a query has a value in it I'd like to use to create tot in microsoft.public.access.queries
A field on a query has a value in it I'd like to use to create tot in microsoft.public.access.queries
Show create table in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Show create table in microsoft.public.access.queries
Show create table in microsoft.public.access.queries
CREATE TABLE... in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile CREATE TABLE... in microsoft.public.access.queries
CREATE TABLE... in microsoft.public.access.queries
Create View in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Create View in microsoft.public.access.queries
Create View in microsoft.public.access.queries
Multiple large queries vs. One big/several small queries...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Multiple large queries vs. One big/several small queries in microsoft.public.access.queries
Multiple large queries vs. One big/several small queries in microsoft.public.access.queries
Queries based on queries in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Queries based on queries in microsoft.public.access.queries
Queries based on queries in microsoft.public.access.queries
How do I make a report using crosstab queries? in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile How do I make a report using crosstab queries? in microsoft.public.access.queries
How do I make a report using crosstab queries? in microsoft.public.access.queries
Question about user-entered parameters in queries in...  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Question about user-entered parameters in queries in microsoft.public.access.queries
Question about user-entered parameters in queries in microsoft.public.access.queries
Serial number in Queries in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Serial number in Queries in microsoft.public.access.queries
Serial number in Queries in microsoft.public.access.queries

Related threads on other sites:

Convert MySQL db to SQL Server, run create and insert...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.server - site profile microsoft.public.sqlserver.server - forum profile Convert MySQL db to SQL Server, run create and insert queries in microsoft.public.sqlserver.server
Convert MySQL db to SQL Server, run create and insert queries in microsoft.public.sqlserver.server
Create queries with X++ in...  Discussions in microsoft.public.axapta.programming - site profile microsoft.public.axapta.programming - forum profile Create queries with X++ in microsoft.public.axapta.programming
Create queries with X++ in microsoft.public.axapta.programming
Create a chart WITHOUT using tables or queries in...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile Create a chart WITHOUT using tables or queries in microsoft.public.access.gettingstarted
Create a chart WITHOUT using tables or queries in microsoft.public.access.gettingstarted
Create a Form (with Subforms) Based on A Query/Queries...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Create a Form (with Subforms) Based on A Query/Queries in microsoft.public.access
Create a Form (with Subforms) Based on A Query/Queries in microsoft.public.access
Read only tables, but still create queries etc. in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Read only tables, but still create queries etc. in microsoft.public.access
Read only tables, but still create queries etc. in microsoft.public.access
LINQ queries within queries in...  Discussions in microsoft.public.dotnet.framework - site profile microsoft.public.dotnet.framework - forum profile LINQ queries within queries in microsoft.public.dotnet.framework
LINQ queries within queries in microsoft.public.dotnet.framework
Simple-Talk - SQL Server 2005 Issue |Queries Remaining in...  Simple-Talk - Forums - site profile Administering SQL Server - forum profile Simple-Talk - SQL Server 2005 Issue |Queries Remaining in Suspended State
Simple-Talk - SQL Server 2005 Issue |Queries Remaining in Suspended State
Microsoft.Jet.OLEDB.4.0 cannot be used for distributed...  Discussions in microsoft.public.data.oledb - site profile microsoft.public.data.oledb - forum profile Microsoft.Jet.OLEDB.4.0 cannot be used for distributed queries in microsoft.public.data.oledb
Microsoft.Jet.OLEDB.4.0 cannot be used for distributed queries in microsoft.public.data.oledb
Asynchronous queries in microsoft.public.fox.vfp.queries-sql  Discussions in microsoft.public.fox.vfp.queries-sql - site profile microsoft.public.fox.vfp.queries-sql - forum profile Asynchronous queries in microsoft.public.fox.vfp.queries-sql
Asynchronous queries in microsoft.public.fox.vfp.queries-sql
@ kzu support for querying collections will be helpful...  Twitter / cibrax - site profile cibrax - forum profile @ kzu support for querying collections will be helpful too. Today, you can only create queries against scalar properties in the resources. about 20 hours ago from twhirl
@ kzu support for querying collections will be helpful too. Today, you can only create queries against scalar properties in the resources. about 20 hours ago from twhirl
Thread profile page for "Create update query for remaining records in microsoft.public.access.queries" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Create update query for remaining records in microsoft.public.access.queries", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity