Hello,
I am trying to create a query to calculate certain fields in from a table. The calculations are pretty simple, they are just counts and sums. Once I run it I get the following error message: "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."...
AZKing
Last Activity: Mar 3 '07, 01:27 AM
Joined: Sep 19 '06
Location:
-
Calculations in Access
-
Thank you very much, it worked great!!! I was very close myself, I just couldn't get it to work properly. I appreciate your help and input and thanks again :)... -
Well, I'm gonna freeze or make not visible combo2 and combo3 if combo1 is not selected, same with combo3, I will freeze it or make it not visible if both combo1 and combo2 are not selected, which will remove the possibility of this occuring.
The idea behind this is to calculate the percentage of work completed. So if combo1 is selected as completed, than the percentage should be 33.3 %; if combo1 and combo2 are selected as completed, than...Leave a comment:
-
Hi, I'm not sure I understand, can you please give me an example?
Thanks....Leave a comment:
-
Ok, I am trying to do the following:
In a form in Access, I have 3 drop down menus where you can select "yes" or "no". I also have a text box where I would like a percentage to show up based on the answers of the 3 drop down menus. For example, if in drop down menu 1 "yes" is selected, I would like 33.3 % to show up in the text box. If in drop down menus 1 and 2 "yes" is selected, I would like...Leave a comment:
-
How To Calculate percentages in Access???
Hi all,
I would like to know how do you go about calculating percentages in Access.
For example, in a form I have 3 combo boxes with drop down menus where a user can select "Yes" or "No" and a text box where I will calculate a percentage. What I am looking for is something like this:
If combo1 = "yes" then percentagebox = 1 / 3 * 100
ElseIf combo1 AND combo2 = "Yes"... -
Form Options
Hi All,
I have a query that when I run it, it insert data into a table. So my question is: is there a way that in a form I can press one button to run that query and insert the data into the table, and then open that table? Any inputs are much appreciated.
Thanks :) -
Well I created the column such as:
SELECT [Open for Discussions]
so I guess my question is, is there a possibility to insert text into this column of the query?
Thanks for any suggestions!...Leave a comment:
-
Using INSERT INTO
Hi all,
I am trying to figure out how I can go about adding a text into a column of the query that I am writing. For example, I created a column in this query called "Open for discussion" and I want to just add the text "Yes" into one line of this column. I know how to insert inputs from another table or query but I am not sure how to insert my own text. I appreciate any inputs.
Thanks. -
Thank you very much, it worked great!!Leave a comment:
-
Help with Count function in Access
Hi all,
I am trying to create a query that will count the number of items in a certain field. For example, the number of cars listed as "Ford" in the USA. I can do it for just one item, but there are multiple brands that I would like to include as well. How would I go about counting the number of Chrysler's and Chevy's also in this query? Any help is greatly appreciated. Thank you very much.
P.S. Below is the... -
Count number of items in a query
Hi,
I am creating a query where I would like to count the number of specific items in a certain column of another query. I can do this for one item, for example:
SELECT DISTINCTROW[Item List].[Discussion Item], Count([Item List].[State]) AS [Delivered Items]
FROM [Item List]
WHERE (([Item List].[Discussion Item])="Yes") AND (([Item List].[State])="DELIVERED" )
GROUP BY [Item List].[Discussion...
No activity results to display
Leave a comment: