Search results

whole record

I have a fairly major problem: I am trying to create a report that does some fairly complex calculations on a large quantity of records. The calculations must be done in VB due to their complexity. At the end of the calculations, I would like the report to supress the ones that come up at...

I am building a combination of a search that outputs a chart, based on criteria selected. i have the form built properly, it returns a fully functional SQL statement into a textbox on the form (was going to set it invisible). I can put this SQL statement into the row source of the chart and it...

Allow me to clarify how i got it and what its supposed to do-- This query: SELECT Format([due date],"yyyymm") AS ReturnYYYYMM, [monthly returns].[Client Number] FROM [monthly returns]; returns all the "yearmonths" where a return was filed. This query: SELECT tblYearMonths.YearMonth, [Client...

help! troubleshoot this SQL statement SELECT tblYearMonths.YearMonth, [Client Data].[Client Number] FROM [Client Data], tblYearMonths WHERE ((([Client Data].[Beginning Date])<[dateapplicable]) AND ((tblYearMonths.DateApplicable)<Date()) AND Not In (SELECT Format([due date],"yyyymm") AS...

I have a table full of monthly returns for a variety of clients. Each return is due on the 20th of every month. How can i construct a query that will return every month in the last 2 years where there is NOT a return listed in the table?

I think thats the main problem....that the code is trying to calculate stuff based on data that hasn't loaded yet. How can I make it happen after data is loaded?

I have a rather complicated database that processes incoming tax bills. All the data submitted is entered into a form, and I used some complex calculations to tell if there is a difference between what they entered and what it should be. Now I'm trying to generate a report based on some of...

Allow me to be a little more clear.... -Customer owes x amount of money, which is due at a certain time -for the amount of time past that day, customer is charged interest -need to calculate interest due Its easy but, problem is the interest rate we use changes frequently. And if they are say...

I am trying to make a form that will take a number typed into a text box, and calculate the applicable taxes. The rate changes every year, and the information is stored in a table (beginning date, end date, int rate for that year). It would involve for say 3/21/02, calculating 365 - that date...