Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

random alocation of number and update table

Status
Not open for further replies.
vishal12345

vishal12345

MIS
Jun 1, 2011
2
GB
Hi,

In attached database I have two tables 1.Product Stock and 2.Order Details. What I want is two things 1st to have a update query which updates column "Total Bids" of Product Stock table by counting number of times unique ID is repeted in Order Detail table eg:20110001 = 4,20110002 =1,20110026 =0. 2nd thing I want is a as for each product only one quantity is avaliable and there are multiple number of orders a query is needed which RANDOMLY selects Dealer and alocate product and update it in lucky column of Order Detail table.

I am very new to MS access. Please help me.

Thank you in advance.

Vishal
 
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
131
Moss100
Moss100
Moss100
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
176
dhookom
dhookom
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
424
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
438
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
348
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top