I could use some help. I know I can do it the long way round but I know there is a quicker better way.
I am creating a activity database where people will enter a set of predefined items in to a form. I have the basic info... name, dept, number of call outs, number of repeat call outs. then I have a about 10 rows with the same named fields.( each row ads a 1 or 2 in the table.) location, service#, customer, time,...ect So they can enter the detailed info up to 10 calls.
My issue is I have 1 field with a combo box... DI or BI or DI and BI. I need to count up the amounts of DI or BI and if its DI and BI either count that up or add it to the other. but Im having trouble doing that.
I have 10 rows on the form with db/bi1, db/bi2,.....db/bi10 on each row. They are all in the same table because I couldn't figure out how to separate the information part with the activity part. The tech will do a sheet everyday and list all his calls and the results.
I need to run a report each month and say we have had 100 DB, 40 BI and 30 Both. (or add the 30 to each). The field is a combo box with short text so Ive tried to use the count, which works on one field. When I try to do it to more than one field it doesnt work.
My workaround is having them total it up as a raw number and deal with it that way, but I was hoping to make it easy on them and have the database do the totaling.
Thanks