Hi again. I just tried doing something on my own and have absolutely no idea what it is I am doing. I am having problems setting up how I want the query to do the calculations.
Just a little more background on the table that might allow for you to help me further. The quarters are also sorted by year so they are in "FY06 Q1", "FY06 Q2" etc. format.
Now say when I run the query the parameter boxes...
hibbii
Last Activity: Dec 28 '06, 08:15 PM
Joined: Oct 12 '06
Location:
-
Thanks, let me give it a try. I really never use SQL too often to build my queries just do it off the query design.Leave a comment:
-
Thanks for that, however, I still dont get what that will do.
How would I add it so that it will show me the adjustments that are made between the 2 DCN's from different quarters? The changes could be made in the costbase, startdate, and/or uselife fields....Leave a comment:
-
DCN and Quarter are both Text fields. The DCN remains constant with the record for all of time. There are fields in the record that can change but the DCN wont. There is 1 instance of each DCN every quarter this is what makes it unique.
By the way there are about 980 different DCN's in quarter 1. That number could go up or down depending on if we delete a certain DCN or add one. I am only concerned with the ones that are still...Leave a comment:
-
Any suggestions on this. Thanks.Leave a comment:
-
Comparing records in one table
Could someone help me write a query or code that allows me to compare records based on the quarter?
For example, in my table all the records have the PK set as (DCN & Quarter). The DCN is usually the same from one quarter to another. However, 3 fields could change (cost basis, useful life, and start date).
I want to be able to allow a user to enter the 2 quarters they want to compare and then there will be a report... -
Choose locations of exported spreadsheets
How do you choose what folder you want a transferspreads heet command to extract into? Can I specifiy a different places for each, right now everything is going into My Documents. -
I am definately working on increasing my knowledge of VBA so I appreciate your encouragement.
I will give you the answers to your questions about my db.
I am have a table named "calculated_amo rt_schedules" which is sort of a temporary table depending on what quarters data I am looking for. This is created based off a combo box off my quarters table.
What I am looking for is create workbooks...Leave a comment:
-
Thanks Neo, I am horrible with VBA could you help me adapt this into my database?
The problem I am trying to resolve is that how will I specify what workbook I can transfer my combo box results? If i create the table for Q1 how can I tell it to transfer to a workbook called "Final Q1" and if I make a table for Q3 how can I transfer to a different workbook called "Final Q3", etc. etc.
Wouldn't...Leave a comment:
-
Thank you all. I will try some of these suggestions and let you all know how it goes.Leave a comment:
-
As another add-on question, can I transfer a table to a sreadsheet that is not yet created based on the quarter.
For instance, I want a spreadsheet for Q1 can I transfer the table to a spreadsheet and create the name at the same time.Leave a comment:
-
Best way to track changes in a table
Hi all,
I am currently working with a database that has one main table. In this table (from period to period) there may be certain changes in the accounting data.
What would be the best way to incorporate the changes but at the same time keep the historical data to be able to go back on and compare periods?
And what would be the best way to find these changes from any given period to another?
... -
I am sorry about the PM, and yes if you could give me the code that would be great. Thanks for all your help....Leave a comment:
-
That is probably true but for the time being I want to give it a shot. Do you mind going over how it can be done?Leave a comment:
-
Save a created table
I have a form that creates a table from various append queries. This table changes based on the quarter i choose from the combo box. Now what I am trying to do is find a way to automate the saving process so that for each quarter that is created I can save the table in a different name. Right now for whatever quarter I select the table is saved in "Calculated Schedule".
Is there a way to put a code in VB to do it or... -
Need help Importing data from excel
I am trying to import data from a spreadsheet into a pre-created table. The table however has columns that the spreasheet does not such as an autonumber PK and an ID as the FK.
What is the best way to get start importing into column 3 of the table from the spreadsheet and keep the first 2 columns intact.
The other problem I have is when I try to import some calculated fields from excel I get #NUM! in the table.... -
Guys I am an idiot, I figured it out. My report was linked to the combo box for view and by changing to link to the create combo box it worked out.
Thanks for your help.Leave a comment:
-
I tried doing the single step mode but am still getting a blank report. Maybe the prblem is not with the timing?...Leave a comment:
-
I am not really familiar with the DO events command, should I just put it in the code as mentioned above? It is giving me a compile error when I do that.Leave a comment:
-
Button that combines the creation and view of a report.
Hi all,
I currently have a command button that performs the following series of queries:
These queries each are append queries and create a table named "ADT Calculated Amort Schedule". There is also a report that I have based on this table but I have to use a separate command button to open it.
When I try to add this code in VB in my first button the report report shows...
No activity results to display
Leave a comment: