I cannot get the following formula to work but I cannot figure out why.
=NL("sum","Items","Quantity","DataSource=","SpeedLinkDB","StoreID",$B$2,"EODID",$B9,"PLU",D$3,"SizeName",D$4,"Link=","Modifiers","ticketseq","=ticketseq","itemindex","=itemindex","ModifierPLU",D$5)
I get an error saying the "ModifierPLU" is not a valid field. I know it is spelled correctly because this formula works just fine
=NL(1,"Modifiers","ModifierPLU","DataSource=","SpeedLinkDB")
That being said, I probably have the link= formula laid out incorrectly but I'm not seeing the problem. As a side question, is the link= formula my only option when I have to link more than 1 field? Thanks!
Date
Votes
2 comments
-
Jet Reports Historic Posts No it is not my default database but I didn't think I needed to specify it again. Wouldn't my error message be the table not the field? Regardless, I added it but I get the same error message as before.
-
Jet Reports Historic Posts Hi,
You should not need to specify DataSource= again in the link. DataSource= and Company= always apply to the entire function, no matter where you put them in the link chain. Yes Link= is the only way to link to tables when you need to link by more than 1 field.
As far as the invalid field, that is weird. What version of Jet are you using and what type of database are you connecting to? Can you attach an example workbook?
Regards,
Hughes
Please sign in to leave a comment.