Recent content by kfschaefer1

I have a complex IF Statement within VBA when I step thru the code the if statement variables should return true but instead treats it as False. See '>>>> this happens on the 2nd Pass of a Do Loop Statement, the First Loop the if Statement Returns True Variable Values: Record 1 contractNo...

Also I am unable to retrieve the next value for the Previous Year for the next quarter. Once Qtr1 has finished I need to be able to go to Qtr2 and retrieve the PvYr value for Qtr2. ContractNumber Quarter PctYrlyIncrease 00003977 1 0.00% 00003977 2...

this is the data I get from the data warehouse, and I need to compare values within an access query, hence the need to loop thru the various fields to determine the value I am looking for. It comes accross in a huge text file - and since it is a datawarehouse normalization does not exists. I...

I have to loop thru 2 recordsets. I need to first determine the quarter , then retrieve a value from each of the 6 fields for that quarter and compare that value against a previous years value that is also stored in the table for each quarter. the following is the field names not the field...

I have a mainform/subform. Combo for Vendor Name is on subform. If the user needs to add a new Vendor name, I use the Liimit List Edit form - allow the user to add a new vendor. however, when the user returns to the Mainform/Subform to continue to enter the invoices, it does not set the...

I have code that will update SQL tables and uses a Stored Procedures to gather the information. The following code works successfully and updates the SQL table. I am looking for assistance in now using these functions to capture information regarding the processeing of the databases. I need to...