Why dont posts get answered?

[ksecrist via AccessMonster.com]

I sent this post on 11/30/06 and no one has responded. Is this too
complicated a question?

If not here is my question reposted.

Hi Access Guru's,

I am attempting to generate a chart on a report in which the user is prompted
to select a [Beginning Date] data and [Enddate]. When I try and run this an
error message indicates "The Microsoft Jet Database engine does not
recognize'[Beginning Date]' as a valid field name or expression". Then
another error message pops up regarding the size of the data.

What can I do to allow the user to select the date range of the data and then
print a report with a chart on it?

Thanks,
K

 

[Jeff C]

I do this all the time so if set up properly it should work, the record
source for bot the chart and the report needs to reference the same
source for the dates. I use a form but my controls are just named
[beginning] and [end], you can label them anything you want. Using
spaces in control names is not good practice nor is using "Date".

Make sure the controls are formatted correctlym I generally am using
queries as a record source for my output and criteria something like
between forms!myfrom.beginning and froms!myform.end.

Everyone in here is a volunteer and answers are never guaranteed, a
kind repost after a month is no problem but by complaining you may not
get many responses.

Good Luck

 

[Al Campagna]

Jeff,
Just a minor point...

Using spaces in control names is not good practice * nor is using "Date".*

Ditto on the spaces... but... [Enter Starting Date] is a legitimate query parameter, and
[TransDate] or [StartingDate] would be legitimate field names. Yes, the spaces should be
avoided, but the use of the word Date in these contexts is OK.

It's just when [Date] is used alone as a parameter, or a field name, that problems can
arise.
--
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."



[Enter Starting Date]

I do this all the time so if set up properly it should work, the record
source for bot the chart and the report needs to reference the same
source for the dates. I use a form but my controls are just named
[beginning] and [end], you can label them anything you want. Using
spaces in control names is not good practice nor is using "Date".

Make sure the controls are formatted correctlym I generally am using
queries as a record source for my output and criteria something like
between forms!myfrom.beginning and froms!myform.end.

Everyone in here is a volunteer and answers are never guaranteed, a
kind repost after a month is no problem but by complaining you may not
get many responses.

Good Luck

I sent this post on 11/30/06 and no one has responded. Is this too
complicated a question?

If not here is my question reposted.

Hi Access Guru's,

I am attempting to generate a chart on a report in which the user is prompted
to select a [Beginning Date] data and [Enddate]. When I try and run this an
error message indicates "The Microsoft Jet Database engine does not
recognize'[Beginning Date]' as a valid field name or expression". Then
another error message pops up regarding the size of the data.

What can I do to allow the user to select the date range of the data and then
print a report with a chart on it?

Thanks,
K

 

[Duane Hookom]

Doesn't anyone reply back in their own threads?


--
Duane Hookom
MS Access MVP

I answered your question on 11/30/06 at 4:50 PM. You never replied back to
my
suggestion.

http://groups.google.com/group/micr...f54076bf0aa?lnk=st&q=&rnum=2#cb948f54076bf0aa

--
Duane Hookom
Microsoft Access MVP

I sent this post on 11/30/06 and no one has responded. Is this too
complicated a question?

If not here is my question reposted.

Hi Access Guru's,

I am attempting to generate a chart on a report in which the user is
prompted
to select a [Beginning Date] data and [Enddate]. When I try and run this
an
error message indicates "The Microsoft Jet Database engine does not
recognize'[Beginning Date]' as a valid field name or expression". Then
another error message pops up regarding the size of the data.

What can I do to allow the user to select the date range of the data and
then
print a report with a chart on it?

Thanks,
K

 

[fredg]

I run a similar query to generate a phone bill-like statement, prompting for
beginning and end dates. Here's my question: Now the boss wants to show
those beginning and end dates on the statement. How can I display the query
parameters in a report?

Thank you in advance for your help!

Jeff,
Just a minor point...

Using spaces in control names is not good practice * nor is using "Date".*

Ditto on the spaces... but... [Enter Starting Date] is a legitimate query parameter, and
[TransDate] or [StartingDate] would be legitimate field names. Yes, the spaces should be
avoided, but the use of the word Date in these contexts is OK.

It's just when [Date] is used alone as a parameter, or a field name, that problems can
arise.
--
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

[Enter Starting Date]

I do this all the time so if set up properly it should work, the record
source for bot the chart and the report needs to reference the same
source for the dates. I use a form but my controls are just named
[beginning] and [end], you can label them anything you want. Using
spaces in control names is not good practice nor is using "Date".

Make sure the controls are formatted correctlym I generally am using
queries as a record source for my output and criteria something like
between forms!myfrom.beginning and froms!myform.end.

Everyone in here is a volunteer and answers are never guaranteed, a
kind repost after a month is no problem but by complaining you may not
get many responses.

Good Luck


ksecrist via AccessMonster.com wrote:
I sent this post on 11/30/06 and no one has responded. Is this too
complicated a question?

If not here is my question reposted.

Hi Access Guru's,

I am attempting to generate a chart on a report in which the user is prompted
to select a [Beginning Date] data and [Enddate]. When I try and run this an
error message indicates "The Microsoft Jet Database engine does not
recognize'[Beginning Date]' as a valid field name or expression". Then
another error message pops up regarding the size of the data.

What can I do to allow the user to select the date range of the data and then
print a report with a chart on it?

Thanks,
K

Add an unbound text control to the Report Header.

Set it's congtrol source to:
= "Purchases for the period of: " & [Beginning Date] & " through " &
[EndDate]

The bracketed text must be identical to the bracketed text in the
query.