Search results
-
Z
Statement of account
Hi All, I would appreciate your help with this small issue: How can I create a report listing records from 2 tables: tblInvoices & tblReceipts I would like to show what is paid and what is due in the same report. I tried to create a single query including both tables but if I have 2 invoices... -
Z
updating stock when invoice cancelled
Hello, I've created an invoicing system for my bookstore where everything is working fine. If the invoice includes 3 books it'll update the stock for the book1, book2 and book3 but the problem is when someone cancel an invoice i have a problem fixing the stock back to normal. I've created a sql... -
Z
detect if a record is stored in a 2nd table
Hi again, as i already mentioned in my 1st post i'm creating a small software for my bookstore, i've created the search system 10x to the help of many posts here. I've been trying around all day long to create a system that detect if a given book is already taken, if so i should get the msg... -
Z
searching a table and creating an admin area
Hi, I was searching the web for some access help and I found this forum so I registered directly to post a couple of questions. Actually i'm new to microsoft access and i own a small bookstore and i'm creating a small software to manage the books. I've created the books table with the field...