in a report

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

I have a report, I have a footer that has =[WIMS_SUB_VEND], I want
this to count the number of wim_subs is it =count[WIMS_SUB_VEND]?

Ryan
 
Absolutely correct if that is the name of the field in your main report.
Type it into a text box which you have placed in your report footer.

However, if this field is a subreport then the syntax is slightly different.

Don't be afraid to experiment - if it all goes wrong, just close without
saving - or copy and paste your report and experiment on the copy.

Evi
 
Thanks, that did it, I have another question for you. I believe I need
to use Dlookup. in that same report, I have a vendor number that shows
on the report but I need to pull in the name. Usually I would just add
the vendname field in the query and bring it into the report, but in
this case I don't want to do it that way because I'm grouping
information and adding vendname complicates things since there are
multiple names for the same vendor. So to keep the records simple I
just have the items attached to the vendornumber. Anyways, in the
report I added a textbox where I'd like to pull in the vendor name to
match the vendor number on the report. I was thinking Dlookup. But I
do not know how to set up.

=DLookUp("[VENDORNAME]","SQLDAT3_APVMAS","[VEND_NUM] = " &
[SQLDAT3_APVMAS])

here are the fields.

VENDORNAME is the vendor name
SQLDAT3_APVMAS is the table inwhich it pulls from
VEND_NUM is the vendor number where it'll match to the name

Can you help?

Ryan

Absolutely correct if that is the name of the field in your main report.
Type it into a text box which you have placed in your report footer.

However, if this field is a subreport then the syntax is slightly different.

Don't be afraid to experiment - if it all goes wrong, just close without
saving - or copy and paste your report and experiment on the copy.

Evi


I have a report, I have a footer that has =[WIMS_SUB_VEND], I want
this to count the number of wim_subs is it =count[WIMS_SUB_VEND]?
Click to expand...
Ryan
Click to expand...
Click to expand...
 
So long as Vend_Num is a number field and not text, you were really close!

=DLookUp("[VENDORNAME]","SQLDAT3_APVMAS","[VEND_NUM] = " & [VEND_NUM])

If Vend_Num is a text field then the synatax is
=DLookUp("[VENDORNAME]","SQLDAT3_APVMAS","[VEND_NUM] = """ & [VEND_NUM] &
"""")

(that's 3 double quotes before and four double quotes after the &

What the DLookup means is

Look up what it says in VendorName in the table or query called
Sqldat3_apvmas. It's the record where its Vend_Num is the same as the
Vend_Num in this record.


Evi


Thanks, that did it, I have another question for you. I believe I need
to use Dlookup. in that same report, I have a vendor number that shows
on the report but I need to pull in the name. Usually I would just add
the vendname field in the query and bring it into the report, but in
this case I don't want to do it that way because I'm grouping
information and adding vendname complicates things since there are
multiple names for the same vendor. So to keep the records simple I
just have the items attached to the vendornumber. Anyways, in the
report I added a textbox where I'd like to pull in the vendor name to
match the vendor number on the report. I was thinking Dlookup. But I
do not know how to set up.

=DLookUp("[VENDORNAME]","SQLDAT3_APVMAS","[VEND_NUM] = " &
[SQLDAT3_APVMAS])

here are the fields.

VENDORNAME is the vendor name
SQLDAT3_APVMAS is the table inwhich it pulls from
VEND_NUM is the vendor number where it'll match to the name

Can you help?

Ryan

Absolutely correct if that is the name of the field in your main report.
Type it into a text box which you have placed in your report footer.

However, if this field is a subreport then the syntax is slightly different.

Don't be afraid to experiment - if it all goes wrong, just close without
saving - or copy and paste your report and experiment on the copy.

Evi


I have a report, I have a footer that has =[WIMS_SUB_VEND], I want
this to count the number of wim_subs is it =count[WIMS_SUB_VEND]?
Click to expand...
Ryan
Click to expand...
Click to expand...
Click to expand...
 
Back
Top