Hi Katerina,
Hmmm.....I just opened Access 2000 (normally, I use Access 2002), went into
query design, and then opened the Help menu and searched for truncate. I do
find the same TRUNC function listed. However, when I click on the Contents
tab, I see that the heading titled "Spreadsheet Functions" is expanded.
I then repeated the same search in Access 2002, and I do not find the TRUNC
function listed. So, I suspect that this is an error in the Access 2000 Help
files. To see the functions available to Access in the 2000 version, start on
the Contents tab with all categories collapsed. The 5th category from the
bottom reads "Visual Basic Language Reference". Click on the + sign to expand
this category. Then click on the + sign next to Functions to expand that
list. When you click on the + sign next to the Q-Z category, you do not see
the TRUNC function in the list. Likewise, when you click on the + sign next
to the M-P category, you do not see MRound listed (also an Excel function).
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
Hi Tom-
No - I'm talking about Microsoft Access (!), looking up truncate in
the Help menu in design view of a query. Microsoft Access refers to a group
of functions that it gives instructions for as worksheet functions. Are you
saying that these items in the Help menu (such as mround, mod, etc. - again,
found in Access) were placed in Access erroneously? When you look this up in
Access do you get the same result? Thanks.
__________________________________________
:
Hi Katerina,
Your use of the term "worksheet functions" indicates Excel, and Trunc is an
Excel function. However, this newsgroup is dedicated to questions and answers
related to the database software named Microsoft Access.
Suggest you post to an Excel newsgroup, such as this one
http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I have attempted to use different functions, such as trunc and mod. I get an
error message 'undefined funtion trunc in expression.' However, I found
this function by searching for truncate in the Help menu, so it appears that
this function is supposed to work. The Help menu indicated that the
msowcf.dll is needed for worksheet functions - I checked my computer and I
have that. Is there a service pack or tool kit that I need for these to work?