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

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

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

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

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.

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.

I have a formula field which returns 0 or 1, I want to count how many 0s and how many 1s. I formatted this field as numaric. Then I try right clicking on this field it gives me 'move' instead 'Insert/grand total or summary" Can some help how to do this. Thanks in advance

I took over a new job. I have report created by previous employee. I have 'country' field twice on the report next to each other. I can move one field and the other field I cannot move (and it is grayed out). Is there any way can take off that gray out and move the field around. And also how...

I want to show %Complete with two decimals, like if trade is completed 20.22%, I want to show it as 20.22%, not as 20%. Any help please, Thanks,

I have 3 icons/small images, all these have href links. dark1on.gif,dark1off.gif, dark2on.gif,dark2off.gif, dark3on.gif,dark3off.gif, I have a href link to dark1on.gif, when I click on dark1on.gif I want to go to this href link, and show dark1off.gif showing or identifying, that I am in this...

Windows XP pro / Javascript I have two images, 90x90 and 160x160 sizes. I am looking for javascript mouseover code, if I mouseover on 90x90 I want to see 160x160. Not the same size as 90x90. Any help please Thanks,

I am looking for MS Access 2000 / PHP authentication (ODBC) tutorial, for user login name with password to access certain pages. Can you please give me the link or code. Thanks.

I created form in MS Access 2000 / XP, put it on the network,but for some reason, all users cannot use this form at a time. One user only can use this a time. Is there anyway I can fix this to use this form by all users. Do I have to change form properties, or change network setup ? Thank you,

When I run this I can write "userid" where you see Welcome, But it is not working with my sql statement. Need code help please. Can somebody fix this. I tried GET and POST, no luck. Thank you, ---------------------------------------- Welcome <?php echo $_REQUEST["userid"]; ?>.<br />...

I am getting the following message, when I installed mysql client version 5.1.11. I get this message when I tried to connect through PHP. I am using, windows XP professional. Any help please. Thanks, "Client does not support authentication protocol requested by server; consider upgrading MySQL...

I created a mail merge with ODBC with access 2000 and word 2000, it works fine. I use it get out. Then when I try to use it next time or in next day, it always asks to 'find odbc' or database file/location. Is there any I can fix this by passing this 'find odbc' question. Thank you.

I have a small question. I copied Northwind.mdb from my home desktop to my notebook. While I am on the road, I created some new queries, when I get back to home, I copied to back to desktop only newly created queries. (since data is same in tables, in both handheld and notebook). Is this okay...