General :: Divide Groups By Equal Distribution Of Merit / Talent?

Aug 9, 2013

I am with an educational organisation. Now we need to allocate various fields to students depending upon their merit, where the difference between the average percentages between any two groups cannot be more than 2% and that also implies equal distribution of talent. However, First few have to be given choice of field and also students recommended have to be given choice. The number of fields varies from 2 to 8. . Further the vacancies are also not equal in all fields. E.g. for 100 students to be divided in four fields the vacancies can be 35 for ZZSS, 24 for UYTE, 29 for OIUI and 12 for HGFT.

I need a solution preferably in MS Excel or MS access for the same with nil/ least usage of VBA.

Table examples

Name REg. No. Percentage

Aaa 986544a 89.3%

Bbb 547521j 87.2%

Ddae v44887y 95%

View Replies


ADVERTISEMENT

Way To Have Multiple Distribution On One Field Without Creating Multiple Distribution Fields?

Mar 1, 2012

I am creating a CAD Drawing database / Distribution list. I can only seem to distribute one drawing i.e single field to one person.Is there a way to have multiple distribtion on one field without creating multiple distribution fields?

What I have is a database which contains Drawing Numbers - I need to create a report that shows where the drawing has been distributed to, with it's current revision status and the date is was sent.I am having trouble trying to use multiple revisions and mutiple people in the distribution list with one drawing.

View 4 Replies View Related

General :: How To Divide 1 Record In Multiple Records

Nov 12, 2013

I have an order table

order nr quantity.
100 110

and a pack table

pack quantity
1 1
1 2
...
1 25
2 1...

I want to make a query that returns this :

order nr pack quantity
100 1 25
100 2 25
100 3 25
100 4 25
100 5 10

View 8 Replies View Related

Database For Talent Show

Mar 21, 2007

I have running a talent show for several years now. First I kept all records on paper, then moved to spreadsheets, now I am moving to a database. I have it "useable" but I feel it could be better. I have many questions but I will ask the important one now. I am using 2 tables, one holds contestant info such as name, address, phone, etc... the other holds the info from each years talent show such as year, age, song title, winner, no show, etc... so I can have mutiple records for each contestant. (kind-of a history) I have them referenced by ID fields. The latter table is a subform on the main form which is the first table. This works but when I am making queries and need to do other certain things it makes it difficult because I have it set up this way. Is there a better way to set this up? I hope I have explained it clearly. Any suggestion is appreciated.

JO

View 2 Replies View Related

General :: Equal Fields Across Tables / Forms

Aug 22, 2013

I have a few fields that are the same across a couple of forms and sub-forms (each form/sub-form being represented by a different table). I would like for data entry into one field to ensure that the data is autofilled into the other. ie if I type 'ENG' into field 1 on form 1, it will autofill the equivalent field in sub-form 2 as 'ENG' so that I do not have to type the same thing twice. These entries are not unique or in any order as it is variable depending on the entry and so they can't be linked as primary keys and foreign keys. So how would I do this? I would like to avoid VBA is possible.

View 1 Replies View Related

General :: Enter Number Equal To Or Over Ten Million - Getting Last Two Values Rounded

Feb 28, 2013

When I enter a number equal to or over ten million, the last two values get rounded and I don't want them to be. My field is setup as a single, standard, two decimals. When I tested it I typed in 123456789, what I got was 123,456,800.00

enter 9999999 get 9,999,999.00
enter 10000199 get 10,000,200.00
enter 10000001.75 get 10,000,000.00

Single is supposed to handle up to 10^38

I have checked my "Region and Language" settings for the OS (W7) and there is nothing in there about rounding or maximum number size. I would like to leave the data type at single for the space considerations, and because it should work as single.

View 8 Replies View Related

General :: Pivot Chart 2 Value Groups Overlaying Error

Oct 24, 2013

after building a database in Access 2010, I am having a hard time with something that seems relatively simple.

I am trying to create a bar graph PivotChart with 2 different values associated an individual axis. While I can get the data into the PivotChart, I can't seem to make it stop overlaying the data. This is problematic because it causes one of the bars to be behind another.

Is there a way to make this data stack up side by side rather than on top of each other?

I've already tried changing the chart type, made the data separate groups, overlap is set to 0.

View 1 Replies View Related

"Not Equal And Not Equal" Query Not Working

Apr 14, 2006

