#Name? prints on a report when date shows up on preview

Access 2003 SP 2
Windows XP SP 2

I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman). I have created a form to select (or enter) a
date range that then filters the report based on that date range and
populates transactions between those dates. I have created two text
boxes on the report that display the start date (txtStartDT) and end
date (txtEndDT) entered in the date select form. The control source
on the date boxes on the report is
"=Forms.frmFuelmanByForeman.txtEndDate" & "...txtStartDate". In
Preview mode, the dates display fine; however, when I print the report
the date fields show #Name?

In the query I have the TRANSDATE set with a criteria of "Between
[Forms].[frmFuelmanByForeman].[txtStartDate] And [Forms].
[frmFuelmanByForeman].[txtEndDate]" and I have a non-visible text box
on the form for TRANSDATE, but I don't really believe either of these
have anything to do with the dates not showing up when the report is
printed.

Any assistance is greatly appreciated.

Thanks,
Eric

Try changing the WHERE clause's criterion to this (use ! instead of .):

Between [Forms]![frmFuelmanByForeman]![txtStartDate] And
[Forms]![frmFuelmanByForeman]![txtEndDate]

--

Ken Snell
MS ACCESS MVP



wrote in message
oups.com...
Access 2003 SP 2
Windows XP SP 2

I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman). I have created a form to select (or enter) a
date range that then filters the report based on that date range and
populates transactions between those dates. I have created two text
boxes on the report that display the start date (txtStartDT) and end
date (txtEndDT) entered in the date select form. The control source
on the date boxes on the report is
"=Forms.frmFuelmanByForeman.txtEndDate" & "...txtStartDate". In
Preview mode, the dates display fine; however, when I print the report
the date fields show #Name?

In the query I have the TRANSDATE set with a criteria of "Between
[Forms].[frmFuelmanByForeman].[txtStartDate] And [Forms].
[frmFuelmanByForeman].[txtEndDate]" and I have a non-visible text box
on the form for TRANSDATE, but I don't really believe either of these
have anything to do with the dates not showing up when the report is
printed.

Any assistance is greatly appreciated.

Thanks,
Eric

Also, make the same change (replace . with !) in the textboxes'
ControlSource expressions.

--

Ken Snell
MS ACCESS MVP


"Ken Snell (MVP)" wrote in message
...
Try changing the WHERE clause's criterion to this (use ! instead of .):

Between [Forms]![frmFuelmanByForeman]![txtStartDate] And
[Forms]![frmFuelmanByForeman]![txtEndDate]

--

Ken Snell
MS ACCESS MVP



wrote in message
oups.com...
Access 2003 SP 2
Windows XP SP 2

I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman). I have created a form to select (or enter) a
date range that then filters the report based on that date range and
populates transactions between those dates. I have created two text
boxes on the report that display the start date (txtStartDT) and end
date (txtEndDT) entered in the date select form. The control source
on the date boxes on the report is
"=Forms.frmFuelmanByForeman.txtEndDate" & "...txtStartDate". In
Preview mode, the dates display fine; however, when I print the report
the date fields show #Name?

In the query I have the TRANSDATE set with a criteria of "Between
[Forms].[frmFuelmanByForeman].[txtStartDate] And [Forms].
[frmFuelmanByForeman].[txtEndDate]" and I have a non-visible text box
on the form for TRANSDATE, but I don't really believe either of these
have anything to do with the dates not showing up when the report is
printed.

Any assistance is greatly appreciated.

Thanks,
Eric

Ok I did that, still not working. I did notice that I don't have a
WHERE clause in my query. It is a HAVING statement.

SELECT domEmployee.FirstName & " " & [LastName] AS CardholderName,
Sum(tblFuelman.AMOUNT) AS SumOfAMOUNT, domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
FROM domMCCDesc INNER JOIN (domEmployee INNER JOIN tblFuelman ON
domEmployee.EmployeeID=tblFuelman.CARDHOLDER) ON
domMCCDesc.ID=tblFuelman.MCC_DESC
GROUP BY domEmployee.FirstName & " " & [LastName], domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
HAVING (((tblFuelman.TRANSDATE) Between Forms!frmFuelmanByForeman!
txtStartDate And Forms!frmFuelmanByForeman!txtEndDate) And
((domEmployee.FirstName & " " & [LastName]) Not Like "keri*"));


Anything else I can try?




On Sep 11, 2:41 pm, "Ken Snell \(MVP\)"
wrote:
Also, make the same change (replace . with !) in the textboxes'
ControlSource expressions.

--

Ken Snell
MS ACCESS MVP

"Ken Snell (MVP)" wrote in .. .

Try changing the WHERE clause's criterion to this (use ! instead of .):

Between [Forms]![frmFuelmanByForeman]![txtStartDate] And
[Forms]![frmFuelmanByForeman]![txtEndDate]

--

Ken Snell
MS ACCESS MVP

wrote in message
roups.com...
Access 2003 SP 2
Windows XP SP 2

