Search results for query: *

Thank you so much that worked perfect!!

In access repots I want Field A to populate with Field b*Field c if field d = yes and Field e = yes. And If field D and Field E are not yes I would like to see zero dollars. Example below: Field B 50 Field C $1.00 Field D YES Field E YES Result I need: Field A $50.00

Thanks that worked really good, I went with your first example. I appreciate all of your help!

I got the exact same structure as before when I used above program. I have a simple table with 5 columns in it and I want to first see if they are completely populated or not..if they are not populated I need to delete them from my table. .. The columns are numeric. This is what I was doing...

Thanks that worked perfectly!..Sorry If I wasn't clear but I needed to find and delete if a field(not record)is empty. Thank you again for your quick response!

How can you tell if a field is empty and if it is empty how can you program to delete it.

Thanks again.. The light bulb clicked I now understand and have hold of distinct and how it works. This really is a new way of thinking from VFP. Anyway it worked and I so appreciated it! thanks again for all the help from everyone!

sorry.. I'll try to explain better.. My table has say 4 fields in it. Two id #'s..one for the member and one for the provider. One quanity count, and one specgroup. Look like this id#1 id#2 quan specgroup 444 matt 2 tp 444 matt 1 tp 888...

I now got this: select distinct whatever, count(whatever) as Amount from mytable group by whatever Would have returned: 8888 3 4444 2 But... What if I have 2 different counts that I need 8888 3 5 4444 2 3 I tried this: select distinct whatever,whatever2 count(whatever) as...

Thanks! I will try it..

I am completely with you...thanks a million! Maybe you could answer this for me though...I also need to assign a unique identifer to each unique field so can do a count and a comparison for instance. If i created the field cnt I would want my dbase to look like this. idnumb cnt 88888 1...

Thanks! Perfect!!...i guess i was thinking too much about it

I'm new to SQL and I need to count a unique record in the field. I tried.. select count (distinct ' ') as but it didn't work the way I wanted it to. Dbase example: idnumb 88888 88888 88888 44444 44444 I need these results: 88888 3 44444 2 I know this is really easy..but...