Search results

I want to be able to add a chart to a report that shows the high and low values of 6 fields in a bar graph. Getting the graph to show the high and low values together in the graph is where I am stuck. Any help would be greatly appreciated.

Thank you for your help!

Is there a way to left or right justify fields in the datasheet view of a table? Any help would be greatly appreciated.

Thanks for your help! I will look into that further.

Thanks for the reply! No matter how small I make the report, I still get the extra page. If I do not use the module, the report prints fine. There must be something in the module code itself that is causing problems. If you have any more comments, let me know. - Thanks again.

I am printing 2 copies of the first page to letterhead and the rest of the report prints to plain paper. The report prints fine if there are multiple pages to the report, however if there is only one page, the report prints two copies to letterhead and one copy to plain paper. The copy that...

That's it! Thanks for your help!

Wayne, Thanks for your reply.

I am using a trim function on a report line that will place the address number, address prefix, address street, address type, address suffix, and address extension on one line. The problem I am having is if I do not have an address number or address prefix, the line does not left justify. The...

Pat, Thanks for the reply! I am trying to find a record called test_no. Under test_no there is a field called accept_reject. The field accept_reject can have many entries for every test_no. I want to be able to find the last entry in the accept_reject for test_no.

I have a report based on a query. I want to be able to show a field on the report from the results of my query, but not be part of the criteria for the query. If I add the field to my query, I get more records than what I need. Is there a way to get the field I want to show up on the report...

gblack, I got it to work! Thanks for your help.

gblack, Thanks for the response! I am actually trying to find the highest retest_no for each weight_no. I can group each of the fields, but for some reason I am unable to show just the highest retest_no for each of the Weight_no.

I am having some problems creating a query that will produce the results I am looking for. Here is the problem. I have a table called test. I want to query Cert_no, Serial_no, Weight_no and retest_no. The query will produce a report that will show all Serial_no, Weight_no and retest_no for...

Rich, Thanks for your reply!!! I will try what you suggested. In the mean time, are there other ways of accomplishing the same task?

I am trying to place code into my on click event of my print report button that will print a report to letterhead and plain paper. Ther are two drawers on the printer one is for letter and the other is for letterhead. Listed below is my code for accomplishing this task. One problem I have is...

Ralph, Thanks for your reply. I think your suggestion will work.

Thanks for the reply!! Yes, I have tried both of the suggestions that you sent with no luck.

I have a problem calculating the sum of another calculated field. Here is my calculated field, called total1. =IIf([TYP_CHARGE1]="E",[QTY1]*[UNIT_PRICE1],[hours1]*[Unit_price]) I need to calculate the grand total for the total1 field. Any help would be greatly appreciated.

alanS, Thanks for the help. It worked!