field data does not change

[DeweyDiva]

I use the SQL to create a query for the first time. The query reflects all
the the correct data, but when I went to make labels from the query the page
numbers all say 3pp. instead of changing to reflect how many pages are in
each book. The rest of the label data fields change correctly. I have
double checked and the page field is not different from the other field.
Please help.

 

[John W. Vinson]

I use the SQL to create a query for the first time. The query reflects all
the the correct data, but when I went to make labels from the query the page
numbers all say 3pp. instead of changing to reflect how many pages are in
each book. The rest of the label data fields change correctly. I have
double checked and the page field is not different from the other field.
Please help.

Please post the SQL of the query and indicate where in your table the "pages"
field is stored. We can't see it from here.