Search results

Here's a .jpg to help explain my problem better the Report is supposed to show the Total Income for the period entered. My problem is with the Addendum (Act aditional in the report), since it's linked to the Contract and i need to show the contract info for that addendum, but i also have to...

Hi to all, what is the code equivalent for if ([FieldA] < [StartDate]) then [FieldB].value=0 end if [StarDate] is a Date parameter which i entered when the report is created [FieldA] is a Date field [FieldB] is a Number field i want to insert this in the code builder to run before the...

managed to do it thanks GalaxiomAtHome for the NULL idea

the dates are stored as Date type, i used the like operator since for this query i want all the records for a certain year if i use AND in the where clause, i lose the contracts that don't have addendum from the results

Hi, this select query only works half right. SELECT Table1.ContractID, Table1.ContractFinishDate, Table2.AddendumID, Table2.AddendumFinishDate FROM Table1 LEFT JOIN Table2 ON Table1.ContractID = Table2.ContractID WHERE (((Table1.ContractFinishDate) Like "*" & [Year] & "*")); it selects the...

1. Value = Cost, how much the client pays for the services provided by the contract or addendum 2. I was planning to write an update query which will always update the value of the balance 3. Yes Invoices have more details: InvoiceValue, InvoiceDate, iPaymentDate 4. I need this to keep track of...

the client field is there only to give a name to the contract, since some ppl know the contract by the ContractID and others by the client name. About the invoices i think you're right, that's why i was looking for any tips on how to modify the 2 tables. the thing is that although the invoice...

Hi guys, i needed to create a bd to keep track of contracts. So i have For Contracts : ContractID, ResponsableP, Client For Addendums to the Contreacts : AddendumID, Faze_Number Fields that both Contracts and Addendums have in common : Value, Star_Date, End_Date, Invode_Number...

I'm trying to update column 2 based on column 1, by subtracting 1 month. exaple: Column1 -----> Column2 01-09-2011 01-08-2011 02-09-2011 02-08-2011 01-10-2011 01-09-2011 So any idea how to write the Update Query ?

Morning to all! So I have these 2 tables: Table1 ID ContractID (Primary) Value FinishDate Table2 ID(Primary) ContractID (allow duplicate) AditionalID Value FinishDate The Query should only show the data form the 2 tables if it's in the date range searched. In the attachment i have a test...