Search results for query: *

Hi all, I want to create a formset and add an already existed form to the formset. Here is what I am doing. Created a form with an option group that has 2 options (two different departments) select one and then i want to direct to the department form that is approperate for the selected...

Can you use distinct in a detailed trial balance report in Impromptu without having the integrity of the data compromised

Can anyone give me a stable way to create a report that has detail lines (one to many) and a summary line on that account (one to one). I have created one but it is not stable.

Can anyone advise me if there is a way to step through a report and find where a calculation is doubling an account? This is only happening on one account number on the report. I have verified the data and there is not anything wrong there. Any help would be appericiated.

I have a total line that has three calculations (beginning balance, activity for the month and ending balance). On all the account on the report the totals are correct but on one account the amounts are doubled on all three calculations. I have checked the account and there is not any double...

i have a report that has a break that produces a summary line and on this line i have 3 calculated fields. the results are correct on the report except for 2 different account numbers and on these the amounts are doubled on all 3 calculated fields. I have checked and rechecked the data in the...

How do I get the Prompt_Month and Prompt_Yr to display in the header with a Maxium enddate. EX. Prompt_month = 5 Prompt_yr = 2004 I would like to have the date of May 31,2004 in the header.

I have a calculation in a balance sheet that doubles the amount and i can not find my problem. I have checked for double records, not that. checked the calculation all it is [sum if yr = prompt and period<= prompt then 'full value' else 0.} this works in other BS but in this BS it wants to...

Is there anyway to hide a S1 Footer in one area of your report and have it visable in another area on the same report?

How do I get a total on a total and then total on that total and they all have to be at different breaks in the report.

I have about 300 account codes that need to be filtered on and in was wonderin if there is an easy?? way get them in the filter without keying each one in? A between will not work as they are not in order. any help would be appriciated

is there a way to have my data (column)displayed horizontally?

How can I get a date calculation (if period = Promptperiod and yr = promptyr then enddate else NULL) in the header. fields period,yr and enddate are in a table that is linked to my balance table. any help will be appriciated

i have a table that has duplicate data. my question is can i run a query that will eliminate the duplicate data? then how do i do it as i have only limited experience with queries. THANKS

OK you guys the WOI (Wall of Ignorance) is standing in my way. Will someone please peck around the the end of this wall and give me a helping hand. Here is my question. I have a next button that does nothing. SKIP IF EOF() =MESSAGEBOX(&quot;This is the Last...

I have a from with a combo box that I want to drop down a list of member after the last name is entered. example: 1. enter 'jones' in combo box 2. click search button 3. I want the combo box to display all the members with the last name of 'jones' 4. From this list I want to select...

how do i get my array to sort and display in the listbox by the year field in desending order?

i have a table that shows all the fields in modify mode but in browes mode all i see is 5 fields. what did i do to cause this to happen. and how do i fix it to browes all the fields because i have to append another table with the same field format. thanks for all you'alls help

I have a form with a name field(last,first,MI)after entering you then select the button to display the entire file in alpha order. My question is how do I get the table to go to the first entry of the last name. example: name field: smith john M When selecting the button i want my cursor go to...

I have 2 tables, tabl-1 has a yrfield as XXXX, tabl-2 has a yrfield as XX. I appended tabl-2 into tabl-1. My question is how do I get the year field in tabl-2 to be 4 chr.