annakalli
Last Activity: Jul 28 '13, 08:29 AM
Joined: May 26 '10
Location: Larnaca Cyprus
-
I used the function as follow in my query Round(([total]-[discount]),2) but it always give me a wrong message about the number 2 i try as well to put the number in brackets -
avoiding decimals in a calculation
I create a calculated field called [total] with properties currency and 2 decimal places, which is the result of a formula who multiplies the fields [cost] and [vat],this field afterwards is used in a report in a new formula where it is subtracted.
The problem is that is using 4 decimals in the subtraction for example in my table the calculated field [total] shows as value the amount 1303.00 but when i used in the report deletes the amount... -
Thank u very much, is working just fine nowLeave a comment:
-
where i m going to write this code in my form?Leave a comment:
-
How do I Move to the New Record in Code
I already include in my form the command button NEW RECORD and i want to be able to add a new record only when i press this button and not through my mouse -
Multiple if statement
Hi, I have the 4 following fields, salestype,amoun t for vat,date and vat. The answers for theit can be either 1(with vat) or 2 (without vat), for the fieldCode:salestype
i use the formula =iffCode:vat
<1/3/2012;Code:date
*0.15;Code:amount for vat
*0.17). The problem is that when i calculate the fieldCode:amount for vat
i want to check theCode:vat
and if that has the value 2 i want the value for the fieldCode:salestype
to be zero otherwise to check the date. How can i add that...Code:vat
-
How to i use an if statement in a calculated field?
Hi, I have a calculated field in my query named VAT:, this field was the multiplication of the field, but now the vat percentage is changed from the first of march to 0.17 instead of 0.15 so i want to use an if statement to check my transaction date in my query, if the date is before the 1/3/2012 the calculation to use the 0.15 otherwise to use the 0.17 .Code:AMOUNT*0.15
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessThank u so much, it works perfectly now. All my regards from the sunshine Cyprus :-)Leave a comment:
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessYou was right my code was a bit confusing in those lines so i follow your advice and i changed is as you can see below
...Code:SELECT TBLBANKSTRANSACTIONS.ID, TBLBANKSTRANSACTIONS.[TRANSACTION NUMBER], TBLBANKSTRANSACTIONS.[TRANSACTION DATE], TBLBANKSTRANSACTIONS.[AR EGGRAFOU], TBLBANKSTRANSACTIONS.DESCRIPTION, TBLBANKSTRANSACTIONS.DRAMOUNT, TBLBANKSTRANSACTIONS.CRAMOUNT, TBLBANKSTRANSACTIONS.[TYPE OF TRANSACTION], TBLBANKSTRANSACTIONS.[BANK CODE],
Leave a comment:
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessThe SQL for the query [BALANCES ACCORDING TO SELECTED DATES]is
The RecordSource of my report is called TBLBANKS_TRANSA CTIONS...Code:SELECT TBLBANKSTRANSACTIONS.[BANK CODE], Sum(Nz([DRAMOUNT],0)) AS BALANCEDR, Sum(Nz([CRAMOUNT],0)) AS BALANCECR FROM TBLBANKSTRANSACTIONS WHERE (((TBLBANKSTRANSACTIONS.[TRANSACTION DATE])<[forms]![Report Date Range]![Beginning Trans Date])) GROUP BY TBLBANKSTRANSACTIONS.[BANK CODE];
Leave a comment:
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessIn my report i add the query BALANCES ACCORDING TO SELECTED DATES that contains the 3 fields,[BALANCEDR], [BALANCECR], [bank code]. I join this query with my table TBLBANKSTRANSAC TIONS through the field [bank code]. I then create a calculated field which is called [balance]. I define the field as :
Yes, i want the [BALANCE] value to display zero,...Code:balance: Nz([TOTAL-BALANCES ACCORDING TO SELECTED DATES].[BALANCEDR]-[BALANCECR],0)
Leave a comment:
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessThis query is used in a report. When i have transactions, my report works OK. For example if i asked to display all the transactions according to a starting date - ending date the report displays firstly a field called BALANCE which is the subtraction of the field BALANCEDR -BALANCECR, this figure is for the days before my starting date and it comes from that query and then rest of the figures for the given days which are from the table TBLBANKSTRANSAC TIONS....Leave a comment:
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessI try your suggestion as u can see below but still i have the same problem
Code:SELECT TBLBANKSTRANSACTIONS.[BANK CODE], Nz(Sum([DRAMOUNT]),0) AS BALANCEDR, Nz(Sum([crAMOUNT]),0) AS BALANCECR FROM TBLBANKSTRANSACTIONS WHERE (((TBLBANKSTRANSACTIONS.[TRANSACTION DATE])<[forms]![Report Date Range]![Beginning Trans Date])) GROUP BY TBLBANKSTRANSACTIONS.[BANK CODE];
Leave a comment:
-
i have the same problem, did u find the answerLeave a comment:
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessThe problem is that when i run the query and i don't have any transactions for the days before the transaction date that i enter i get as an answer just the titles of the field names, which is correct but can i get the values zero insteadLeave a comment:
-
annakalli replied to How can i have zero values in 2 fields when the criteria in a third field is falsein AccessI am already use the similar Nz function as you can see below
I try your advise but i...Code:SELECT TBLBANKSTRANSACTIONS.[BANK CODE] , Sum(Nz([DRAMOUNT],0)) AS BALANCEDR , Sum(Nz([CRAMOUNT],0)) AS BALANCECR FROM TBLBANKSTRANSACTIONS WHERE (((TBLBANKSTRANSACTIONS.[TRANSACTION DATE])<[forms]![Report Date Range]![Beginning Trans Date])) GROUP BY TBLBANKSTRANSACTIONS.[BANK CODE];Leave a comment:
-
annakalli started a topic How can i have zero values in 2 fields when the criteria in a third field is falsein AccessHow can i have zero values in 2 fields when the criteria in a third field is false
Hello, am having a table called TRANSACTIONS, this table contains 3 fields : TRANSACTION DATE, DRAMOUNT and CRAMOUNT.
I create a Query that ask for a starting transaction date and then shows the totals for the DRAMOUNT and CRAMOUNT for the previous transactions dates.
If i have transactions before the starting date everything is ok but if i don't, i get no results in my query while i want to get zero values.
... -
Is working fine now, thank u. The only thing that i can not manage is the field balance brought forwardwhat command shall i use in order to have automativally there the result of the calculation [dramount]-[cramount] for the dates before my starting dateLeave a comment:
-
I am using the running sum for the totals of the dramount and cramount fields, i can figure out how i am going to have the total for the previous month as i explain aboveLeave a comment:
-
how can i update a calculated field in a report
I have a table called banktransaction s in this table i have the following fields
date
details
dramount
cramount
i am using this table to create a report showing the transactions for a given period. the report asks for the starting date and then for the ending date and automatically displays the fields details - dramount and cramount field for that period. i want to include in my report a new field which...
No activity results to display
Leave a comment: