Search results

First you should use a underlying Query for your Report. Do your calculations in this Query. In the last field of the Query your calculation should be QuantityPercent:[Quantity_A]/[Quantity_B] In the Criteria Field place (just below this calculation) <.80 This will show only those...

Going with statsman directions you only need the Report underlying Query.

On your Report Group by your Date Control. Has Header Set it Heigth to 0" and Footer this is where your txtbox should be Recordsouce =Sum(SomeotherContol).

On your report just below your second subReport, place a text box. For its' recordsource use the Expression Builder to bring these two figures together. =[subReport1].[Worked1]+[subReport2].[Worked2] Hope this Helps

To have a Dialog Form over top of your preview, makes no sense, you can not view the report. Simple solution press ctrl and P at the same time, this brings up the print Dialog, press Enter and your report prints in hard copy (on paper).

In you Group By Query have you tried Last. insread of max.

I think that I know what you want to do If no date range is chosen you want to show records that the date value is Null. Or is the Null value in another field.

In the criteria of the underlying Query of your subFrom, Do you have your main Forms relation to the subForm.

No Sir, I understood, although a picture is worth a basket of words. If you have to list the colors, how about a Pop Up Form that is activated from your Main Form via CommandButton. That has a MultiSelect ListBox displaying a listing of your colors (this will give some growing room), also a...

In each of the Criteria Fields of the Query that you are useing, use the code below. Like IIf((IsNull([Forms]![FormName].[ComboBoxName]),"*",[Forms]![FormName].[ComboBoxName]) Change the FormName and ComboBoxName to your names. What this will do is, if the ComboBox is emty (Null) then All...

I believe that you would better off createing one Table that is used as a Lookup Table. And use this as your RecordSource for your colors CombBox. Something like: ColorsID: Color: ColorDescription: As an example, I will use four colors. 1;R;Red 2;G;Green 3;Y;Yellow 4;Bl;Black 5;RY;Red,Yellow...

would need more info to correct this. I'm takeing for granted that your subForms are linked to your main Form. Or are subForms linked in cascade? What information are your Form and subForms showing? How many subForms do you have on the Form? Are trying to Filter the main Form, then do seporete...

What is it that you are trying to view in this manor, is it something like SalesOrder info with SalesOrderDetails info? Will these Controls need to updateble, or are they just for viewing. There may be a better way.

What are the color relations to your widgets? Are your widgets seporate products that come in different colors? If Not, do you always want to choose one color or eight colors? No other chooses like maybe three colors? Need some more info as to what you are attempting to do.

To start, is the "2005" that you are refering to, is that a year or a formated date. Your problem can be solved by making few Queries for the information that you want. Place them in the underlying Query of you Report. As for selecting of a Date range, use a Dialog Form. You can use the...

If I get the jest of what you want to do. Do you want to make a selection by viewing the persons image by useing a ComboBox. If so, to my knowledge that not going to happen for you directly,ComboBoxes are not made to do that. Give a little detail of want exacly you want to do. I've done...

Yes Sir Not knowing how you Queries are buildt. I would suggest useing Combo Box to choose the Customer. And you have to let the other Queries know (So to speak) what Customer you are searching the information on. I would need a little more information to tell how to do this.

Try the web address below www.helenfeddema.com/access.htm look for articles 106 and 112 they should help you with what you are trying to do.

I'm taking for granted that one or both of these date fields might be emty (Null), is that correct. And that you want show only those records that have one or the other or both fields with a date in the field.

Try "IsNull" in your query criteria, this will show those that are emty