Recent content by kim40

thanks it works

I would like returned quarter and financial year (e.g june 2012 would be 4th quarter 2011).

sorry meant july to june. I agree June should be in the 4th quater but not in the current financial period. the financial period is july 2012 to june 2013. but june 2012 is in the 4th quarter of the 2012-2013 year hope this is clearer thanks

Quarter: DatePart("q",DateAdd("m",6,[Date Paid])) I have this code that calculates the date in quarters. My financial year is july to Dec. It works fine except that it sees june 2012 in the fouth quarter. How do I modify this?

I am created a form I need my users to enter amounts and date paid. I need the form to show only the companies that are in arrears. I have this code but my form comes up empty. Can any one help Private Sub CboFilter_Change() 'If the combo box is cleared, clear the form filter. If...

Super moderator I have created the 2 reports how do I put both into a blank report. I also read the link that you sent thanks

Arrival Date Fuel Type quantity Year Month Quarter 07-Sep-12 Gas Oil 500 2012 9 3 02-Sep-12 Mogas 300 2012 9 3 06-Sep-12 Jet A.1 200 2012 9 3 08-Sep-12 Other 50 2012 9 3 03-Sep-12 Jet A.1 500 2012 9 3 04-Sep-12 Jet A.1 20 2012 9 3 02-Sep-12...

how do I send the files and can I send the spread sheet with the original data?

I need to create monthly quarterly and yearly reports. I have 2 queries one with the quantity of goods imported and the other the amount of revenue collected. the quantity report runs on the day it arrives into the country, while the revenue query runs on the day the goods were paid. My boss...

I have three 3 tables company, payment and import table. The import table consist of the following fields ImporterID, Vessel, Date(vessel arrival date),Item(there ore only 4 items) and the Amount owed for each item. I have the payment table which have the following fields PaymentID.ImporterID...

thank you this really helps

You talk about properly structured tables. How do I know when my tables are properly structured. Honestly I know nothing about databases and I am teaching myself as it forms part of the job. Thanks

I have two tables a purchasing table and a payment table for clients. I have a revenue field in both tables. How do I get my Revenue from my purchasing table to display in my Payment table?

I am creating a new database. I am incharge of monitoring the importation of an concrete slabs since it is only one product I dont really know how to go about it In addition there is a special tax and my company is responsible for collecting it This is the information importer concrete boat...

I have tried the code but I need a liitle more help. I am not getting any error messages but my report does not open thanks