Dates and sub reports


M

Michael Gill

I have a tblEmployees(PayrollID,Name,etc) from which i run a query that i use
in a report to print rptTimeSheets each period which varies by employee
type(monthly, weekly) I hard edit the Header Label for month or week and then
hard edit the detail dates and then print all reports for all employees
Date From Time To Time Total Time
01/11/2008
02/11/2008
etc

I have tried various methods of creating a tblDates(DateID) and then a
parameter query(>=[Enter Date From] And <=[Enter Date To]) to fill a sub
report for use in the rptTimeSheet and placing it in the Header and Detail.
In the header it will only show the first employee. In the Detail it keeps
asking for parameters on each employee(page). I have also tried a query on
both tblEmployees and tblDates with no linking field(each employee has the
requird dates set by a parameter as above). The Header detail is ok showing
each employee on each new page but the detail DateId either under fills or
over spills (depending on height of DateID)into the next employee etc
Am i completely on the wrong track?
 
Ad

Advertisements

D

Duane Hookom

What is tblDates for? Does it contain a single record with two fields for
start and end dates?

It seems that you might be located in a geographic location that doesn't use
m/d/y formats. Are you aware of date criteria issues and how to handle them?
Read http://www.allenbrowne.com/ser-36.html.

Also, IMHO, parameter prompts in queries are never appropriate. Always use
controls on forms for data entry/editing and user interface.
 
M

Michael Gill

Hi Duane
tblDates has just 1 field DatesID(uk format dd/mm/yyyy) i have used this to
populate a sub report(rsubDates) with parameters that is then used in detail
of rptTimeSheet which can cover different date periods. What is IMHO? Do you
mean i should use a form with parameter inputs for Datefrom Dateto.

Duane Hookom said:
What is tblDates for? Does it contain a single record with two fields for
start and end dates?

It seems that you might be located in a geographic location that doesn't use
m/d/y formats. Are you aware of date criteria issues and how to handle them?
Read http://www.allenbrowne.com/ser-36.html.

Also, IMHO, parameter prompts in queries are never appropriate. Always use
controls on forms for data entry/editing and user interface.
--
Duane Hookom
Microsoft Access MVP


Michael Gill said:
I have a tblEmployees(PayrollID,Name,etc) from which i run a query that i use
in a report to print rptTimeSheets each period which varies by employee
type(monthly, weekly) I hard edit the Header Label for month or week and then
hard edit the detail dates and then print all reports for all employees
Date From Time To Time Total Time
01/11/2008
02/11/2008
etc

I have tried various methods of creating a tblDates(DateID) and then a
parameter query(>=[Enter Date From] And <=[Enter Date To]) to fill a sub
report for use in the rptTimeSheet and placing it in the Header and Detail.
In the header it will only show the first employee. In the Detail it keeps
asking for parameters on each employee(page). I have also tried a query on
both tblEmployees and tblDates with no linking field(each employee has the
requird dates set by a parameter as above). The Header detail is ok showing
each employee on each new page but the detail DateId either under fills or
over spills (depending on height of DateID)into the next employee etc
Am i completely on the wrong track?
 
D

Duane Hookom

IMHO http://en.wikipedia.org/wiki/IMHO#IM.
In My Humble Opinion, you should never use parameter prompts.

I think all of your date values for subreport, header labels, criteria, etc
can come directly from controls on forms.

--
Duane Hookom
Microsoft Access MVP


Michael Gill said:
Hi Duane
tblDates has just 1 field DatesID(uk format dd/mm/yyyy) i have used this to
populate a sub report(rsubDates) with parameters that is then used in detail
of rptTimeSheet which can cover different date periods. What is IMHO? Do you
mean i should use a form with parameter inputs for Datefrom Dateto.

Duane Hookom said:
What is tblDates for? Does it contain a single record with two fields for
start and end dates?

It seems that you might be located in a geographic location that doesn't use
m/d/y formats. Are you aware of date criteria issues and how to handle them?
Read http://www.allenbrowne.com/ser-36.html.

Also, IMHO, parameter prompts in queries are never appropriate. Always use
controls on forms for data entry/editing and user interface.
--
Duane Hookom
Microsoft Access MVP


Michael Gill said:
I have a tblEmployees(PayrollID,Name,etc) from which i run a query that i use
in a report to print rptTimeSheets each period which varies by employee
type(monthly, weekly) I hard edit the Header Label for month or week and then
hard edit the detail dates and then print all reports for all employees
Date From Time To Time Total Time
01/11/2008
02/11/2008
etc

I have tried various methods of creating a tblDates(DateID) and then a
parameter query(>=[Enter Date From] And <=[Enter Date To]) to fill a sub
report for use in the rptTimeSheet and placing it in the Header and Detail.
In the header it will only show the first employee. In the Detail it keeps
asking for parameters on each employee(page). I have also tried a query on
both tblEmployees and tblDates with no linking field(each employee has the
requird dates set by a parameter as above). The Header detail is ok showing
each employee on each new page but the detail DateId either under fills or
over spills (depending on height of DateID)into the next employee etc
Am i completely on the wrong track?
 
