470,822 Members | 1,383 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,822 developers. It's quick & easy.

How to create Balloting of a Housing Project Plots....

102 64KB
Hello dear friends

I want an idea for How to create Balloting of a Housing Project Plots....

There are two files.... one for Plot Numbers and other for Customers details...

What to do for balloting ... looking for an idea or any demo...
Jan 27 '21 #1
4 1487
3,653 Expert Mod 2GB

I'm not sure I understand what you mean by "balloting". I can only imagine that the Plot and Customer tables are related in some way, but until we understand the purpose, we will be unable to hepp!

Jan 27 '21 #2
102 64KB
Dear Mr Twinnyfo

Sorry I could not explain.... Basically this is the balloting of housing scheme.... there are 500 plot in a residential scheme. The location is one the most attractive place... so the customers are more than 4000.... now we have to make a system that computer pick plot from one table and pick one customer from other table and should be save in an other table / query for printing purposes.

This is almost sequential number type project... but I have no idea how to create this sequential type query or vba code....
hope I made clear myself....
Jan 28 '21 #3
357 Expert Mod 256MB
Crossposted at AWF combine-records-in-a-query - post #23 onwards
Jan 28 '21 #4
3,653 Expert Mod 2GB

In general (and I'm not going to build this for you), in your Plots table, add a field for "Matched" and in your Customers Table add a field for "Matched". These would be Yes/No fields.

When you are "balloting" off your plots (in the U.S. we would use the word "raffle" or "lottery"), in your queries:

For the Lots:
Expand|Select|Wrap|Line Numbers
  1. SELECT LotNumber 
  2. FROM tblLots 
  3. WHERE NOT Matched;
For the Customers:
Expand|Select|Wrap|Line Numbers
  1. SELECT Customer 
  2. FROM tblCustomers 
  3. WHERE NOT Matched;
Using both recordsets, find out the number of records, generate a random number based upon the number of records for each recordset. Then, RandomLotNumber gets matched to RandomCustomerNumber, update both of those records to Matched = True.

Repeat until there are no more lots. Your actual project will be not much more involved than that. You will just need to keep track of which customer is matched with which lot.

Hope this hepps!
Jan 28 '21 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ramil Domingo | last post: by
4 posts views Thread by Bruno van Dooren | last post: by
2 posts views Thread by David Bartosik - MS MVP | last post: by
6 posts views Thread by David Thielen | last post: by
1 post views Thread by TZ | last post: by
reply views Thread by Arvan[ʫ] | last post: by
reply views Thread by Arvan | last post: by
3 posts views Thread by DBLWizard | last post: by
2 posts views Thread by =?Utf-8?B?SmltIFdhbHNo?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.