looking for samples on how functions are used

  • Thread starter Thread starter panicked
  • Start date Start date
P

panicked

Can someone please help me? Using ACCESS2000, I'm writing
a 'simple' update query and I haven't done this for a few
years. I need examples of how to actually write the
exprssion. For example, to get the returned
expression "98052" from the field "98052-6399", I would
write Left([zipcode]),5). I'm looking for a source where
I can get a list a many different expressions. My book is
confusing as heck, I've been on the internet all night
searching (using dial-up no less). This shouldn't be so
hard to find. Anyone? Please, my job depends on it. N.
 
Did you try the Expression Builder? It's the button with the wand over the
.... Once you start this, the functions are all there with a quick path to
Help.
 
If you use Access 2000, then the file "JETSQL40.CHM" should be somewhere
on the hard drive Access is installed on. ALL Jet SQL functions are found
here (COUNT, SUM, etc.).


Start MS Access 2000.
Hit cntl-G.
Menu Help>Microsoft Visual Basic Help

Under the Contents Tab, the fourth book down is the Visual Basic Language
Reference (which can also be found in file VBLR.CHM). All Visual Basic
functions are found here (Iif, Switch, InStr, CInt, etc.). The Index tab
can be used to find the entry "function", which will produce a long list of
varying functions.
 
Back
Top