Spletno preverjanje združljivosti: podprti izrazi

Z izrazom povezane napake preverjevalnika združljivosti lahko odpravite tako, da zamenjate izraze, ki jih je preverjevalnik združljivosti prepoznal kot težave v tabeli »Težave z združljivostjo v spletu«.

V spletni zbirki podatkov je deset različnih kontekstov, v katerih se izraz lahko uporablja. Vsi izrazi pa ne delujejo v vseh kontekstih.

V tem članku so našteti izrazi, ki so podprti v različnih kontekstih spletne zbirke podatkov. Izrazi so združeni po kontekstu in po vrsti funkcije v okviru posameznega konteksta. Z izrazi zamenjajte izraze, ki jih je prepoznal preverjevalnik združljivosti.

Konteksti izraza

Osnovni dostop

Izračunani stolpci

Omejitve

Stolpci poizvedbe

Makri uporabniškega vmesnika

Podatkovni makri

Privzeto

Preverjanje veljavnosti

Obrazci

Poročila

Osnovni dostop

V kontekstu osnovnega dostopa spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Izračunani stolpci

V kontekstu izračunanih stolpcev spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Omejitve

V kontekstu omejitev spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Stolpci poizvedbe

V kontekstu stolpcev poizvedbe spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Makri uporabniškega vmesnika

V kontekstu makrov uporabniškega vmesnika spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Podatkovni makri

V kontekstu podatkovnih makrov spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Privzeto

V privzetem kontekstu spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Preverjanje veljavnosti

V kontekstu preverjanja veljavnosti spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Obrazci

V kontekstu obrazcev spletne zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • Datevalue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Ugnezdene funkcije

  • Log(Cos(1)+Exp(1))

  • Log(Sqr(Fix(1)))

  • Log(Sqr(Fix(Sgn(1))))

  • Log(Sqr(Fix(Sgn(Sqr(1)))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(1,2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(1),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(1)),2))))))

  • Log(Sqr(Fix(Sgn(Sqr(Round(Abs(Exp(Log(1))),2))))))

  • Round(Exp(1),Exp(2))

  • Round(Exp(Abs(1)),Exp(Abs(2)))

  • Round(Exp(Abs(Fix(1))),Exp(Abs(Fix(2))))

  • Round(Exp(Abs(Fix(Sqr(1)))),Exp(Abs(Fix(Sqr(2)))))

  • Round(Exp(Abs(Fix(Sqr(Log(1))))),Exp(Abs(Fix(Sqr(Log(2))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(1)))))),Exp(Abs(Fix(Sqr(Log(Sgn(2)))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(1))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(2))))))))

  • Round(Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(1)))))))),Exp(Abs(Fix(Sqr(Log(Sgn(Sqr(Exp(2)))))))))

Na vrh strani

Poročila

V kontekstu poročil zbirke podatkov so dovoljeni ti izrazi.

Datum/Čas

  • Date

  • Date$

  • Dateserial

  • DateValue

  • Day

  • Minute

  • Hour

  • Month

  • MonthName

  • Now

  • Second

  • Time

  • Time$

  • Timeserial

  • WeekdayName

  • Weekday

  • Year

  • Timevalue

Finance

  • Ddb

  • Fv

  • Ipmt

  • Nper

  • Pmt

  • Ppmt

  • Pv

  • Rate

  • Sin

  • Syd

  • NPV

Pregled

  • Isnull

  • Isempty

  • Isnumeric

  • Null

  • Nz

  • Updated

Matematika

  • Abs

  • Atn

  • Cos

  • Exp

  • Fix

  • Int

  • Log

  • Round

  • Sgn

  • Sin

  • Sqr

  • Tan

Operator

  • -

  • *

  • /

  • ^

  • +

  • <

  • <=

  • <>

  • =

  • >=

  • And

  • Or

  • Mod

  • Not

  • &

Potek programa

  • Choose

  • Iif

Besedilo

  • Asc

  • Lcase

  • Lcase$

  • Left

  • Left$

  • Len

  • Mid

  • Mid$

  • Right

  • Right$

  • Space

  • Space$

  • Ucase

  • Ucase$

  • Trim

  • Trim$

  • String

  • String$

  • Replace

  • PlainText

  • Instr

Pretvorba

  • Str

  • Str$

  • Hex

  • Hex$

  • Oct

  • Oct$

Agregati

  • Avg

  • Count

  • Max

  • Min

  • StDev

  • StDevP

  • Sum

  • Var

  • VarP

Agregati domene

  • DAvg

  • DCount

  • DFirst

  • DLast

  • DLookup

  • DMax

  • DMin

  • DStDev

  • DStDevP

  • DSum

  • DVar

  • DVarP

Dobesedno

  • System.Title

  • System.Size

  • System.IsFlagged

Po meri

  • CurrentWebUser

  • CurrentWebUserGroups

  • IsCurrentWebUserInGroup

  • Like

  • In

Na vrh strani

Razširite svoja znanja
Oglejte si izobraževanje
Prvi dobite nove funkcije
Pridružite se programu Office Insider

Vam je bila informacija v pomoč?

Zahvaljujemo se vam za povratne informacije.

Zahvaljujemo se vam za povratne informacije. Videti je, da bi vam prišla prav pomoč enega od naših Officeovih agentov za podporo.

×