Search results for query: *

I have date field, I want to show on the report, start date (lowest date) and end date(latest date). Need help with formula please. Something like, 9/1/09 - 9/18/09. Thanks,

I put the following formula, calculation works. when highlighted this field to "Sum (total)", it show is "Move" instead "instert summary". Any tips please to "insert summary" (want to total this field). Thanks, if {JCT_CURRENT__TRANSACTION.Accounting_Date} =...

Please see below, real data. Here I have '02', grouped by descripion, where it has real costs. I have groups by descrition 1 to 34. My goal is, I want to show $ 100 (could be $.10c) where there are no costs for that group, means I want to show all 34 lines/rows. Hope this helps. Thank you...

Thank you for the reply, hope you will find the answer. This data is grouped by description and showed totals only. Detail records are suppressed. Since "02" does not have data/amounts, I just want to show like below 02.Description --- 100.00 Thank you,

See below, output data, watch on left after 02 is missing, 02 should be showing 100. Check my formula also. May be something wrong in the formula. Thank you. Description --- Amount 01. Desc. One --- 14,531 03. Desc. Two --- 318,605 04. Desc. Three --- 227,227 05. Desc. Four --- 298,741 06...

I have the following formula, if there is no amount I want show $100 (meaning now blank row). But the following formula is not showing any value. Can somebody please fix the formula. Thank you, if {CURRENT__TRANSACTION.Accounting_Date} < 8/1/2009 then if...

See if this helps, if {Order_Details.UnitPrice} > 10 and {Order_Details.UnitPrice} < 19 then "********** "&ToWords ({Order_Details.UnitPrice}) else if {Order_Details.UnitPrice} > 20 and {Order_Details.UnitPrice} < 29 then "*********** "&ToWords ({Order_Details.UnitPrice}) else if...

Thank you.

I am creating labels/form letters with the the following data. If I do not have "Address 2" I want supress that row and move up the "city" up one row to replace "Address 2". Can I get some help please. Thank you. Name Address 1 Address 2 City State, Zip.

I want to write a formula to pick the latest date and amount(most recent).

I have the following dates and amounts fields. I want to write a formula to pick the latest date (most recent). Can some body help me please. Thank you, 04/09/2009 - $12,000- 06/18/2009 - $9,000- 04/17/2009 - $16,000- 07/15/2009 - $1,000- 05/11/2009 - $8,000-

Thank you sir.

I am pulling data from timberline, transaction table. This table has two fields acct_date and amounts. If I put from and to acct_dates (5/1/09 - 5/31/09) it gives me that criteria amounts (Column1). This is good. Now - Besides this column1 I want to show amount in another column (Column2) "from...

John, Thanks for your response. I know this simple </tr> <tr> breaking. There are other strings attached to it in breaking data. Also, please I am more than happy to answer to questions what I know. I am not aware that anybody can answer here in this forum.

I have about 20 fields in a table, I want display all these 20 fields in two rows, first row will be 10 fields, and second row will be 10 rows. How can I break like this. Please advise with code or some links. Using ASP /MS Access 2003 / XP Thank you.

See the attachment repott/mdb In crosstab report, in rows box I want to insert 'aca.year', column box I want to insert 'status', and in summary box I want to insert 'countNR' (this countNR I am counting, not sum). Any help will be helpful, Thanks.

I created a crosstab report in v10 with few formulas and I can see/use all formulas. I created the same crosstab report with same formulas in v8.5 and I cannot see/use all the formulas in v8.5 and with this I cannot create the same report what I created in v10. Am I doing something wrong in my...

I have created a report in version 10, and I want save that report under 8 or 8.5. I want use this report under version 8 or 8.5. Is there any option in version 10 how I can do this. Thank you.

Sorry to drag this, yes, I did inserted the formula in detail section,not in a text box. The Other questions @sex comes from different kind of formulas, it is hard put it here. Thank you,

if {@sex} = "Female" then 0 else 1