Lookup Choices Controlling Calculations

Dec 18, 2014

I am running Access 2010 on a Windows 7 platform and attempting to write a simple database for a local charity, and whilst I have basic skills in Access I would not put my level higher that enthusiastic amateur.I have a couple of fields, one called 'Income' which is a simple currency field. The second field is called Frequency and is a combo field where the user can choose from Weekly; Monthly; Quarterly; or Annual.

The database user enters data taken from a survey sheet which captures the income of an individual along with the frequency of the payment.The requirement.I would like to create a calculated field which gives the annual income.

Example:
Income = $5,000 Frequency = Monthly
the calculated field would return (5,000 x 12) = 60,000

Equally
Income = $1,000 Frequency = Weekly would return (1,000 x 52) = 52,000

View Replies


ADVERTISEMENT

Queries :: Lookup And Calculations Between 2 Queries?

Jun 20, 2014

I have 2 queries 1 called [Prod Performance]

the second query is called [Shifts]

Field within [Prod Perf] which I want to use is called [Prod Date] & [Hrs]

Field within [Shifts] which I want to use is called [Shift Date] & [Shift Total]

I need a query to compare dates which match from both queries and then divide [Shift total] / [Hrs] to give a number.

View 1 Replies View Related

Calculations On Main Form Do Not Reflect Calculations On Subform

Sep 28, 2015

I have solved the problems getting values on the subform. I have not in getting values on the subform.For instance, on the one titled phone use the formula in the tutorial is:

=[sbfCustomerRoomUse].[Form]![txtTotalPhoneUse]

#Error results when the doc is put into a form mode.

Now when I input each value in the equation above separately.I still get no entry.

For " = sbfCustomerRoomUse" , I get #Error;
and for "= txtTotalPhoneUse", I get #Name.

CustomerRoomUse and txtTotalPhoneuse are from the subform that was dropped into the customer form in a previous step. It shows that explicitly when designed sbfCustomerRoomUse on the main that CustomerRoomUse come from a subform. This does not seem to need to be done with txtTotalPhoneuse, and I am not sure why. Neither one gives me a desired calculation result.

View 14 Replies View Related

3 Choices

Oct 24, 2006

Hello,

I have an option group with check boxes on my form that updates a yes/no field in a table, so the choices the user used to have were check "something A" or "something B". Now I have to add a third choice of "nothing" to this.
Is there a way to achieve this with my current setup, or do I need to add a field to my table so that I can have the choices of "something" or "nothing", and then of "something A" or "something B" if the user choses "something"?

Thank you.

View 14 Replies View Related

Lots Of Choices

Dec 15, 2006

In this database, there is a table of users (name, address, phone, etc.) There is also a table of 35 groups. Each user may be in any combination of 1 or all of the groups. The list of groups is not static. At any point in time, I need to be able to show that Bob is in groups 1, 19 and 35. All I can think to do is list all 35 groups in the user table, then make each one a yes or no field. HELP! There’s got to be a better, more efficient way.

View 3 Replies View Related

Limiting To Just Combo Box Choices

Dec 20, 2006

Hello,

I am figuring this must be an easy question. I have combo boxes setup and working great. I just noticed that I can put my own text into the box and not be limited by just the choices in the combo box. If that makes sense.

When I try to lock the boxes then it doesnt allow me to select. I want the combo boxes to be the only selection they can make, and not be able to put their own text in.

Attached a screenshot to help clarify.

Anyone know what option I am missing?

Thanks.

View 2 Replies View Related

Multiple Choices On A Query.

Aug 3, 2005

Hi All.
I currently have a query that runs a report. The "Project_Status" field of the query is decided from a combo (cboPS) that is on a form (frmReportManager). The user selects the status from the combo and clicks a button to run a report with that status. That is all OK.

What I would like is 4 tick boxes on the form with the 4 project Status (Ongoing, complete, invoiced and quote). The user would then choose the status types he would like in his report, not just the one type as in the combo.
How do I go about referencing the 4 text boxes for the status types, to the one field in the query (Project_Status).

I have tried using And and Or, but with no luck.

Czn anyone help?

Many Thanks.

Frank.

View 14 Replies View Related

Parameter Query With Possible Choices?

Feb 27, 2006

OK, this has to be simple, I know...But I cannot figure it out.

I have a parameter query that works great, however, it has become complicated to remember all the values the field can have and so sometimes it is difficult to find the info needed. How can I do it so that instead of having an empty box pop up when the query needs my parameters, I get a list of possible choices??

Appreciate the help

