Need help !!

[Guest_imported]

Hi,

I need to find all record for one insurer in my database and i don't jnow how i can do that !

i got 6 columns where i can find "the insurer name"

thank for hrlping me..

 

[paulovey]

Hi,

What sort of Db are we talking here is it an access Db or just a simple list in excel.

More info please!!!

Paul

 

[smiley0q0]

what do you need to do with the info once you have found it or do you just need to know where it is? this is very vague... like paul said,
please provide more specific information

 

[Dreamboat]

Twin, did you not straighten out your database tables yet? Is this SMI-0303.mdb? Let me know if I can help!!
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[SimonDavis]

Just something to try, assuming it's an access database, and a simple list.

If you have all your data displayed unfiltered on the screen, you can click on any field, right click with the mouse and click 'filter by selection'. This will just display every record with the same data in the field as the one you selected.

This depends on a lot of info you haven't supplied.

 

[Guest_imported]

The project is for a company, which deals with insurance. (I’m doing a training there).
Basically, the info on the database have to be send to a “bordereaux” (sheet). There is a bordereaux for each insurer.

First, with the info of the DB, I produce an invoice and then I ‘update’ the insurers bordereaux. The calculations are a bit complicated (see below)
Imagine an invoice with a premium and a tax e.g. Pr £150 tax 5% £7.5
Given that the cie got brokerage on every order, let’s say they’ve got % on this one.
So, one the insurers bordereaux, I would have to show :
Pr – broke +tax = £150 -
└>only taken
from the premium
before tax.

£150 – (10% +£7.5) = £142.50
└> total due to the insurer.

On top of this, two things :

1) Sometimes there’s no tax
2) Sometimes they give some money back to the client. In that case, I have to update the ins bordereaux as follows :
Pr – NCB = A
└>money given
back to the client ===>it’s a % of the
premium always taken away net of tax&brk

A – brk = B

B + Tax = C

C = total due to the ins.

150 – 20% = 120 (A)

120 – 10% = 108 (B)

108 + tax = £115.5


Another thing, the insurer do not have the same proportion but the % of the ins on the database should always 100 !

Can you help ?

I really want to pass my training & I’m already running very late on this project !