Recent content by emma313823

All, I'm trying to understand why the report I created sums the data the way it does. I've tried to create a (what I think is a simple) report and I've tried creating it from a table and a query with the same results. I added a total to the report to sum my check value field, however...

Thank you both for this valuable info. I appreciate the clarity as well. Emma

All I'm experiencing an issue when trying to creat a lookup in a table. I have one unique table called tblPrincipal - just a list of name. I want to have a lookup or a dropdown in another table to allow me to more quickly grab the correct name to reduce inaccurate entry by manually typeing. When...

I'm not sure how to close this thread as completed, so if anyone can help tell me how to do so, I'd appreciate it.

Well newbie means everything takes longer to find and discover. I took all night and part of this morning and figured out what I was doing wrong. I had to figure out through trial and error how to do a mismatch query and then was able to make relationships and establish ref integ etc.

Hi, I created a report from a table, so I could just get a quick snapshot of current month work. I was able to filter the month I want and included a total summing off of a check value column. The problem I have is the value showing for the month is not grabbing all the data actually showing in...

We are a sales/commissions-based company. We represent companies called 'principals' and sell their product. Each month they pay us a commisison payment by live check or ach transfer/direct deposit. I track all incoming payments - those fields are included in the tblIncomingCommissions table. I...

Sorry I thought I attached the access file. This may make it easier to understand.

Hi, I all of a sudden seem to be having some issue with a simple sort on a table. The table has the following columns: When I try to sort on pay_date, I'm getting this message: I do have a principal table and the only odd thing I see is plus symbols next to ever row. When I try to expand...