I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman). I have created a form to select (or enter) a
date range that then filters the report based on that date range and
populates transactions between those dates. I have created two text
boxes on the report that display the start date (txtStartDT) and end
date (txtEndDT) entered in the date select form. The control source
on the date boxes on the report is
"=Forms.frmFuelmanByForeman.txtEndDate" & "...txtStartDate". In
Preview mode, the dates display fine; however, when I print the report
the date fields show #Name?

In the query I have the TRANSDATE set with a criteria of "Between
[Forms].[frmFuelmanByForeman].[txtStartDate] And [Forms].
[frmFuelmanByForeman].[txtEndDate]" and I have a non-visible text box
on the form for TRANSDATE, but I don't really believe either of these
have anything to do with the dates not showing up when the report is
printed.

Any assistance is greatly appreciated.

Thanks,
Eric

What I do for reports in these circumstances is to add calculated fields to
the query for the parameter values, and bind textboxes on the report to
those calculated fields so that the values are more easily displayed on the
report -- too many problems, I've found, with having a report read from a
form that may not be open any mo

SELECT domEmployee.FirstName & " " & [LastName] AS CardholderName,
Sum(tblFuelman.AMOUNT) AS SumOfAMOUNT, domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE, Forms!frmFuelmanByForeman!txtStartDate
AS TheStartDate, Forms!frmFuelmanByForeman!txtEndDate
AS TheEndDate
FROM domMCCDesc INNER JOIN (domEmployee INNER JOIN tblFuelman ON
domEmployee.EmployeeID=tblFuelman.CARDHOLDER) ON
domMCCDesc.ID=tblFuelman.MCC_DESC
GROUP BY domEmployee.FirstName & " " & [LastName], domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
HAVING (((tblFuelman.TRANSDATE) Between Forms!frmFuelmanByForeman!
txtStartDate And Forms!frmFuelmanByForeman!txtEndDate) And
((domEmployee.FirstName & " " & [LastName]) Not Like "keri*"));


--

Ken Snell
MS ACCESS MVP



wrote in message
ups.com...
Ok I did that, still not working. I did notice that I don't have a
WHERE clause in my query. It is a HAVING statement.

SELECT domEmployee.FirstName & " " & [LastName] AS CardholderName,
Sum(tblFuelman.AMOUNT) AS SumOfAMOUNT, domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
FROM domMCCDesc INNER JOIN (domEmployee INNER JOIN tblFuelman ON
domEmployee.EmployeeID=tblFuelman.CARDHOLDER) ON
domMCCDesc.ID=tblFuelman.MCC_DESC
GROUP BY domEmployee.FirstName & " " & [LastName], domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
HAVING (((tblFuelman.TRANSDATE) Between Forms!frmFuelmanByForeman!
txtStartDate And Forms!frmFuelmanByForeman!txtEndDate) And
((domEmployee.FirstName & " " & [LastName]) Not Like "keri*"));


Anything else I can try?




On Sep 11, 2:41 pm, "Ken Snell \(MVP\)"
wrote:
Also, make the same change (replace . with !) in the textboxes'
ControlSource expressions.

--

Ken Snell
MS ACCESS MVP

"Ken Snell (MVP)" wrote in
.. .

Try changing the WHERE clause's criterion to this (use ! instead of .):

Between [Forms]![frmFuelmanByForeman]![txtStartDate] And
[Forms]![frmFuelmanByForeman]![txtEndDate]

--

Ken Snell
MS ACCESS MVP

wrote in message
roups.com...
Access 2003 SP 2
Windows XP SP 2

I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman). I have created a form to select (or enter) a
date range that then filters the report based on that date range and
populates transactions between those dates. I have created two text
boxes on the report that display the start date (txtStartDT) and end
date (txtEndDT) entered in the date select form. The control source
on the date boxes on the report is
"=Forms.frmFuelmanByForeman.txtEndDate" & "...txtStartDate". In
Preview mode, the dates display fine; however, when I print the report
the date fields show #Name?

In the query I have the TRANSDATE set with a criteria of "Between
[Forms].[frmFuelmanByForeman].[txtStartDate] And [Forms].
[frmFuelmanByForeman].[txtEndDate]" and I have a non-visible text box
on the form for TRANSDATE, but I don't really believe either of these
have anything to do with the dates not showing up when the report is
printed.

Any assistance is greatly appreciated.

Thanks,
Eric

Try this and in the report textbox use =[txtEndDate] & "..." &
[txtStartDate].
SELECT domEmployee.FirstName & " " & [LastName] AS CardholderName,
Sum(tblFuelman.AMOUNT) AS SumOfAMOUNT, domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE, Forms!frmFuelmanByForeman!txtStartDate AS
txtStartDate, Forms!frmFuelmanByForeman!txtEndDate AS txtEndDate
FROM domMCCDesc INNER JOIN (domEmployee INNER JOIN tblFuelman ON
domEmployee.EmployeeID=tblFuelman.CARDHOLDER) ON
domMCCDesc.ID=tblFuelman.MCC_DESC
GROUP BY domEmployee.FirstName & " " & [LastName], domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
HAVING (((tblFuelman.TRANSDATE) Between Forms!frmFuelmanByForeman!
txtStartDate And Forms!frmFuelmanByForeman!txtEndDate) And
((domEmployee.FirstName & " " & [LastName]) Not Like "keri*"));



