467,877 Members | 1,259 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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

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...
thanks
irsmalik
4 Weeks Ago #1
  • viewed: 1221
Share:
4 Replies
twinnyfo
Expert Mod 2GB
irsmalik,

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!

Thanks!
4 Weeks Ago #2
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....
thanks
irsmalik
4 Weeks Ago #3
isladogs
Expert 128KB
Crossposted at AWF combine-records-in-a-query - post #23 onwards
4 Weeks Ago #4
twinnyfo
Expert Mod 2GB
irsmalik,

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!
4 Weeks Ago #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
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.