M

Michael Gill

So at the moment i am creating TimeSheets like a Mail Merge. How would i do
it through a form?

Duane Hookom said:
IMHO http://en.wikipedia.org/wiki/IMHO#IM.
In My Humble Opinion, you should never use parameter prompts.

I think all of your date values for subreport, header labels, criteria, etc
can come directly from controls on forms.

--
Duane Hookom
Microsoft Access MVP


Michael Gill said:
Hi Duane
tblDates has just 1 field DatesID(uk format dd/mm/yyyy) i have used this to
populate a sub report(rsubDates) with parameters that is then used in detail
of rptTimeSheet which can cover different date periods. What is IMHO? Do you
mean i should use a form with parameter inputs for Datefrom Dateto.

Duane Hookom said:
What is tblDates for? Does it contain a single record with two fields for
start and end dates?

It seems that you might be located in a geographic location that doesn't use
m/d/y formats. Are you aware of date criteria issues and how to handle them?
Read http://www.allenbrowne.com/ser-36.html.

Also, IMHO, parameter prompts in queries are never appropriate. Always use
controls on forms for data entry/editing and user interface.
--
Duane Hookom
Microsoft Access MVP


:

I have a tblEmployees(PayrollID,Name,etc) from which i run a query that i use
in a report to print rptTimeSheets each period which varies by employee
type(monthly, weekly) I hard edit the Header Label for month or week and then
hard edit the detail dates and then print all reports for all employees
Date From Time To Time Total Time
01/11/2008
02/11/2008
etc

I have tried various methods of creating a tblDates(DateID) and then a
parameter query(>=[Enter Date From] And <=[Enter Date To]) to fill a sub
report for use in the rptTimeSheet and placing it in the Header and Detail.
In the header it will only show the first employee. In the Detail it keeps
asking for parameters on each employee(page). I have also tried a query on
both tblEmployees and tblDates with no linking field(each employee has the
requird dates set by a parameter as above). The Header detail is ok showing
each employee on each new page but the detail DateId either under fills or
over spills (depending on height of DateID)into the next employee etc
Am i completely on the wrong track?
 
Ad

Advertisements

D

Duane Hookom

I'm not sure we have much of a clue as to what you are attempting to
accomplish. You have provided bits and pieces but nothing that gives us
enough info to do much more than guess.

--
Duane Hookom
Microsoft Access MVP


Michael Gill said:
So at the moment i am creating TimeSheets like a Mail Merge. How would i do
it through a form?

Duane Hookom said:
IMHO http://en.wikipedia.org/wiki/IMHO#IM.
In My Humble Opinion, you should never use parameter prompts.

I think all of your date values for subreport, header labels, criteria, etc
can come directly from controls on forms.

--
Duane Hookom
Microsoft Access MVP


Michael Gill said:
Hi Duane
tblDates has just 1 field DatesID(uk format dd/mm/yyyy) i have used this to
populate a sub report(rsubDates) with parameters that is then used in detail
of rptTimeSheet which can cover different date periods. What is IMHO? Do you
mean i should use a form with parameter inputs for Datefrom Dateto.

:

What is tblDates for? Does it contain a single record with two fields for
start and end dates?

It seems that you might be located in a geographic location that doesn't use
m/d/y formats. Are you aware of date criteria issues and how to handle them?
Read http://www.allenbrowne.com/ser-36.html.

Also, IMHO, parameter prompts in queries are never appropriate. Always use
controls on forms for data entry/editing and user interface.
--
Duane Hookom
Microsoft Access MVP


:

I have a tblEmployees(PayrollID,Name,etc) from which i run a query that i use
in a report to print rptTimeSheets each period which varies by employee
type(monthly, weekly) I hard edit the Header Label for month or week and then
hard edit the detail dates and then print all reports for all employees
Date From Time To Time Total Time
01/11/2008
02/11/2008
etc

I have tried various methods of creating a tblDates(DateID) and then a
parameter query(>=[Enter Date From] And <=[Enter Date To]) to fill a sub
report for use in the rptTimeSheet and placing it in the Header and Detail.
In the header it will only show the first employee. In the Detail it keeps
asking for parameters on each employee(page). I have also tried a query on
both tblEmployees and tblDates with no linking field(each employee has the
requird dates set by a parameter as above). The Header detail is ok showing
each employee on each new page but the detail DateId either under fills or
over spills (depending on height of DateID)into the next employee etc
Am i completely on the wrong track?
 
Ad

Advertisements


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

Similar Threads

Employee Schedule 6
Holiday Dates 1
CrossTab Query Access Report - 1
Rerun query 2
An Opposite Report 2
Return Desired Value in a Text Box 4
Count or DCount used in a report 1
Major Problem with Report 3

Top