Can't figure out how to create this report (repost - clarification)???

[_Bigred]

I have a table "UnitJobs"

it contains the following fields:

WorkerName
HireDate
WorkerNumber
CellNum
SortNum


WorkerName is a [LastName]&[FirstName]
HireDate is a field containing the date they were hired to that unit job
Worker Number is their 6 digit DOC Number
CellNum is the room number they live in
SortNum is a number used to keep the jobs sorted in a certain order in
another form

How can I create a report that would take a record and place it in a
SPECIFIC place on a report

e.g. I want SortNum 1 (and it's other fields data) and place it in a
specific spot on a report, so that I can used lines, labels etc.. to create
a make-shift report and then place the desired data where it needs to be on
the report relative to the labels?

I will apologize for reposting this problem, I didnt' get any response to my
original post so I figured I would repost and explain it differently.

I have a picture of the hardcopy form that I'm trying/hoping to create as a
access report at
http://home.new.rr.com/gfiddle/ACCESSprob.htm

TIA,
_Bigred

 

[Guest]

You might want to look at the calendar reports at
http://www.access.hookom.net/Samples.htm. The position of controls is set
dynamically based on values in the fields.

 

[_Bigred]

thakns Duane, I'll check that link out and see what I come up with.

thanks for your time,
_Bigred

You might want to look at the calendar reports at
http://www.access.hookom.net/Samples.htm. The position of controls is set
dynamically based on values in the fields.
--
Duane Hookom
Microsoft Access MVP

I have a table "UnitJobs"

it contains the following fields:

WorkerName
HireDate
WorkerNumber
CellNum
SortNum


WorkerName is a [LastName]&[FirstName]
HireDate is a field containing the date they were hired to that unit job
Worker Number is their 6 digit DOC Number
CellNum is the room number they live in
SortNum is a number used to keep the jobs sorted in a certain order in
another form

How can I create a report that would take a record and place it in a
SPECIFIC place on a report

e.g. I want SortNum 1 (and it's other fields data) and place it in a
specific spot on a report, so that I can used lines, labels etc.. to
create
a make-shift report and then place the desired data where it needs to be
on
the report relative to the labels?

I will apologize for reposting this problem, I didnt' get any response to
my
original post so I figured I would repost and explain it differently.

I have a picture of the hardcopy form that I'm trying/hoping to create as
a
access report at
http://home.new.rr.com/gfiddle/ACCESSprob.htm

TIA,
_Bigred