mrpolecat -

Thanks for the informative response -

I can't troubleshoot if I don't understand what I'm doing.  It was so simple it would have taken me a long time to figure...

mrpolecat -

I have tried this about 8 times moving things around but every way I position the *100 I get a result of 0

do me a big favor and put...

so why did I have to use the following in order to get my percentage to be accurate with decimals? 

(COUNT (AREA))/(COUNT(UNITID)*.01)) AREA_USAGE,

area is varchar, unitid is varchar

It works the same way as in Access.  In Enterprise Manager, right click on the table and choose Design Table.  Highlight the column, drag and drop.  I also appreciate being...

Thanks so much, Sergiy - exactly what I need!  Really appreciate it.

Hi -

Thanks -

I can't change the application defaults.  Can I include something in the query that will effectively do the same thing? 

You can create a formula for the field that gets populated based upon your two variables.  If I understand correctly, check these out as samples of where to start

IF DatePart...

How about a separate table that holds the identity sequence and a "getnextid" stored procedure on each of the other tables?

Thanks SO MUCH!  This is up and running, and I now have a great deal of study to do to fully understand the implementation.

This is such a great resource...

Thanks for your response, but I'm still missing the point.  The following is what I will need.  The Usage field will change for every reading.  What I'm trying to achieve...

Alternatively - Right click Table, Choose Design - right click for properties

We have been working with both of these companies

http://hansen.com/

http://www.accela.com/