Jet Basic - filtering for a specific value in a linked table

(0) Share

Report

Posted on by themanjosh

Hello,

I had a question - I am trying to build a report where I can get my sales numbers in the sales unit of measure, which is different from the base unit of measure. I am using the Jet sales basic report Item sales and Profit as a starting point

The table function is as follows

=@NL("Table","27 Item",$E$11:$AA$11,"Headers=",$E$10:$AA$10,"TableName=","Item","Filters=",$C$5:$D$7,"InclusiveLink=27 Item",$F$9,"IncludeDuplicates=","True")

The link is here

=@NL("Link","5404 Item Unit of Measure",,"1 Item No.","=1 No.")

and the field I am displaying is

=@NL("LinkField","5404 Item Unit of Measure","3 Qty. per Unit of Measure.")

What my goal is is to ensure that the linkfield is pulling the number from CODE = CASE from the item unit of measure field. I have tried putting a filter in a bunch of places, but admittedly am a bit of a beginner at this and might just be getting a syntax error or am missing something else.

If someone could assist me I would really appreciate it.

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Jet Basic - filtering for a specific value in a linked table

Hello,

Try this link to the Jet Report website Community assistance: help.insightsoftware.com/.../jet

Hope this helps.

Thanks,

Steve