Choosing All Possible Combinations And Adding Their Values
Aug 25, 2004
ok this is weird post but im wonderin how to go about it easily cause i can think of a few ways, dunno if they will work of not, so im asking for ur opinion. I need to find out possible cominations for a salary cap football league based on dollar amounts for the players and points based on last years results, yet it cant go past $100.00...so one possible choice is (QB Tom Brady $22.56 183.50 points). its 1 QB, 2 RB, 3 WR, 1 TE 1 Kicker, 1 DEF team and i have to do all 9 for it to count...so would i have to set up 6 columns, one for each position and have a way of picking 1 of A 2 of B 3 of C 1 of D 1 of E 1 of F for 1 qb, 2 Rb, etc? and have it so sum of values is < $100 and it also must add the points so i can see the best possible combination/most points i can get for $100.00...i know its last years points and this year will be diff but I am just comparing...all i need is an outline i dont need u guys to do it for me i have some experience with access...thanks for anyone who can help
View Replies
ADVERTISEMENT
Oct 6, 2006
I have a list box box which contains a ProNo and ProName.
I want to be able to select a value in the list box and pass it to another list box in the form so i can pick the projects i want to print reports on.
Is this possible or is there another way of going about this problem.
View 1 Replies
View Related
Apr 19, 2014
I'm rather new to Access.
I have 2 tables.
Table 1 : invoices
Table 2 : customers.
I want on my form of invoices to have a way to select a customer. I want a button, and when I click on it I want a list of all my customers.
How do I do that?
When I select a customer, I want that the fields in the invoice are automatically filled in . (Adress, zip, city, phone).
View 2 Replies
View Related
Jun 8, 2005
Hi Everyone,
I want to perform queries that count the number of customers using combinations of different products.
The data is organised like so:
CustomerID ProductType No of Items
1 A 5
1 B 1
1 C 2
2 D 2
3 B 2
3 B 3
and so on.
There are 5 or 6 product types. I need to be able to produce a table showing all the various combinations. For example, number of customers using JUST product type A and nothing else, number of customers using product type A and product type B, customers using product type A, B and C
and so on.
I think there are around 64 different combinations!
I was wondering if there is a quicker way to do this apart from writing 64 different queries!!
Hope this clear and hope someone can help!
thanks!
Sasha.
View 3 Replies
View Related
Apr 6, 2007
Hi,
I have the following dilemma. I have to make multiple tables with many columns and if I were to type in the data manually it would take me a few weeks. But if I could somehow specify the number of columns(and the number of choices in each column) and then have Access(or Excel) create a table with all the possible combinations it would make my job a LOT easier. For example, let's say I have department stores in multiple cities. I need to create the following table:
CITY DEPT CLOTHING
San Jose Men's Shirts
San Jose Men's Pants
San Jose Men's Shoes
San Jose Women's Shirts
San Jose Women's Pants
San Jose Women's Shoes
Los AngelesMen's Shirts
Los AngelesMen's Pants
Los AngelesMen's Shoes
Los AngelesWomen's Shirts
Los AngelesWomen's Pants
Los AngelesWomen's Shoes
Instead of typing that out manually, is it possible to create some sort of list like:
Cities: San Jose, Los Angeles
Dept: Men's, Women's
Clothing: Shirts, Pants, Shoes
And have Access or Excel create the table with all of the possible combinations?
Thanks for your time.
View 1 Replies
View Related
Apr 16, 2012
I need to be able to find duplicate combinations (or, I suppose, permutations). I have four columns in a table that all contain inter values. I want to be able to query so that I can see if there are more than one records that have, say, 12, 28, 5, 14 in columns 1, 2, 3, and 4, respectively.
View 5 Replies
View Related
May 21, 2007
Hi,
HELP!
I have 8 tables all with a membership number as the unique identifier, I need to find all the possible combinations and then create queries for each combination, is there a quick and easy way to do this? or do I have to sit and define a query for each of the 250ish combinations?!
I'm pulling all the data together using a union query. What I need to do now is to find the combinations using either "is null" or "is not null" criteria (in the queries).
Regards
H.
View 14 Replies
View Related
Feb 1, 2008
All,
I have a problem building a query using multiple check boxes. The situation is as follows:
I have a database to monitor enquiries which come into a central email account. I have devised a system where several check boxes are used to define the nature of the enquiry. Users can tick any number or none of the options to describe the enquiry.
I would like to create a query where users can search the database based on the check boxes which have been ticked. For example, if users want to search for enquiries where a specific three check boxes have been ticked, I would like all of the records where these three boxes are checked to appear, and so on for all different combinations of check boxes ticked.
I've tried a few methods, including creating a seperate form for the query where users check their search criteria in line with the enquiry form, but I can't link this with the original form.
I hope my description adequetly conveys the problem I have!
Any thoughts would be most welcome.
Rob
:confused:
View 1 Replies
View Related
Feb 1, 2008
All,
I have a problem building a query using multiple check boxes. The situation is as follows:
I have a database to monitor enquiries which come into a central email account. I have devised a system where several check boxes are used to define the nature of the enquiry. Users can tick any number or none of the options to describe the enquiry.
I would like to create a query where users can search the database based on the check boxes which have been ticked. For example, if users want to search for enquiries where a specific three check boxes have been ticked, I would like all of the records where these three boxes are checked to appear, and so on for all different combinations of check boxes ticked.
I've tried a few methods, including creating a seperate form for the query where users check their search criteria in line with the enquiry form, but I can't link this with the original form.
I hope my description adequetly conveys the problem I have!
Any thoughts would be most welcome.
Rob
:confused:
View 2 Replies
View Related
Oct 6, 2014
I am looking for a piece of code (either in access or excel) which will return all combinations of records in a particular field (or column of cells) which will sum up to a given value (or a close approximation thereof - ie a margin of error of, say, 2).
In other words, imagine you have a number field with 100 records in it. I would like to know all combinations of those records which add up to a value that the code could specify (eg 223). This would be incredibly valuable to assist in performing reconciliations that I perform in my role.
View 1 Replies
View Related
Sep 5, 2014
I am trying to create a cross join or Cartesian product TABLE, not a query.
I am creating a training database. For each and employee and each training event, I want to know - is this event required, who approved it, and when was it completed. The table I envision looks like this:
Code:
EMPLOYEE_ID EVENT_ID REQUIRED APPROVER EVENT_DATE
1 1 Y WPD 9/5/14
1 2 N
I currently have 39 employees and 473 events - 39*473 = 18447 records
I was able to make a cross join query and use make table, but whenever I add a new employee or event, if I update the make table query I will lose all my existing data.
View 3 Replies
View Related
Jul 8, 2014
I am new to Access and am trying to reduce a dataset I am working with to make it managable for Excel. I have three columns which have three unique parameters and one column with numberical content.
Column A Column B Column C Column D
NJ Red Monday 10
NJ Red Tuesday 20
NJ Yellow Wednesday 30
NY Red Monday 35
NY Green Tuesday 40
NY Green Wednesday 60
I want to elimiate column C from the dataset, and sum column D for every unique combination of Column A & Column B. I have figured out how to reduce down the dataset to get a list of all unique combinations of Column A&B,what formula I can use in a query to sum column D on my table for every unique combination of column A&B. This is a simple SUMIF in excel, but my dataset is too large for excel.
View 4 Replies
View Related
Dec 29, 2006
I have a report that adds time for as many as six people. This isssue is when the time goes over 24 hours in total it drops the hours. The field(s) is formated in "short time" format.
Can anyone help resolve this???:confused:
View 6 Replies
View Related
Sep 28, 2005
can someone help with this. I have 2 fields in a query
tbl1_nbil = 3
tbl2_nbil = 0
however when I add them using
Bill = [tbl1_nbil] + [tbl2_nbil], I only get a few of the added numbers in the calculated field. In some records it works, but in the majority it does not
It onl seems to add when both fields are greater than zero
tbl1_nbil : tbl2_nbil : Bill
1 : 1 : 2
1 : 0 : 0
2 : 1 : 3
0 : 2 : 0
4 : 0 : 0
View 1 Replies
View Related
Oct 15, 2004
I have this problem. I've made a table called "producers" and a main form based on this table. I've also made a table called "orders", with several data regarding orders, and a secondary table based on the "orders" table. These tables are linked. So these forms show the orders made by each producers.
So, I want to show in the textbox "total" (in the footer of the sub form) the result of this function
sum([kath_dik])-sum([pistosi]) for each company. [kath_dik] and [pistosi] are text boxes in the sub-form. (scroll the sub form to the right end)
I tried the formula above end get an error message. Thanx in advance
View 2 Replies
View Related
Mar 3, 2005
I've been having trouble trying to figure out how i can add the values within one column. I have a field named Cost, under that field i have serveral rows of data. I would like access to add all the numbers under that "cost" field. Im not sure how this is done. Can anyone please help ???
thanks
EM
View 6 Replies
View Related
Sep 22, 2006
i need to add values of about 20 items and store them in a feild of their own. any ideas of how. Tthe items each have their own value but i need to be able to add all of them up and divide the by the total p[ossible points. i know their is a way to do so but i cant get it to work on my own it keeps giving me an aggregate error.
View 1 Replies
View Related
Aug 13, 2015
I am trying to set up a estimation form. What I want to accomplish is to have multiple checkboxes that a user would select the boxes relevant to his project. From these selections there would be a sum created. Each box could have different values. I tried using the default value but when I unchecked and rechecked it went back to using -1.
I am thinking I will need to assign values through a query but I want to show the sum on my form.
View 6 Replies
View Related
Feb 8, 2007
Am I missing something simple here? I have several text boxes, which I want to add the values. I have tried these formulae, but dont work:
=Sum([Postage],[ProgTotal])
=Sum([Postage] + [ProgTotal])
=DSum([Postage],[ProgTotal])
Any help would be greatly appreciated!
View 7 Replies
View Related
Oct 16, 2007
Hi all,
can i use a listbox control NOT IN A PROGRAMATICALY way, in a table to allow user choose one of some pre_defined values (for example 1,2,4). This field will be used as a parameter in an communication with HW, that's why its crucial not to let users choose whatever value that they want.
Thank you
View 3 Replies
View Related
Jun 20, 2007
Hi,
Im trying to create a database for a stock control system. I have a slight problem, the stock is in two places. So what i have to do is put in the values of stock in each place and then display the value of those two added up in the table. What is the best way to be able to do this?
View 12 Replies
View Related
Aug 13, 2007
Hi folks
I have what I reckon is a complex problem that I need to solve for my warehouse.
We hold replacement parts for the machines we sell. Some parts can be subsititued for others, so where we possible we use these parts to simplify our warehousing. Every day we get a file with demand for each part in and we look to see where we could move this demand to for those parts with a common alternative. When we find one we remove the demand from that part in the database and add it to the demand for the common part.
In operational terms we upload the demand file (.xls) to a table of the following structure
Date_added - Date
Part_number - Text
QTY - number
Thus the table holds daily demand by part. What I would like to do is use a update query to:
a) Identify the parts that have common parts to which they can be moved.
b) Add that demand to that of the common part today.
c) remove it from the original part (set to zero).
Idenitfying the parts and restricting to todays date is not a problem, however the additions and deletions are.
Any suggestions?
Thanks in advance!!
View 1 Replies
View Related
Sep 21, 2007
Hi,
This may be a dumb question, but I've got kind of a question about adding values.
I have a subform that contains a department name, and it's waste totals (in Kilograms) for the day, for a particular company. The company information is the main form.
Whenever I start a new department, the totals, and category names start blank (different departments could produce different waste).
I'm trying create a query that gives me the total value for each Category of waste. However, I keep getting all the seperate values returned?? As apposed to a total. For example.
Company A has two departments:
Office and Production.
For Office they had 20 Kg of plastic bottles and Production had 20 Kg of plastic bottles.
I want to be able to total the weight of plastic bottles...it's just not working../
?
Any advice?
View 1 Replies
View Related
Jan 30, 2005
Query 1:
Field #1: User Name
Field #2: CountOfUserName
Query 2:
Field #1: User Name
Field #2: CountOfUserName
Query 3:
Field #1: User Name
Field #2: CountOfUserName
Query 4:
Field #1: User Name
Field #2: CountOfUserName
I want to create a Query that will add
[Query 1].[CountOfUserName]+[Query 2].[CountOfUserName]+[Query 3].[CountOfUserName]+[Query 4].[CountOfUserName]=
[My Query].[TotalCountOfUserName]Group by UserName
It seems difficult.
View 6 Replies
View Related
Jun 19, 2006
Hi there
I have an ASP form that saves numerical data to an access database via an insert statement in the asp page.
The main problem i have is that i have some code that adds all the stored values together and provides a total on the screen for the user to print off.
I would like to save this 'total' value to a field in the table but cannot seem to get this to work.
So i thought of running a query in access that would add the sum total of a number of fields and store it to the total field.
Is this possible and how would i go about it?
Cheers
View 3 Replies
View Related
May 23, 2013
anyway you can add the values onto a graph
eg i have created a bar graph and on each bar would like the value shown on the top of it
View 9 Replies
View Related
