Recent content by jc_

Oh, okay! But he primary key has the key picture next to it; is the foreign key identified in any way?

This is a pretty basic questions, but if I am given many tables and am told to create the relationships, I know how to do that on access, but how do I know which tables to connect?

what does it mean when you get an error saying "the database engine could not lock table "sales_cashreceipts" bc it is already in use by another person or procesS?

i want to be able add up the numbers by customer. I understand the total query from the sigma button. I did that for 'invoice', but it isnt working. for every invoice it duplicates cash receipts. it still shows the customer listed 3 times and in design view it says total: sum..???

Is there a formula or another way to total same customer information. Ex: Customer1 has 3 different payments: 10$, 20$, 30$... how do i sum these up? In my qry it just has Customer1 listed 3 different times with each payment individually and I only want each customer listed once with all...

what does the error "the SQL statment couldnt be executed bc it contains ambiguous outer joins" mean? i can give more info if needed...

If I have a null value, but I want to put a $0.00 in the cell, what formula should I use? Ive been trying to use the nz and iff functions but i havent been able to get it right.. im using a query to list total cash receipts by account. i have the cashacctnum the accttype and the receiptamount...

Thanks so much!!! I got it now :) so simple, yet so much trouble for me!

I am doing a project and Im supposed to display all the customers who havent bought anything from our company yet. I am using the customerID, customerFirtstname, and CustomerLastname. i am then using InvoiceAmount and in criteria putting "Is Null" yet when i run the query nothing comes up..? i...

Im doing a school project and I have to total the number of each item an employee has sold. I watched tutorials online and found I should use "total" instead of "group by". I did this, but I still have the same item more than once. I am not sure why the totals function isn't working and I was...

I am trying to complete an assignment for a class.. i have to set up all the relationships between different tables. im trying to connect 'sale_cashreceipt' and 'salesorder' tables by their invoice number. this relationship should be a one to many, but access is saying it is a indeterminate...

hi, im a new member trying to learn more about access and its benefits to accounting... im new to this program and need help!