Search results

I guess I'm not sure what you are saying. They are 3 separate fields. I use member ID in other tables and link it via relationship with the MembersList table. I guess the MemberID is not really needed as I COULD key on the CenterID,FirstName,LastName, but--I only very loosely understand...

In the CenterName combo box, they enter the center name, and it stores the center id. The table is: CenterID, MemberID, FirstName, LastName, Notes, Active

It is ok to have a duplicate first name, OR last name, OR CenterID, but not all 3 in one record.

Correct

It is a data entry form. The user enters the CenterName, which is a combo box and saves the CenterID. Then just the First name combo box and last name combo box, and a notes field. Hidden is the MemberID which is an automatic number.

I already have a primary key (member id) on table MembersList, but want to test for duplicates on a form where both first and last names are combo boxes before creating the record. so far I have the following as an Event procedure on the Before Update of the second combo box names Last Combo...

I think I got it now. thanks!

nope still doesn't automatically choose the first in the list

But now it will not choose the first loan when there are loan records. Is there a way to add that back?

But now, it is not automatically choosing the first in list when the center does have loans.

Thank you-it worked!

Woohoo!!! Thank you-It worked!!!

I have a list box on a form which pulls loans based on the center chosen in the first field on the form. It automatically chooses the first loan to prevent a non-record chosen. I am getting an error when I have a center with no loans. This is the code (Event Procedure) to choose the first-when...

Pat-I will try that-good info! I didn't know about the order and dummy accounts. I have both of those queries set up already. I've never done a union query so I'll look at that. Not sure where the thank you button is but Thanks!

Other note is I have centers. Each center has vendors. Each vendor has units and contributions. Each entry of units and/or contributions has a date. Tables are: Centers, Vendors, Activity Centers have a unique ID Vendors have a unique ID dates, units, and contributions are not unique...

I can do that, and the % is just a calculated cell as well as the total current. It can be vertical or horizontal as long as it has all the info. Prior year (actually all prior activity is added together), then current by date, then a grand total of each vendor and over-all.

See if this works

I've never used the union query. I'll give it a try! Thanks!

I just uploaded an Excel of the information I need. Prior year as 1 total by vendor. Current year detailed by exact date, then a grand total (which will be easy once I have the other 2). It doesn't have to be this format, just have the same info.

I'm fairly new to Access in the fact it's completely self-taught, and I'm not familiar with coding it. I'm needing a report to show the total of prior year transactions, then list individually current year transactions. I created a query to sum prior year, but then how do I add current year...