Search results

Hi I create a stock Management database. Table name is StockManagement. Form name is Stock Managment. In the form, I'm trying to create a search button for searching any words in Descriptions field. Code is as follows, Private Sub cmSearch_Click() Dim LSQL As String Dim...

I haven't created Outstanding table yet. It's just a idea since I often receive payment which over or underpaid. It's impossible to allocate those underpaid as fully paid. I have tblTransaction which includes invoices and payments, I also have qryAged Debtor, but I have no idea how to creat...

I have problem with my Outstanding Invoice Statement. Some Invoices are partly paid, some are still not paid. How to create a query for these outstanding invoices? Can someone help. Thanks:)

Chris It's still referred to qryAgedDebtor. Is it possible to add in Balance in tblAgedDebtorPeriod for sum of period. If it's possible, how to define it? Thanks:)

Sorry, it should have been 'Crosstab':o

Thanks for it. I have used crosstable in query stage. However, I'm not too sure if I also can creat crosstable for outstanding by joining the relevant table. Can you have a look my database. Thanks:)

Chris, Sorry. I had looked at AgedDebtor and paly"ed it. It really works. Now I understand your idea. Once payment received. It allocated to relevant invoice as "1". In qryAgedDebtor, it appears payment as '-', and outstanding as '+'. So aged debtor will only show outstanding. It's very very...

Chris If a Query cannot add new data, then what is going to happen in the Form Stage? Please have a look I updated database. Thanks:)

Chris My problem is I cannot enter a data into the queries.

Chris I notes that your query has a problem. Can you have a look the last row. Thanks:)

Sorry Chris, there is no relationship in your database.:confused:

Hi Chris I'm trying use your way to solve my problem. However, in query stage, it's not working. I'm using Access 2007. Can you have a look what went wrong. Thanks:)

Hi Chris thanks. I understand it now. However, I still have a question. If my client paid me within 30 days, I need to add in a tblpayment, in which the fields are as follows, tblPayment - number (Primary Key) tblInvoiceID - number Amount - Currency PaymentDate - Currency It's just like...

Hi Chris I can understand tblInvoice, however I have questions for tblContractor and tblAgeDebtorPeriod. 1)Why you didn't give a primary key to lContractor? 2)You did set a primary key for tblAgedDebtorPeriod as text, however, how can I let the system work out the period fo me ie from invoice...

I got a work from other company, and I should get paid when I finished each work. So I need to make claim from the company by issuing self-billing invoice. They should make payment within 30 days. However, they didn't pay me on time. Sometimes they pay me after 90 days. From accounting point...

Hi Thanks it works. But I still have question, In table Aged Debtor, the Balance equals sum of 30 days, 60 days 90 days and older. how to set up relationship between Aged Debtors and Claims? Thanks:)

I created 3 tables below for Accounts receivable: Main Contractor Fields: ID - Primary Key A/C No- Text Name - Text Address - Text Claims Fields: ID - Primary Key A/C No - Number Date - Date/Time Nominal Code - Number Net Amount - Currency VAT - Currency Gross - Currency Payment Received -...

Hi I have problem with creating outstanding report and aged debtors report. I have created four tables ie Main Contractors, Calims, Payments and Aged Debtors. I also created a Query for Claims. However, I don't know how to creat a report for each subcontract, and aged debtors report. Can anyone...

Thanks for your help! I made it!

Thanks!!! I will let you know it.