Search results

  1. C

    Jump to record from textbox

    Hi, I'm trying to jump to a record from a textbox. So i have a form [Inserare Contracte] which has the record source the table [tblContracte]. In that form I have 2 textboxes. In the first one [FactNr] i enter the invoice number, then in the second one [ContractNr] i get the Contract...
  2. C

    Calculated field

    Hi, i have a report that shows the status of queried contracts. One of the field shows the amount the client still has to pay, which it does by calculating the difference between the invoice amount and the amount payed. The problem i'm having is that the calculated field does not know how to...
  3. C

    line shading

    Hi, how do i modify the line shading so that it takes into account the whole info linked to a contract. In the example u can see that that contracts 11I005 and 11I006 have 2 payments for the same invoice, but the line shading is all wrong. thanks for the help
  4. C

    Report - code builder

    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...
  5. C

    subquery select

    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...
  6. C

    create relational database

    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...
  7. C

    Update Query Date Subtract

    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 ?
  8. C

    Query Union tables

    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...
Back
Top Bottom