View 5 Replies View Related

Best Way To Group Combobox Choices?

May 9, 2005

I have a combobos using a table to look up its values, no problem. The table could have several identical values to place in the combo box ( same city, State multiplt times). I want to group these so that the city, state will only show once in the combobox, hence makiing the list a little shorter. is the best way to do this by creating a new query to group the choices and base my combobox off this new query? or is there another way from within the combobox properties?

Thanks all
Kevin

View 3 Replies View Related

Hide Some Choices In Combo Box?

Oct 26, 2006

I have a combo box populated from a table containing names. Whomever processes the order selects their name from the combo box. Some entry persons have left the company but I cannot delete their names from the table as the orders are stored with their names and I want to maintain that history. Is there a way to hide their names from being displayed in the combo box?

View 2 Replies View Related

How To Sum Up Various Choices With Unique Values

Jul 29, 2015

I would like to sum up choices made by a user. I'm not sure whether I should create a new table and a couple of fields (not including primary key) with Fruit & Fruit Value.

Where: Apple (Y or N)=4 or 0, Oranges (Y/N)=3/0, Bananas (Y/N)=2/0, etc. As the user chooses the fruit, the value rises.

For example, if the user selected Yes for APPLE and ORANGES the sum is 7-- or if the user selected ORANGES and BANANAS the sum is 5, etc.

Is it possible?

View 1 Replies View Related

Calculations On Calculations--too Much For Access?

Jun 8, 2005

I have an odd problem that has stumped me for several days. I'm working on a form that contains a chart. The chart is based on a query, which is based on another query, which is based on a table. In the top query, I need to put some calculated fields that operate on other fields. But when I try to multiply two fields together, I get Null. I'm pretty confident that the fields I'm operating on are numerical.

The fields of the query should be:

MaxOfEverInSchool
MaxOfSurvivalToGrade
MaxOfEverInSchool

With these being the calculated fields:

MaxOfSurvivalToGradeCum: MaxOfEverInSchool*MaxOfSurvivalToGrade/100
MaxOfCanReadCum: MaxOfEverInSchool*MaxOfSurvivalToGrade*MaxOfCanRea dCum/10000

Any insight would be greatly appreciated--I just can't understand why Access would suddenly refuse to do math.

View 1 Replies View Related

List Multiple Choices In Combo Box Once

Feb 13, 2006

I have 2 cbo boxes : Year and Company

A certain year might have multiple entries for the same company. I want to have the company listed once instead of multiple times. How do I do that?

Thanks.

View 2 Replies View Related

General :: Selecting And Storing One Or More Choices

Oct 17, 2014

there could be one or more categories for each person, and in the end there could be a lot of categories, certainly 20+, but the idea is that i could add more when needed.

What's the best way to store these data?Should i create a new table called groups and create a coloumn for each category and write the ID there? Should i add one field to the common table and store all interests there as csv? Many coloumns?

how to collect these data? i don't want text field due to spelling errors and inconsistency (don't want someone to add automobiles and the other cars). Plenty of checkboxes? Multichoice box?

View 5 Replies View Related

Queries :: Ribbon Choices Grayed Out

Nov 13, 2013

Suddenly most of my ribbon functions are greyed out. I noticed it when I was trying to change a simple format. I tried closing outlook and reopening it but nothing is changed. I also tried other databases and still no dice.

View 2 Replies View Related

Query Selection - Multiple Choices, One Field

May 19, 2005

I have a database which keeps track of a trucking business. Each truck has a trailer number. I have no problem having a query prompt the user to enter a single trailer number to query on. What can I do when the customer needs to select more than one trailer number to query on?

View 4 Replies View Related

Use Randomize And Rnd In The Same Query To Get Real Random Choices

May 14, 2006

The queries go like this at present :

SELECT TOP 1 [Table].[QuestionText], [Table].[Answer] AS CorrectAnswer
FROM [Table]
GROUP BY [Table].[QuestionText], [Table].[Answer], rnd([IDQuestion])
ORDER BY rnd([IDQuestion]);

SELECT TOP 3 Table.Answer AS Correct, qQuestionTextAndAnswer.QuestionText, qQuestionTextAndAnswer.CorrectAnswer
FROM [Table], qQuestionTextAndAnswer
WHERE (((Table.Answer)<>[qQuestionTextAndAnswer].[CorrectAnswer]))
ORDER BY Rnd([IDQuestion]);

These queries are displayed now in an Access form "frmQuestions" which is applied to "Table" that has three columns id, text , and answer. The result is one question and four suggested answer with one only being correct.The arrangement of the answers is randomized--
but the choice of the question is not realy random....it always starts with the same question as it relies only on rnd.

