Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

"Can't bind name error on Access reports"

I have a number of "product"-based reports that are reliant on crosstab queries creating columns that have data in them for a month end report.  Some "products" have no data on certain months.  The report falls over with error "can't bind name" when the cross tab query generates no data for the product in question(other products do contain data and should be printed).  How I make the report generic so that when a product has no data the report will still work?
0
rafx
Asked:
rafx
1 Solution
 
MikeRenzCommented:
in your query check your joins.  Make sure the fields you have joined between the 'product' are inner joins, and not left or right joins.
0
 
GOLLEMCommented:
rafx->

I think the problem is in the null-values. Acces can't make heads or tails of them of course.

you could simply use dummy values. Make an update-query that replaces the nulls with zeros, this way your numeric values can be added up.
for sting values this is a bit harder, but I'm sure you can make a work-around for that too.

Idea: if you use a fixed value that indicates "no value' than you can do a SELECT.... WHERE  field = NOT "No Value" in your report

You can automate the update query by calling it in the OnTimer event of your main form using an if-routine bound to when the date is for example the first of the month.

Hope this fixes your problem,

                                        Michiel
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now