Recent content by DBFIN

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 ?