Recent content by trying

I can't paste it but under "Row/Source Type" it's set to "table/query". This has to be much easier than I realize - if I did this in excel it would just be the filter option.

found it thank you.

Sorry, I'm new to this and didn't realize how to post in the reports section - but will figure that out... I have a table with 1000 records, 2 fields - the unique ID and type. I want a count of each different type. So in the end I will get a summary report that would look like this: Total...

Hi, I'm just trying to do a simple report. I am taking 1 field from my table, and I just want to do subtotals. When I try to do it I get each record listed with a count next to it - I can't just have subtotals show up.:(

I forgot to mention I just want it to populate the form - then update the table. I'm essentially "entering new records" within the table by using the form.

I'm a beginner so keep that in mind....I have 1 table with 7 fields. I'm trying to do a form with the exact same 7 fields. I want each one of the fields to have a drop down option on the form. There are 1000 records, but within each field there are only about 8 different options. So in the...

I'm building a combo box - when I use the drop down every value in my entire field show up for every record - I only want the distinct values to appear as choices to populate the field.