Search results

Thank you, that works.

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

Thanks everyone for your quick replies. Your comments provided the perfect solution to my issue.

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 ?

I found the issue. The query was summing a field with a convaluted expression, which I replaced with a simple Sum function and the record is no longer missing. I don't know why this fixed it, but it worked.

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 resolved this by adding group in group box, clicking more, selecting with footer, adding textbox. :)

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.

Thanks again !! :)

I think I may have discovered the issue, the field is formated in text, can't sum text.

I researched both the layout and design view methods, the sum option is gray either way.

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 figured it out, must leave box unchecked when selecting External Data, Text File.

I need to create specifications with delimiters that define field lenghts for each field.

I just ran the macro and discovered the specifications were corrupted. How do I recreate the specifications ?

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 corrected the syntax. This works: DateDiff("d",DateSerial(Left([TERMDATE],4),Mid([TERMDATE],5,2),Right([TERMDATE],2)),DateValue(#1/31/2014#)) :)

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 recreated the form using a form header instead of a page header, this did the trick, thanks again everyone !!

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 ?