Search results

I have a table with that has a value and % AMT PCNT 0 0.00% 36000 0.50% 46000 0.80% 52000 1.00% 58000 1.30% 64000 1.50% 72000 2.00% And another table with crew and an "VALUE" earned. CREW EARNED Bill 32000 Todd 57508 Mark 67204 Donna 76118 If a value is >= an "AMT" I want to display the...

So I'm trying to get the look, caption and the result of a click on a command button based on the refreshed data contained in a subform. This needs to be dynamic in that as a new date on the form's calendar is selected, the results listed in the subform will change based on that date and I need...

Hi, I'm building a workCube reservation system and I've been tasked to have it work kind of like an airplane seat reservation system. I've laid out my form with option buttons representing the location of each available space. (space1, space2, space3...space16) My desired outcome is to be...

In the Access 2003 I could sort my list of objects by clicking on the "COMMENTS" Column Header. I can't figure out how to do that with 2010? We have several processes used by different players and various queries and grouped by comment phrases in the Comments. Is there a way to sort the...

I have a report which is comprised of several sub-reports which all format according to a set of variable. There are times when the resulting query produces and empty set. I need the sub-report to display a black box when the underlying query produces no results. I then need the black box to...

Very new to the IRR function and don't know if I can do what I think I need to do. Have data something like this: Prem____TermPrem____TermDropYrs____PremDropYrs____TtlYrs 1000______158__________7______________20__________30 1437______281_________15______________12__________35...

I'm trying to build a rank based on a premium value where the smallest premium is ranked 1 and so on. All is working fine except when the premium value =0. example a. (this is good) Premium Rank 765 2 800 3 535 1 example b. (not accemptable) Premium...

Here is another version of the old song. I have a field which considers two logical fields and if either is true, return a string phrase, if neither is true, return a value. ReportPremium: Format(IIF([LogicA] = True, "LogicA", IIF([LogicB] = True, "LogicB",[Premium])),"$#,##0") This all gets...

I'm building an application for a charitable org who is doing an auction dinner. I'm trying to assist the person entering the attendees with seating requests. They have 30 tables with 10 seats per table. In the data entry form, I created a space to enter the desired table number. Also on the...

I have a report which tracks data on a monthly basis...In my report, I group results on client and show all historical data for each client... Report looks like: Record Count ExtractionDate Value 1 31-Jul-06 $872,363.79 2 31-Aug-06 $887,975.98 3 30-Sep-06...

I have a database that has been functioning very well for nearly a year. Suddenly today, as I attempt to open a report (very complex report takes about 2 minutes to render), the database closes before displaying the report. I have moved the db from the server to my desktop and the same problem...

Hi All, I have a comboBox set up to locate an auction item to be able to enter winning bids. Problem comes when I select the correct choice from the comboBox, the proper record displays. When I move to the winning bid entry field to add amount of bid, the record changes to the next record in...

Hi, I am trying to continue the process described below. We are taking a query from an active database and creating a table in a remote db in the network...we want to take the next step in the process to now copy the destination database and have the user save it to a location of their choosing...

Can I move a column horizontal postion based on another column? I have column A, B, C & D I would like to have Column C slide left if no data in column B. Is this possible? Thanks, George

Hi All, While creating a report I have a list that I have sorted in lowest to highest and then ranked accordingly. I need to keep the ranking sorted lowest to highest with one exception. I have some records that have a null value (could be zero, but currently null). I need to have this value...

Hi Everyone, I have a procedure that determines if an item is in the list or not. If not in the list, gives me a message box with the option to add the item to the list. If option to ADD is chosen, the proper form opens up and I am able to fill in the information and then when the form...

I looked at the history and I don't see my situation discussed. Sorry if I missed it. I need to get page number to reset to 1 at the end of a sequence, but I do not have grouping... This is essentially a mail merge document and at the end of the last data field, I need the report count to...

I have set up two queries to generate a rank order based volume generated. The query does what I want for the most part in that if two parties have the same volume, they have a common rank (this is what I want to have happen). The problem comes that at various points throughout the data set...

I'm trying to have a query open via choice of a pick item instead of a parameter. Instead of having to type a name exactly as appears in the table, I want the query to give me a choice. This query will be the underlying datasource for a form. I want the form to open based on the choice from the...

I have an job estimation tool that I'm trying to clean up. I have a main form which displays a running total of several values generated in any of 10 sub forms. Each subform is contained on an individual tab. Each subform calculates values based on choices within the subform. If the check box is...