Search results

yea i figured this out eventually, but thank you very much for taking your time to answer my question!

I need to enforce something at the table level which makes sure a certain field value can never be 0. Does this somehow involve the Input Mask, and how would i go about implementing something like this? Thanks

I want to make a query only do formatting if a certain set of criteria are met (field value does not equal 0 or null). Can i do this after i type the SELECT statement, such as: SELECT IIf([Field] = 0 OR [Field] IS NULL, [Field] AS [FieldRep], Format([Field] AS [FieldRep], '0.00%')) FROM...

Thanks again. One more question...Exactly where in the SQL would i put the Format function you described earlier? Thanks

ahh...yes that does make more sense going back and looking at your first comment :D quick question...how does one make an "and" statement in SQL? Thanks again!!

ahh. i think i have found the problem. When the value of the field used to determine the calculated value in the query is 0 (not a default null, but rather "automatically" set to 0) it tries to do 0/0 and thus the #Null! is produced.

this works until i actually set another user entered piece of data in the same query as the value the caculated value is from. The moment i do that within my form, i get the #Num! thing again in the calculated spot on the form.

0.00% in my form would be nice

but i am trying to display these calculated values in a form formatted as percentages, and when i put in the Nz function, all my percent styles in my form turn into decimal style now

How do i input my "custom" value as a percentage? I followed the Nz([calculated expression], default value) format, but when i type in Nz([Calculated expression], 0.00%), i get an error due to the the 0.00%, and i want to input my default as a percentage.

how would one go about implementing an nz function? (i am an Access Novice)

I have a query that calculates a number of percentages based on data input into a table and i need to set a default value for these calculated values so that i dont get a #Num! or #Error thing if a proper value cannot be calculated. The SQL is kind of ugly but here it is: SELECT [CRM2...

Hello again. I am trying to set the values for a Link Master Field of a Microsoft Graph (Not PivotChart) based on whether or not the current values in two comboboxes are equal to on another. Here is the code i have right now: Private Sub SelectAW_AfterUpdate() If Me.SelectProg.Column(0) <>...

Everyone, thank you sooo very much!!! It all works like a charm now!!! Private Sub SelectAW_AfterUpdate() If Me.SelectProg.Column(0) <> Me.SelectAW.Column(0) Then Me.Graph10.Visible = False End If End Sub One more question...Since the SelectAW values are actually numbers and the...

I did this b/c of the following properties of my first combo box: Row Source Type: Table/Query Row Source: Delivery (a type of table) Bound Column: 9 (This is the column on the table where i need the data for the combobox to come from) Column Count: 9 Column Widths...

How would i reference the first combo box from the afterupdate section of the second combobox?

it stopped raising the error thanks to the "THEN" suggestion, but i still dont know which section of the form to put the code in

i still keep getting a wierd Then if Go To error every time i leave that line. Heres what i put Private Sub Form_Current() If Me.SelectProg.Column(8) <> Me.SelectAW.Column(0) Me.Graph10.Visible = False End If End Sub still raising errors

I have a form with two combo boxes on it, and i want to create a valid If statement that will execute some code that if the current contents of the two combo boxes (SelectProg and SelectAW) are equal to one another. I tried this statement but I keep getting an error. Any explanations...

I know some of you might think "hey why not just use Pivot Charts?" but I really want to do it this way b/c the Pivot Chart pie graph does not display percentages. I first tried the example described in the link below: http://support.microsoft.com/?kbid=208335 I am using Access 2003. I used...