I got help earlier and have been pointed in the direction of a Crosstab, but have been unsuccesful in getting the information to convert in the Crosstab query. I created a table that reproduces the old table's column headings into row headings, but the row headings have no referential integrity...
I have a table that houses financial statements for a given company by year and I need to display the information and add analysis information in a report format comparing year to year to year. For example:
1998 1999 2000
Income $10 $15 $22
Exspenses $8 $9...
I have a table that houses financial statements for a given company by year and I need to display the information and add analysis information in a report format comparing year to year to year. For example:
1998 1999 2000
Income $10 $15 $22
Exspenses $8 $9...
I have a subform that posts infor to the one of the same tables that my main form does. I'm hoping to yield the sub forms posting routine to the main forms routine. What is the best course of action.
I have created a table called tblUniqueIDs, which contains all the primary keys for my tables.
ClientID ClientDetailID FinancialsID
1 1 1
I cannot figure out how to pull the current ID and increment it by 1 for the next entry.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.