I am trying to run a query where one field has a Not Equal parameter AND another field has Not Equal parameter (for example, Product Code Not Equal "A" AND Client State Not Equal "NY)

The result of the above query are all records that have Product Code = "A" are missing from the result. I want some of the "A" Product Codes; I just want to exclude the ones where the Client state is NY.

The list of values for each field is too big to state it in a positive way (I would have to list all the other 28 product codes and all the other 49 states).

What am I doing wrong? Thank you in advance for any suggestions.

View 1 Replies View Related

Front End Distribution

May 16, 2006

I have read every post here on "distribution" and "deploying" the front end to the users but can't seem to get how to do it. I see many posts regarding updating the front end and using the runtime version to distribute but can't seem to understand how to initially get the database out to my users.

I have a split db and need to distribute it to about 20+ people. The back end will reside on a shared drive that is mapped the same on everyone's machine.
I also have the FE on the same drive and am currently using a batch file run from a link on our website to open it, therefore we are all using the same front end which is what I am trying to eliminate.

Can I just zip up my FE and email it to my users? Will that maintain the links to the back end when they unzip it to their desktop?

Also, I would like to get some feedback on some software I am thinking of buying for pushing out my updated databases in the future. It is called Access Frontend Loader
http://www.frontend-loader.com/

Has anyone used this before? Would appreciate any thoughts on it or any other program you may have used in the past.

Thanks

View 3 Replies View Related

Database CD Distribution

Jun 7, 2006

Afternoon

Apologies if this is in the wrong place, but I've looked around and can't find anywhere else that's relevant.

Essentially, I have a large reference database that I'd like to send to a fairly large number of people, preferrably on CD. Copying and pasting information into another format, such as Excel isn't an option.

My question is, how could I setup the content of my CD so that everyone could access it, even if they don't have Access? Could I include a copy of Access Runtime on the CD? Would that enable people who don't have Access to view the data on the CD? If so, would there be licensing implications if I did this?

Sorry if that's convoluted, but I'm not technical.

Thanks

View 2 Replies View Related

Create Distribution Package

Mar 25, 2006

I have developed access application (front/backend) for my client. As client wanted they would be running on 3 comps on LAN. 1 comp would have the DB and the other 2 the frontends. How will I create installation (CD/package) so that it can be distributed in the clients site. Any suggestion would be appreciated.
Thanks in advance.

View 1 Replies View Related

Distribution Of Database (without Access)

Aug 2, 2006

What's the best way to go about this?

Right now I have about 40 personnel using 40 different Excel files. Each day, each file needs to be copied and pasted into one large file. I've recently had luck replacing several of my personal Excel files with MS Access and now completely hooked on using databases. I would love to replace all of those Excel files with a Database on the network, at the end of the date, compiling everything together would be as easy as a query, and possibly an export (if we needed to send the Excel file out as we sometimes need to).

I've got the use of a Network, but here's the rub. I'm the only one with MS Access installed. I can not talk my boss into buying the additional licenses needed for Access on their computers.

My edition is also not a "Developer Edition" as I've seen where you can create a runtime version, so I guess that's out.

What would be a suitable "frontend" to do something like this. I'm pretty decent at Access, but certainly no expert. What is the best/easiest options that I should be looking at?

I'm willing to learn something new if I have to (which I probably will). I'm also willing to spend some of my own money to put something on my machine at home if it will help me develop something. I just need options because I don't know enough to make a decision about this.

Thanks in advance.

View 8 Replies View Related

Front End Updates And Distribution To Users

Dec 27, 2006

Howdy!

I split my db last week and put both front end and back end files in a shared network folder. I backup the db every day to a different folder on the network server and also to my laptop. I usually backup right after a form update so that the latest version of the form is available to users who want to update their local copy of the front end. I've been sending email alerts to the users.

My question is this: What is the best way to (1) make sure my backup updates the front end on the network server and (2) how can I automatically alert users to update to the latest version of the front end?

Thanks gurus!

bugleboy:o

View 13 Replies View Related

MS Access Distribution With MySQL Backend.

Feb 2, 2007

On my development machine everything works great, but I know that I'm going to run into problems with distribution.

I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to MySQL for a backend is the fact that I'll be going from 10 users to 150 users, each of which has a "locked down" PC, which would mean logging into each with Admin rights to install the driver. Not an impossible task, but a pain.

Is is possible to have a "shared" source for the driver? I have only a rudimentary understanding of that process.

Thanks in advance for any help that someone can provide, or some answers pointing me in the right direction.

View 1 Replies View Related

Automated Per Record Report Distribution

Jun 11, 2015

automated per-record report distribution. In my system there is a report generated with a record for every person that must be sent out to them on a periodic basis. Ideally I would like to send them out in batch(5000+ records) so that each person receives theirs via E-mail. I am not too worried about the format. Each persons record contains their E-mail address so that should make things easier.

View 2 Replies View Related

Printing/printer Properties Distribution Issue.....

Nov 7, 2005

I hope I can explain this right(and its in the right forum)....newbie....How do you distribute microsoft access 97 front-end program to several users on a network, along with printer properties for multiple printers? Any help would be greatly appreciated. Thanks :o

View 1 Replies View Related

Create Relationships Within Document Distribution List

Sep 9, 2011

I am brand new to using access databases but I am in the midst of trying to set one up for controlled distributions of controlled documents.Essentially, I have three tables:

1) Listing of all our controlled documents and their properties (doc number, doc title, doc revision, doc type, doc status, effective date),
2) Listing of all our copyholders (name, location, phone number),
3) Document Distribution List which lists copy numbers, quantities, and medium to deliverable (paper, electronic, size, etc)

