Auto number in reports

  • Thread starter Thread starter Beeyen
  • Start date Start date
B

Beeyen

Good Day,

I am trying to create a report from a query. The query has names that are
listed in alphabetical and next to the name the auto numbered ID field
appears with the query. When I run a report I seem only to receive bits and
pieces of information and I am trying to eliminate reasons why. Could it be
the auto numbered not being in alphabetical order as well with the data? My
understanding of the auto numbers are unique row identifiers but could it be
preventing report information from appearing?

Thanks
 
Beeyen said:
I am trying to create a report from a query. The query has names that are
listed in alphabetical and next to the name the auto numbered ID field
appears with the query. When I run a report I seem only to receive bits and
pieces of information and I am trying to eliminate reasons why. Could it be
the auto numbered not being in alphabetical order as well with the data? My
understanding of the auto numbers are unique row identifiers but could it be
preventing report information from appearing?
Click to expand...


You are barking up the wrong tree. There isn't much to go
on here, but maybe you are using the dreaded Lookup Field
somewhere in the table and the query is not in sync with it.
Take a look at
http://www.mvps.org/access/tencommandments.htm
especially the second commandment.

If that doesn't help you make some progress, we will need a
more detailed explanation of "receive bits and pieces of
information". We also need an explanation of the fields and
table(s?) involved and a Copy of the query's SQL view.
 
Beeyen said:
I am trying to create a report from a query. The query has names that are
listed in alphabetical and next to the name the auto numbered ID field
appears with the query. When I run a report I seem only to receive bits and
pieces of information and I am trying to eliminate reasons why. Could it be
the auto numbered not being in alphabetical order as well with the data? My
understanding of the auto numbers are unique row identifiers but could it be
preventing report information from appearing?
Click to expand...


You are barking up the wrong tree. There isn't much to go
on here, but maybe you are using the dreaded Lookup Field
somewhere in the table and the query is not in sync with it.
Take a look at
http://www.mvps.org/access/tencommandments.htm
especially the second commandment.

If that doesn't help you make some progress, we will need a
more detailed explanation of "receive bits and pieces of
information". We also need an explanation of the fields and
table(s?) involved and a Copy of the query's SQL view.
 
Thanks for the response. Through additional research and the access
commandments, I may have discovered the problem. I do have a number of Combo
Boxes in my form and used the lookup field in the table. I have since
deleted the relationships for those fields, changed the datatype to text. I
will know if this is the answer when returning to the office Monday. If the
results are good, and that was the issue, great. If the results are not as
expected, I will response back with the information you requested to assist.

Thanks and have a good weekend.
 
Thanks for the response. Through additional research and the access
commandments, I may have discovered the problem. I do have a number of Combo
Boxes in my form and used the lookup field in the table. I have since
deleted the relationships for those fields, changed the datatype to text. I
will know if this is the answer when returning to the office Monday. If the
results are good, and that was the issue, great. If the results are not as
expected, I will response back with the information you requested to assist.

Thanks and have a good weekend.
 
Back
Top