Create report between two dates.

  • Thread starter Thread starter spcscooter via AccessMonster.com
  • Start date Start date
S

spcscooter via AccessMonster.com

I am trying to create a report that returns dates between two dates. The
criteria that I am using works in the following...

I have a column in a query that states in the field "Completion Date" and it
points to the CPR table.
When I use Between [Start Date] and [End Date] I get the dates between.

The field that I need it to work in is "Expiration Date: DateAdd("yyyy",2,
[Certification Date])" is stored and calculated in the query. The Between
[Start Date] and [End Date] criteria doesn't work with this field.

Can someone tell me how to make this work or what to do in order to get what
I need.

Thank you very much. I don't know what I would do if it weren't for you all.

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com
 
"Doesn't work" is subject to wild speculation ... are you saying that Access
fails without an error message? or maybe that your PC begins smoking? or
hair grows on your knuckles? <g>

I'm not exactly clear on what you're working with, so if I've
misinterpreted...

It sounds like you have a field in your query named [ExpirationDate], a
calculated value. It sounds like you want to find [ExpirationDate] values
between a user-entered 'start' date and a user-entered 'end' date.

If I were doing this, in the Selection Criterion "cell" beneath
[ExpirationDate], I'd put something like:

Between # & [Enter a start date] & # And # [Enter an end date] & #

If you'd like to avoid messing with the "#" signs, you could try setting
these two parameters as date/time-type parameters, in addition to using them
as selection criteria.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
It returns nothing when I switch to datasheet view. You correct about It
sounds like you have a field in your query named [ExpirationDate], a
calculated value. It sounds like you want to find [ExpirationDate] values
between a user-entered 'start' date and a user-entered 'end' date.

I am kinda new to this so if you could explain to me what the # is used for
and how to change the parameters I would really apreciate it.

Thank you for responding so quickly

Jeff said:
"Doesn't work" is subject to wild speculation ... are you saying that Access
fails without an error message? or maybe that your PC begins smoking? or
hair grows on your knuckles? <g>

I'm not exactly clear on what you're working with, so if I've
misinterpreted...

It sounds like you have a field in your query named [ExpirationDate], a
calculated value. It sounds like you want to find [ExpirationDate] values
between a user-entered 'start' date and a user-entered 'end' date.

If I were doing this, in the Selection Criterion "cell" beneath
[ExpirationDate], I'd put something like:

Between # & [Enter a start date] & # And # [Enter an end date] & #

If you'd like to avoid messing with the "#" signs, you could try setting
these two parameters as date/time-type parameters, in addition to using them
as selection criteria.
I am trying to create a report that returns dates between two dates. The
criteria that I am using works in the following...
Click to expand...
[quoted text clipped - 11 lines]
Thank you very much. I don't know what I would do if it weren't for you all.
Click to expand...
Click to expand...

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com
 
Since you are using a calculated field in your query, Access may not
correctly interpret that it is a date-type value. The "#" is used as
delimiters around date-values. Similarly, the double-quote (") is used
around text-values as a delimiter.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

spcscooter via AccessMonster.com said:
It returns nothing when I switch to datasheet view. You correct about It
sounds like you have a field in your query named [ExpirationDate], a
calculated value. It sounds like you want to find [ExpirationDate] values
between a user-entered 'start' date and a user-entered 'end' date.

I am kinda new to this so if you could explain to me what the # is used for
and how to change the parameters I would really apreciate it.

Thank you for responding so quickly

Jeff said:
"Doesn't work" is subject to wild speculation ... are you saying that Access
fails without an error message? or maybe that your PC begins smoking? or
hair grows on your knuckles? <g>

I'm not exactly clear on what you're working with, so if I've
misinterpreted...

It sounds like you have a field in your query named [ExpirationDate], a
calculated value. It sounds like you want to find [ExpirationDate] values
between a user-entered 'start' date and a user-entered 'end' date.

If I were doing this, in the Selection Criterion "cell" beneath
[ExpirationDate], I'd put something like:

Between # & [Enter a start date] & # And # [Enter an end date] & #

If you'd like to avoid messing with the "#" signs, you could try setting
these two parameters as date/time-type parameters, in addition to using them
as selection criteria.
I am trying to create a report that returns dates between two dates. The
criteria that I am using works in the following...
Click to expand...
[quoted text clipped - 11 lines]
Thank you very much. I don't know what I would do if it weren't for
Click to expand...
Click to expand...
you all.

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com
Click to expand...
 
Back
Top