What I want to do is create relationships within the Document Distribution List (using 'add from existing fields') from the other two tables so when a request for a new controlled copy comes along, I don't have so much data redundancy.

For example, in Table 1, I have listed Document XYZ and copyholder Jane Doe from Table 2 wants to receive 1 copy of Document XYZ. I would like to have Table 3 have an added field from Table 1 where I can pull down the applicable document number, which when selected auto fills out it's corresponding details of title, revision, doct type, status and effective date in this Table 3. In addition, after I select the document Jane wants, I want to have another field added to Table 3 from Table 2 which lets me pull down Jane's name to assign her a copy number.

View 1 Replies View Related

Query - Divide

Mar 13, 2006

Just wondering, if this is possible and if so how?

I got query results and would like to divide a figure from the number of results shown..

so if 4 results are shown from the query then i would like to divide 100 by 4, and if 5 results showed then divide it by 5?

View 5 Replies View Related

Divide By Zero Error

Sep 12, 2006

How can I avoid a divide by zero error in an MS Access Query?

View 2 Replies View Related

Divide And Store

Mar 17, 2005

Hi hope someone can help,

What I’m trying to do is work out price per quantity, at the mo I have a database that has products and price so lets take paint for an example.

If I have a 5 litre pot of paint and I’m selling it for £10 I would like a field that tells me the price per litre, so what I’m think I need to do is have a field called ”price” and divide it by a second field called “quantity” and output the sum to a third field called “price per litre” which populates the database.

Sadly I haven’t got a clue how to do this with access and if anyone can help it would be much appreciated.

Thanks

View 1 Replies View Related

Divide By 1,000 Like In Excel

Oct 24, 2006

HiIn Excel, I believe you can format a number and automatically divide it by 1,000 without messing up rounding.For example, 10,000.06 after you apply the formatting becomes 10 as in 10k (for some reason accounting people find this easier to look at/work with). However, if you try to sum the value Excel will actually use the decimal figure rather than the number 10.Is there a similar way in Access?

View 2 Replies View Related

Text Box Divide By Zero

Dec 8, 2006

Hi,

I have a text box which contains a formula. When the text box is divided by zero, it appears #ERROR in the text box. I would like it to be invisible when it divided by zero and to be visible when it has a number.

Any ideas?

Thanks,

Le

View 3 Replies View Related

Avoiding Divide By Zero Error

Aug 25, 2005

Hi all.

I have three subforms on my main form. They all display salary details from different sources, and each subform has 2 calculated fields in the form footer to show the average salary and the number of records on which the average has been calculated.

I then have a field on the main form to calculate the average of the averages which works OK unless one of the subforms has null or zero in it, in which case it returns no information.

Can anyone suggest a way of bypassing this divide by zero error? The code I'm using to calculate the average of averages is as follows:

Me!Text44 = ((Me![Frm1 subform].Form!text4 * Me![Frm1subform].Form!Text6) + (Me![Frm2 subform].Form!text4 * Me![Frm2 subform].Form!Text6) + (Me![Frm3 subform].Form!Text6 * Me![Frm3 subform].Form!Text8)) / (Me![Frm1 subform].Form!Text6 + Me![Frm2 subform].Form!Text6 + Me![Frm3 subform].Form!Text8)

Thanks for any help you can provide...

View 3 Replies View Related

Queries :: Divide Each Value By Sum Of Column

Aug 9, 2015

I am trying to divide each unique value in a column by the total column; so sales by total sales.

View 4 Replies View Related

Queries :: How To Divide A Field Value By Its Sum

May 26, 2015

I have an alias named [Net Income]

[URL]...

I want to divide it's value by the sum of its values through another alias [%]. How to do it?

%:=[Net Income]/Sum([Net Income]) Not working

getting an error saying:

"You tried to execute a query that does not include the specified expression 'SR_NO' as part of an aggregate function."

View 4 Replies View Related

Modules & VBA :: Send Email To Outlook Distribution List - To / CC Or BCC Parameters

Jan 4, 2014

Is there a way of doing the above? I have several distribution lists (some >100 recipients) defined in Outlook, and would like to use the Docmd. Send Object command to send messages to one or several of them. I cannot find a way of defining a distribution list as any of the To, Cc or Bcc parameters.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved