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

B

_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
 
B

_Bigred

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

thanks for your time,
_Bigred


Duane Hookom said:
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


_Bigred said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top