field only on first page..

[stephendeloach via AccessMonster.com]

I have created a report from a query, in this report i have the field name
"Truck Type" in the page header because I was it to be shown only one time on
each page. Right now it is only showing one time (like i want it), but its
only on the first page?? Can someone explain what I need to do? Thanks

 

[Marshall Barton]

I have created a report from a query, in this report i have the field name
"Truck Type" in the page header because I was it to be shown only one time on
each page. Right now it is only showing one time (like i want it), but its
only on the first page??

It sounds like you put it in the report header instead of
the page header.

 

[stephendeloach via AccessMonster.com]

Nope. Page Header. Its weird.. When I drag it into the Page header and leave
the Label (Text68, the Label shows on the next page but no Truck Type???

 

[Marshall Barton]

How does the text box get its value? If it's bound to field
in the record source, does the field have the same value for
every record?

 

[stephendeloach via AccessMonster.com]

I drag-droped it from my fields list into the Page Header. Deleted the Label
(Text68). Control source is "Truck Type" from Daily Log Query. No the field
has different values for each record, but im querying by "Truck #" which the
truck # i query has the same "Truck Type".... Whick makes me think it
shouldnt be a problem?? Thanks for the help...

How does the text box get its value? If it's bound to field
in the record source, does the field have the same value for
every record?

Nope. Page Header. Its weird.. When I drag it into the Page header and leave
the Label (Text68, the Label shows on the next page but no Truck Type???

[quoted text clipped - 3 lines]

 

[Marshall Barton]

I drag-droped it from my fields list into the Page Header. Deleted the Label
(Text68). Control source is "Truck Type" from Daily Log Query. No the field
has different values for each record, but im querying by "Truck #" which the
truck # i query has the same "Truck Type".... Whick makes me think it
shouldnt be a problem?? Thanks for the help...

How does the text box get its value? If it's bound to field
in the record source, does the field have the same value for
every record?

Nope. Page Header. Its weird.. When I drag it into the Page header and leave
the Label (Text68, the Label shows on the next page but no Truck Type???

[quoted text clipped - 3 lines]
each page. Right now it is only showing one time (like i want it), but its
only on the first page??

As long as all the records in the report have the same value
in that field, each page should display the same value.
(The Page header/footer bound text boxes will get the value
from the first/last record on the page.)

Given the way Access works with these things, there is
something definitely wrong here. Either you are doing
something to obliterate the value (hide the text box behind
another control, setting the font color to white, ? ? ?) or
the report has become corrupted.

 

[stephendeloach via AccessMonster.com]

Could it be that there is say 200 records for truck 202 but the value for
Truck Type only has 3 values in the Truck Type field? (We didnt want to have
to type 2000 Chevrolet 200 times)....

I drag-droped it from my fields list into the Page Header. Deleted the Label
(Text68). Control source is "Truck Type" from Daily Log Query. No the field

[quoted text clipped - 5 lines]

in the record source, does the field have the same value for
every record?
Nope. Page Header. Its weird.. When I drag it into the Page header and leave
the Label (Text68, the Label shows on the next page but no Truck Type???
[quoted text clipped - 3 lines]
each page. Right now it is only showing one time (like i want it), but its
only on the first page??

As long as all the records in the report have the same value
in that field, each page should display the same value.
(The Page header/footer bound text boxes will get the value
from the first/last record on the page.)

Given the way Access works with these things, there is
something definitely wrong here. Either you are doing
something to obliterate the value (hide the text box behind
another control, setting the font color to white, ? ? ?) or
the report has become corrupted.

 

[Marshall Barton]

Could it be that there is say 200 records for truck 202 but the value for
Truck Type only has 3 values in the Truck Type field? (We didnt want to have
to type 2000 Chevrolet 200 times)....

If 197 out of 200 records do not have a value in the truck
type field, the odds are very high that any page will
display a null values.

This changes the problem completely.

It seems like you were very lucky to get the Truck Type to
display on the first page. Can you guarantee that the first
record in the report's data set has a value in the Truck
Type field? If so how?

Is it always true that a truck # will only have one Truck
Type value? If so, why isn't the Truck Type field in the
Trucks table instead?

 

[stephendeloach via AccessMonster.com]

Yes, They are sorted by Date. The first record has the Truck Type.
We have two tables... Truck Number and Daily Log. Truck Number only has the
numbers of the truck. Daily Log has all the other info. Truck Type, Date, Vin
#, etc...

 

[stephendeloach via AccessMonster.com]

OK after talking with my co-worker, is there a way that i can link the "Truck
#", "Vin #" and "Truck Type" fields?? Say Im in the form where all this is
entered, I type in "Truck #" - 202, automatically it knows to fill the "Vin
#" and "Truck Type" fields? For example.. link "Truck #" - 117 to "Vin #" -
D311520483 to "Truck Type" - 2000 Chevrolet... ??

Yes, They are sorted by Date. The first record has the Truck Type.
We have two tables... Truck Number and Daily Log. Truck Number only has the
numbers of the truck. Daily Log has all the other info. Truck Type, Date, Vin
#, etc...
[quoted text clipped - 14 lines]

Type value? If so, why isn't the Truck Type field in the
Trucks table instead?

 

[Marshall Barton]

OK after talking with my co-worker, is there a way that i can link the "Truck
#", "Vin #" and "Truck Type" fields?? Say Im in the form where all this is
entered, I type in "Truck #" - 202, automatically it knows to fill the "Vin
#" and "Truck Type" fields? For example.. link "Truck #" - 117 to "Vin #" -
D311520483 to "Truck Type" - 2000 Chevrolet... ??

Yes, They are sorted by Date. The first record has the Truck Type.
We have two tables... Truck Number and Daily Log. Truck Number only has the
numbers of the truck. Daily Log has all the other info. Truck Type, Date, Vin
#, etc...

Could it be that there is say 200 records for truck 202 but the value for
Truck Type only has 3 values in the Truck Type field? (We didnt want to have

[quoted text clipped - 14 lines]

Type value? If so, why isn't the Truck Type field in the
Trucks table instead?

If the "Truck#", "Vin #" and "Truck Type" fields are in the
Truck Number table (where the rules of Normalization
indicates they should be), then you can Join the two tables
in the report's RecordSource query and everything should
fall into place. Just add both tables to the query and make
sure the connecting line is between the truck number fields.

I strongly recommend that your data entry form consist of a
main form bound to the Truck Number table and have fields
for the "Truck#", "Vin #" and "Truck Type" values. Then
use a subform bound to the Daily Log table. Just remember
to set the Link Master/Child Fields properties to the truck
number fields.

 

[stephendeloach via AccessMonster.com]

Wonderful.. I went ahead and made everything like you said... MUCH easier and
better setup. Thanks for your help!

OK after talking with my co-worker, is there a way that i can link the "Truck
#", "Vin #" and "Truck Type" fields?? Say Im in the form where all this is

[quoted text clipped - 12 lines]
If the "Truck#", "Vin #" and "Truck Type" fields are in the
Truck Number table (where the rules of Normalization
indicates they should be), then you can Join the two tables
in the report's RecordSource query and everything should
fall into place. Just add both tables to the query and make
sure the connecting line is between the truck number fields.

I strongly recommend that your data entry form consist of a
main form bound to the Truck Number table and have fields
for the "Truck#", "Vin #" and "Truck Type" values. Then
use a subform bound to the Daily Log table. Just remember
to set the Link Master/Child Fields properties to the truck
number fields.