Recent content by MonkeyMaster

I just wanted you to know that the file oyu sent me was exactly what I was looking for. I really appreciate your help, it would have taken forever (perhaps literally) to find that myself. What I was missing was the simple thing...I did not know about the First sort by feature in queries. Anyway...

Thank you so much for your help. I will let you know how it works.

Thank you for the offer...though there are two barriers. I don't have '97 and when try to convert it tells me that I am missing at least one object library that will have to be fixed in 97 before it will work. I can convert anyway (I don't have much experience in convertions, so maybe missing...

sorry I have not replied to your post Rich, I am west of you, so I went home from work around 6:00pm (my time) Perhaps I am misinterpreting what you are saying. but as you can see from my example, there are duplicates in the ClientID as well. I don't know how to make a query to take only the...

the underlying table looks something like this ClientID AmountOffered AmountClaimed 2031 $1200. $800 2032 $1500. $230 2032 $1500. $270 2032...

unfortunatly I cannot alter the tables or their relationships. I work in an arm of the Canadian Government and it's their baby. they just tell us to pull stats...but it's the financial arm that wants them, so they have no idea how easy or difficult and given task is.

calculations in the report alright, I have a table. It has the ClientID field, the AmountOffered field and the AmountClaimed field. for each ClientID there is one AmountClaimed amount and several different AmountClaimed amounts. To make this possible in the table (which I did not design) there...

there is an example in the Northwind 'base but I am not sure how good it is. I am working on something similar, if I finish and remember I will send it (if it works)

Thanks. I no lomger smell the sizzle of my own bacon.

This may be a dumb question, but I am just a first year student... I want my switchboard to open automatically when the database is first opened without any input from the user. Is this possible??? Thanks