Search results

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...

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) <>...

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...