vegak18
Last Activity: Sep 20 '07, 06:52 PM
Joined: Aug 17 '07
Location:
-
and yeah... all the tables it works off of are all correct and represent the numbrs as numbers..... but for some reason when it translates into this query it turns the numbers into text fields... -
It is happening to the appropriations field, reappropriaions field, budget after encumbrances, and APPaid...Leave a comment:
-
make table query specifics
Dear Experts,
I was was wondering if there was some way to specify output properties of a make table query. Specifically, I am haivng a problem with numbers being specified as text. while I realize I can go in and change the table properties after the table has been created, I create and replace this table quite often so that would become a laborious prcess. Is there some way I can make the query specify that for me. I am using... -
yeah I have no cluee iter. I went ahead an copied one that was already working just changing the numbers and it works..... now i have to see if its atually calculating te numbers correctly... thanks for all your help!...Leave a comment:
-
I made the querries by simply copying and changing the refrence numbers. The parameters in qustionare all references to ther ouput fields within the query so that is why they dont refrence any table.
I shall try rebuidng the queries off one of the ones that work I suppose. Does that sound like a fessible plan?...Leave a comment:
-
it is asking me to define Encumbrances, curent appropriations, and APPaid....Leave a comment:
-
here is an example SQL of one ofthe tables that is not functioning:
[code=sql]
SELECT Accounts.Accoun tNumber, Accounts.Accoun tName, Section1001Budg et.budgetedAmou nt, NZ([Section 1001 Reappropriation s]![budgetedAmount],0) AS Reappropriation s, NZ(NZ([Section1001Budg et]![budgetedAmount])-NZ([Section 1001 Reappropriation s]![budgetedAmount]),0) AS [current appropriations], NZ([section1001dire ctPayVouchers]![SumOfAmount])+NZ([Section1001SPO]![SumOfAmount])+NZ([Section1001Requ sitions]![SumOfAmount])...Leave a comment:
-
p.s. I am working wt access 2000...Leave a comment:
-
query parameter request - all refrences are spelled correctly
Dear Experts,
I have several make table queries tha all essentially do the same thing, they just refrence diffrent tables of segregated accountng data. My problem is that they are inconsistent. some allow me to make the table with no trouble. some ask for paramaters on things that I know are spelled correctly and correctly refrenced. Why am I getting these parameter requests? any and all help would be appreciated. if you need...
No activity results to display
Leave a comment: