show parital data from a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that has two pieces of data separated by a front-slash. In
Access 2000 the following used in a query presented back all data to the left
of the /. Since upgrading to Access 2003, this now gives me an error message
"Invalid Procedure Call".

Can anybody tell me how to modify this to work in the newer version of
Access??

Qty: IIf([JanQty] Is Not
Null,Left$([JanQty],InStr([JanQty],"/")-1),[JanQtySent])

Thanks for any help!
Susan
 
One more thing...This works UNTIL I add criteria to only show answers >0.
I've tried "Is Not Null", ">"0"" and ">0" and when I add this criteria, I get
the "Invalid Procedure Call" error. Thanks again!
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

That set up violates the 1st Normal Form - a cell has to be atomic.
This means there can be only 1 data item in a cell (row/column
intersection - AKA Field).

Check your VBA References: In a VBA module, on the main menu select
Tools > References. See if any items at the top of the list are marked
Missing - reconnect them. Make sure the Visual Basic for Applications
is checked and the Microsoft Access X Object library (where X is a
number) is checked.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlHE9YechKqOuFEgEQI2XQCguyGk2pORVlJDMUFKU5/foj4IDGEAmgKv
XPeKutVWx2EvQ1UjFagsTUEr
=Egrm
-----END PGP SIGNATURE-----
 
Back
Top