Search results

That would work for you or me but the gal that is going to be running this thing would be totally lost. I think I can work through the Affiliations with her, but the MARS choices are still letting you make multiple entries and you can only belong to one of the MARS groups (Air Force, Army, or Navy).

On the first demo, I need to have the boxes laid out horizontally instead of the vertical selections. I need them to be in a line instead of a selection list. Affiliates can be one or all on that list. I'd like to check the ones that apply to the operator. The same for MARS. Is that...

Thanks, I'll do a redesign. I'll probably have the sub forms in separate windows to make it easier for her.

Ok, I have redesigned the Database. I have put affiliates, dues, license, and MARS in separate tables. I have attached my latest attempt. I took out some of the information in the Roster table. Now the lookup form is allowing me to select multiple items in the MARS and License sub...

I goofed. The MARS operators can only belong to one MARS branch. Therefore I am back to making only one selection for each operator. The license classes are the same situations. Having said that, I have created a new table for mars. I am drawing a blank as to how to connect the two and get the...

Never Mind, I found it. It was a missing control source for the checkbox. Sorry :o

I have discovered a problem. It seems that the checkbox on NavyMARS has something in it on the Look Up form. It appears to be hindering the action of that field. Either checked or unchecked it is updating nothing. The other two boxes work fine. To me it appears to be a small box in the checkbox...

Thanks to your suggestion I was able to get the MARS totals using the SUM in the total row of the query then multiply the answer by -1 in the Summary form. The thing I was missing was sum and I found it when I realized that I used Count to get the other values that were working. Daaaah! I...

I tried the checkboxes and got them working on the form but I could not get them to total for the summary. I realized that I need something like checkboxes or Y/N field for each one, not a drop down. This is because a person can be an operator for two or all three. I still can't remember how...

Apparently something happened. There should have been a whole lot more forms, Queries and reports in there than the video showed. I made a fresh copy of the file and a fresh zip file called New Club Roster 1, and have attached it. I would like to get the summary working before I start on...

Unless my mind has gone completely, that was before I added the reports for all the fields. What I am working on is the Summary that counts the various fields and will eventually have the financial info in it.

Here it is. The one that I am working on is the Summary. The Summary report hasn't had the labels fixed yet due to me being too tired to do it. We did CQ Santa today for one of the Children's Rehab locations so I had to get up early. We have to do it again tomorrow and Friday. I...

I left MARS where it was. Problem is on the summary report where the totals are shown, I can't get them in. My summary shows the total number of records for the member roster, ARRL, ARES, RACES, Skywarn, VE, EOC, and 92-2. I have these working perfectly. I need to add the number of records...

I have the queries and reports finished for the License Class and MARS headings. All that's left are the financial and to count the number of Y's for the yes/no list boxes.

There should be 3 different totals. One will be the total of everything, one will be the total paid by check, and the last will be the total paid in cash. Those totals should be by year. ex: Year Pd. Cash Pd. Check Total Audit The total should be a total of all...

They are each individual fields in the Roster table. Each record in that table has these fields. They represent membership in a branch of Ham Radio. ARRL = American Radio Relay League. ARES = Amateur Radio Emergency Services. RACES = Radio Amateur Communications Emergency Service. Skywarn =...

This collection is located in the Roster Table. Each is its own separate list box. The possible selections are: ARRL " ";Y;N ARES " ";Y;N RACES " ";Y;N Skywarn " ";Y;N MARS " ";Army;Navy;Air Force VE " ";Y;N EOC " ";Y;N 92-2 " ";Y;N I need to total the values for all...

Access 2007 windows 7 I have the attached database with sample data. I need to create some reports based on the number of times an item in the list box comes up. The idea is that the report field for Class will show the number of Novice, Tech, HF Tech, General, Advanced, and Extra...

How well I know that!

OK, Thanks a lot for the help. Now on to the final problem.:)