can I improve the queries and randomize and rnd in the same ...or else can I switch these queries to be used from vb6 code and achieve that result.

any help would be appreciated.

By the way I am really a beginner at this who is seeking help from the experts.

View 14 Replies View Related

Controlling Changes To Combo Box

Jan 17, 2007

I have a form. In it is a status field that can be:

NEW
SENT
CREDIT
COLLECT
CLOSED

When the item is created, it is given a "NEW" Status. And there is a command button on the form that can change the status to "SENT". However, based on external factors (email received or system report examined) the user can manually change the status to the CREDIT, COLLECT or CLOSED. Now, I want to make sure that then can't change the status manually to "SENT", only the system is allowed to do that via the command button.

How can I allow them to use some of the allowed values, but not others?

David

View 1 Replies View Related

Tables :: Check Box Field - Store Only Two Possible Data Choices

Oct 7, 2014

Is it possible to create a field in a table that stores only two possible data choices: a check or null value ?

View 6 Replies View Related

Forms :: Table With Choices For Subform / Related Records?

Jul 11, 2013

I have a table that has the list of "Project design" choices, and I enter in there the choices that a project can be. I then have that table related to a junction table that has the "Project design choices" linked to the "project code." Anyway, I THOUGHT that one of the bonuses to using Access was that if you see something spelled wrong, you could fix it in one table and it would fix it everywhere. However, when I see that I spelled something wrong in "TBLProjectDesignChoices" and I want to fix it, it tells me that I can't because it contains related records.... ok so, if this is bad design.. I may have to leave it because I have spent countless hours doing data entry for this..

View 8 Replies View Related

Forms :: Conditional Formatting For Choices And Printing In Color

Aug 23, 2013

I have an access form that has a dropdown box list of 10 choices.

For example:

The form states please choose 1, 2, 3 or 4 then the choice should print in BLUE.

They choose 5, 6, 7 or 8 Then it need to print in RED.

So forth and so on.

I am sure there is a code I need to type in the conditional formatting area that would reflect if [1], [2], [3], [4] then I choose the red color.

I do not know how to use VBL or coding.

View 9 Replies View Related

Text String From Form Query - Multiple Choices

Aug 12, 2012

Been a while since I put hands on access. Working with a very simple database.

Working with 1 table, 1 form, 1 query.

Query has several fields. Field of interest contains names of counties.

In query design view I can type, "CountyA" Or "CountyB" or "CountyC" in the criteria and the desired results are returned.

On form I've created a text box and an open report button. The report I'm trying to open uses the query as the data source. I reference the text box on the form as the criteria for the query as follows:

[Forms]![frm_LMIBasicReport]![txtCounties][Forms]![frm_LMIBasicReport]![txtCounties]

If I enter the the name of a single county into the form it executes perfectly. If I try to enter multiple counties it fails. This is true whether I just enter the county names or replicate the exact criteria string I use in the source query. For example

CountyA works and returns desired values for County A
CountyA Or CountyB or CountyC fails. The report opens but no records are returned
"CountyA" Or "CountyB" or "CountyC" = exactly how it is entered in the query if I'm not using the form opens report but no records are returned

How can I pass multiple values from a single text box to the query.

View 1 Replies View Related

Updating Another DB And Controlling From A Differnt DB

Jun 16, 2005

Hello All,

How would I run a procedure in DB2 from DB1?

View 3 Replies View Related

Whats Controlling These Decimals?

Jan 5, 2007

Hello,

Dont understand what is controlling these decimals. I dont need any decimals for this database. The currency is talking bout money in 1000's and the probability is whole numbers.

Here is where I cant get the decimals to stop:

http://img80.imageshack.us/img80/3685/untitled2pl2.png
http://img77.imageshack.us/img77/6276/untitled3pa6.png
http://img208.imageshack.us/img208/2047/untitled3lk8.png

I have tried different things but no luck...anyone have any suggestions.

Thanks.

View 10 Replies View Related

Controlling Time/date

Jan 12, 2007

In a simple access table, I have the follwiing:

Data type: Date/Time

Format: mm/yyyy
Input Mask: 99/99

It restricts me to enter 2006 for instance. It converts to 2007. I want to be able to enter any year. Please help. Thank you.

View 2 Replies View Related

Controlling Subforms With A Combo Box

Jun 29, 2005

Is it possible to control the data of a subform by making selection in a combo box?

View 2 Replies View Related







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