Search results

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...

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 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...

Since I don't know about writing codes I am using NorthWest Database for this part of the project. I saw a previous post and have been able to fix some. I still have problems. I have this part of the code Sub PrintReports(ReportView As AcView) ' This procedure used in Preview_Click and...

I have this code and it is giving this error Compile Error sub or function not defined this is the code Select Case Me.lstSalesPeriod Case ByYear strReportName = "Customer Reports" lOrderCount = DCountWrapper("*", "Order Analysis", "[Year]=" & Me.cbYear) Case ByMonth strReportName = "Customer...

How Do I link my freight cost to the order date ? thanks

I need to add the freight and Tax per order for my customers. Can any one help Thanks

I have 20 clients. I need to run reports for each client can anyone help

I have this code but it does not duplicate the record, how do i get it to duplicate a record? Set rs = db.OpenRecordset("SELECT * FROM CustomerOrder WHERE(Product = """ & Me.Product & """)") If rs.EOF Then With rs .AddNew .Fields("Product") = Me.Product.Value .Fields("Guilders") =...

I am creatng a consumer database. I have a list of my inventory. I can search and find my items . How do I after i have found the item click on the item so that it can go into a table or form?

hi all I am kim new to everything