--
KARL DEWEY
Build a little - Test a little


" wrote:

Ok I did that, still not working. I did notice that I don't have a
WHERE clause in my query. It is a HAVING statement.

SELECT domEmployee.FirstName & " " & [LastName] AS CardholderName,
Sum(tblFuelman.AMOUNT) AS SumOfAMOUNT, domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
FROM domMCCDesc INNER JOIN (domEmployee INNER JOIN tblFuelman ON
domEmployee.EmployeeID=tblFuelman.CARDHOLDER) ON
domMCCDesc.ID=tblFuelman.MCC_DESC
GROUP BY domEmployee.FirstName & " " & [LastName], domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
HAVING (((tblFuelman.TRANSDATE) Between Forms!frmFuelmanByForeman!
txtStartDate And Forms!frmFuelmanByForeman!txtEndDate) And
((domEmployee.FirstName & " " & [LastName]) Not Like "keri*"));


Anything else I can try?




On Sep 11, 2:41 pm, "Ken Snell \(MVP\)"
wrote:
Also, make the same change (replace . with !) in the textboxes'
ControlSource expressions.

--

Ken Snell
MS ACCESS MVP

"Ken Snell (MVP)" wrote in .. .

Try changing the WHERE clause's criterion to this (use ! instead of .):

Between [Forms]![frmFuelmanByForeman]![txtStartDate] And
[Forms]![frmFuelmanByForeman]![txtEndDate]

--

Ken Snell
MS ACCESS MVP

wrote in message
roups.com...
Access 2003 SP 2
Windows XP SP 2

I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman). I have created a form to select (or enter) a
date range that then filters the report based on that date range and
populates transactions between those dates. I have created two text
boxes on the report that display the start date (txtStartDT) and end
date (txtEndDT) entered in the date select form. The control source
on the date boxes on the report is
"=Forms.frmFuelmanByForeman.txtEndDate" & "...txtStartDate". In
Preview mode, the dates display fine; however, when I print the report
the date fields show #Name?

In the query I have the TRANSDATE set with a criteria of "Between
[Forms].[frmFuelmanByForeman].[txtStartDate] And [Forms].
[frmFuelmanByForeman].[txtEndDate]" and I have a non-visible text box
on the form for TRANSDATE, but I don't really believe either of these
have anything to do with the dates not showing up when the report is
printed.

Any assistance is greatly appreciated.

Thanks,
Eric

Nevermind about this last message. I figured it out.


On Sep 11, 3:36 pm, "
wrote:
Ok I did that, still not working. I did notice that I don't have a
WHERE clause in my query. It is a HAVING statement.

SELECT domEmployee.FirstName & " " & [LastName] AS CardholderName,
Sum(tblFuelman.AMOUNT) AS SumOfAMOUNT, domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
FROM domMCCDesc INNER JOIN (domEmployee INNER JOIN tblFuelman ON
domEmployee.EmployeeID=tblFuelman.CARDHOLDER) ON
domMCCDesc.ID=tblFuelman.MCC_DESC
GROUP BY domEmployee.FirstName & " " & [LastName], domMCCDesc.MCCDESC,
tblFuelman.TRANSDATE
HAVING (((tblFuelman.TRANSDATE) Between Forms!frmFuelmanByForeman!
txtStartDate And Forms!frmFuelmanByForeman!txtEndDate) And
((domEmployee.FirstName & " " & [LastName]) Not Like "keri*"));

Anything else I can try?

On Sep 11, 2:41 pm, "Ken Snell \(MVP\)"

wrote:
Also, make the same change (replace . with !) in the textboxes'
ControlSource expressions.

--

Ken Snell
MS ACCESS MVP

"Ken Snell (MVP)" wrote in .. .

Try changing the WHERE clause's criterion to this (use ! instead of .):

Between [Forms]![frmFuelmanByForeman]![txtStartDate] And
[Forms]![frmFuelmanByForeman]![txtEndDate]

--

Ken Snell
MS ACCESS MVP

wrote in message
roups.com...
Access 2003 SP 2
Windows XP SP 2

I have created a report (rptFuelmanByForeman) that is based on a Query
(qryFuelmanByForeman). I have created a form to select (or enter) a
date range that then filters the report based on that date range and
populates transactions between those dates. I have created two text
boxes on the report that display the start date (txtStartDT) and end
date (txtEndDT) entered in the date select form. The control source
on the date boxes on the report is
"=Forms.frmFuelmanByForeman.txtEndDate" & "...txtStartDate". In
Preview mode, the dates display fine; however, when I print the report
the date fields show #Name?

In the query I have the TRANSDATE set with a criteria of "Between
[Forms].[frmFuelmanByForeman].[txtStartDate] And [Forms].
[frmFuelmanByForeman].[txtEndDate]" and I have a non-visible text box
on the form for TRANSDATE, but I don't really believe either of these
have anything to do with the dates not showing up when the report is
printed.

Any assistance is greatly appreciated.

Thanks,
Eric