Search results

Thanks, I give it a try

I have attached a sample DB For each docket number the query is returning two records. One for each names attached to the docket number. The names on the two records are from the same family and I want one line with the docket number and both names.

Yes, that is correct

I have a query. It has two tables, one CINT3 AND one NOLDBA_COURT_CV_002_PARTIES the tables are joined by the field DOCKET_NO. The problem I have is that when the query is run and there is more than one NAME_FIRST, NAME_LAST, ETC. I end up with several lines with the same DOCKET_NO if there are...

Thats what I thought thanks

If I send a completed report to someone is there a way that the recipient can sort that report. Is there something that I can add to the report to allow them to do this?

I'll give it a try. thanks

My table has 4 fields which I want to combine into 1 The first field is BATCH_DATE The second field is SOURCE The third field is BATCH_NUMBER The fourth field is RECEIPT_NUMBER BATCH_DATE returns a date including forward slashes SOURCE is a one letter character BATCH_NUMBER is 4 numbers which...

I got it, thanks MIke

I have two tables. Each table has a primay key which is "member number" in each table. Say table 1 has 250 records and table 2 has 100 I want all the records from table 1 and the 100 records from table 2 which are matched on "member number" So I would end up with table 3 which contains 250...

Got it, thanks!

That worked! thanks

Now I do get an amount reather than Div/0 error, but the % is showing up as the ARREARS PAID amount. I have attached a screen shot.

I have the following control source in a text box. When there is a CURRENT OWED amount field there is no problem but when there is no amount in the CURRENT OWED field I get the error #DIV/0 =Sum([CURR PAID])/Sum([CURR OWED]) If the CURR OWED = 0 I GET #DIV/0 ERROR Would someone show me how...

Well all I can say is that it was a long trip. Your last code worked. Thanks so much! Mike

In the report footer I have a sum of all the records in the columns, ARREARS PAID and AREARS OWED. In a new text box in the report footer I thought using a control source of =Sum([ARREARS PAID])/=Sum([ARREARS OWD]) would tell me what the % of PAID to OWED. Like ARREARS PAID is $100 and...

When I use the code you have here I get a percent of 0.51% If I manualy figure the percent of $2,679,692.02 / $503,862,608.08 I get 0.005318299 Why the difference?

If I understand what you're asking. The 100 would be CURRENT OWED And the Total would be CURRENT PAID

Here is the DB Thanks Mike

I still can't make this work. Please see my attachment which might help explain what I'm trying to do. If possible please go into details of what I should be putting where. Thanks Mike