Search results

I used a simple Val() function to convert $50,000 from text to number, but it returns a value of zero. The script is a follows: BI_DED_AMT: Val(IIf([Factor PL_Deductible]="None","0",[Factor PL_Deductible]))

I want to use the mod function in a query to evalate whether the "Year" field contains an even or odd year. Years 2016 ,2014, 2012 would be even and years 2015, 2013, 2011 would be odd. How can I use the mod function to do this ?

When I run a query in a macro it is missing one record. I have a very simple query that reads Table 1, groups on three fields, sums two fields and makes Table 2 without any filtering criteria. When I run the query separately it is not missing this record. My research shows that this typically...

I grouped by report by Sales Rep then added a total for Sales Rep in the report footer. The total works fine, but there is no header describing the subtotal for each group, the report shows only the subtotal with not description of the subtotal.

I'm trying to add a field total by clicking on the field and then selecting the sum function while in layout view. The sum function is grayed out, so I am not able to add a sum.

I created a table with an older version of MS Access which was replaced with Access 2010. I was able to export the table simply by selecting specifications that I created. How do I export with these same specifications in Access 2010 ?

I'm tyring to calculate the difference in days between 20140131 and the POLEFFDATE field which is a number in YYYYMMDD format. I've used the following syntax, but get an incorrect result, 223924. What is the problem with this syntax ...

I created a form with a continuous default view and created labels in the page header of the form. When I view the form, I can see the data from the form detail, but the lables in the page header do not appear. Why can't I see the labes in the page header ?

I'm using the exportwithformating macro action to export a report to a pdf file. The report data source is a query that reads a table of 100 brokers. The macro is repeated 100 times so that 100 unique reports are generated for each broker. How can I code the output filename so that it varies...

I want to add a page number to a form in MS Access 2010. How do I do this ? There is no page number icon in the control group when I'm in design view.

I'm using the MS Access 2010 ExportwithFormating action to export three tables to a single MS Excel 2010 workbook. The action overwrites the first excel worksheet each time instead of saving all three worksheets in a single excel workbook. How can I export three tables into a single excel...

I have a text percentage that reads 28.0%. I want to convert to a numeric percentage that reads either 0.28 or 28.0%, preferably the latter. The Val function returns an error. How do I do this in a query ?

I have a POLEFFDATE field with dates in date/time format. A single record has POLEFFDATE equal to 12/15/2013. I calculated a simple field called EVALUATE as follows: IIF([POLEFFDATE]< 1/1/2014,1,0). EVALUATE should equal 1 for this record, but it equals 0. Why ?

How can a reformat a number from 23 to 23.00 in a query. The format functions reformats it correctly but converts the number to text. I need to format the number as 23.00 and maintain the value as a number, not as a text. How can I do this ?

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

Is there a way to convert a phone number in text format into a number and remove any dashs or parenthesis. What function can I use ? old format (951) 244-3011 new format 9512443011

I want to add the following security features: (1) hide the toolbar that shows access objects (2) hide all access objects such as tables, queries, forms, macros. How do I do this ?

I have two separate fields that contain a date and time. Entrdate Timestamp 1/8/2014 10:12am 1/20/2014 8:33am How can I convert these two fields into a single field with normal long date format like 01/08/2014 10:12 AM ?

My company recently upgraded our computers from Windows XP to Windows 7. After this upgrade, a very simple MS Access 2010 query would no longer run. The query, QUERY 10, simply prompts the user to enter a value in the policy effective date field with the following criteria: >=[Enter Monthend...

I'm using an import export spreadsheet macro command that uses a pre-defined specification to export a table from the database to a text file on my C:\ drive. The macro worked fine until our IT department migrated us from Windows XP to Windows 7. I receive an error message: The text file...