Search results

You have to make sure you have something in the field in order to add it up for you. To do that, do this in your query IIf([A]is null, 0, [A]) What this dose is it looks at the field and if it is null puts a 0 there. Sohaila ;)

Go to the design of your report and find your sorting and grouping button. When the dialog box opens, from the list choose your field and at the bottom of the same dialog box choose group header or footer. Put your fields in the header or footer and look at the results. This is the way I...

Have you tried grouping? Sohaila

Do this in your query: NewDate: IIf([YourDateField]=[YourDateField],1,2). This will put number 1 in your new field and if there is no date it will put number 2. I just don't know why you want to put numbers for your date! Post back and elaborate. Sohaila

Did you check the can grow and can shrink on the subreport? Give that a try Sohaila

Number: Round([Yourfield],3) Sohaila

There are several ways you can do that. In your query where your date is you can put "Like [Enter Date:]" If the user puts in just a "*" they will get all of the dates and if they put in "3/*/*" they will get all the years in March. You can also do this "Between [Enter begining date:] And...

Use crosstab queries. Sohaila

Refer to this posting, it might help! http://www.access-programmers.co.uk/ubb/Forum5/HTML/002940.html Sohaila

Did you set up your column headings? If not, go the the design mode of your crosstab query and the properties of the query and set up your cloumn headings. Remember they have to exactly match the name of your fields, otherwise, it won't work. I think that will solve your problem. Sohaila

I think what you are looking for can be found in the Northwind Database. Look at the customer phone list in the macro section and how they have filtered and in the form Customer phone list, where they have applied it. I missunderstood your question. Sohaila

In your query behinde the report put in the like statement like this: like [Enter your last name], Now if the user opens up the report, it will ask them to "Enter your last name" and if they put in b* for instance, it will show them all the last names that start with b. I hope I answered your...

Put this code behind the checkbox event property click: If ([YourChecboxName]= -1 Then me![YourFormName].visible else me![YourFormName].Not Visible End If Sohaila

Do this: Like "b*" in your query and it will only show all the last names that start with B Sohiala

Group your full time employess and create a header and footer for full time, and put your field that are related to to full time employees there. That will total each group. Sohaila

make your query criteria equal to is not null. Sohaila

Did you set up your column headings? If not, go the the design mode of your crosstab query and the properties of the query and set up your cloumn headings. I think that will solve your problem. Sohaila

Refer to this posting it might help! http://www.access-programmers.co.uk/ubb/Forum5/HTML/002807.html Sohail

Very easy: Make a text box and make the control source =1 and click the data tab and choose overall for running sum Sohaila

In your query put this : Between[Enter Shipping Begining Date:] And [Enter Shipping End Date:] You see the critaria that you have in your query has to exactly match the same on your report, otherwise, it will not work. Let me know if it works or not. Sohaila