access report

[Guest]

Report for Holiday pay. Need to be able to put holiday date in and have it
calculate from hire date to see if has been here 90 days and can get holiday.
I'm having a problem where to enter the holiday date????

 

[Al Camp]

rlh,
A basic method would be a parameter query behind your report.
In the HireDate column of your report query...
< DateAdd("d",-90,[Enter Holiday Date])
When the report runs, you'll be prompted for a "Enter Holiday Date"
The report will deliver those HireDates that are less than than [Enter Holiday Date] by
90 days.

 

[Guest]

Al,
I tried this and it just ask for the Holiday Date and then showed everyone
with there 90 Day Date. I put it in the Query that the report runs off of.
I'm not sure what I'm doing wrong. Please Help!

rlh,
A basic method would be a parameter query behind your report.
In the HireDate column of your report query...
< DateAdd("d",-90,[Enter Holiday Date])
When the report runs, you'll be prompted for a "Enter Holiday Date"
The report will deliver those HireDates that are less than than [Enter Holiday Date] by
90 days.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Report for Holiday pay. Need to be able to put holiday date in and have it
calculate from hire date to see if has been here 90 days and can get holiday.
I'm having a problem where to enter the holiday date????

 

[jahoobob via AccessMonster.com]

Did you put this in the criteria of the Hire date?

Al,
I tried this and it just ask for the Holiday Date and then showed everyone
with there 90 Day Date. I put it in the Query that the report runs off of.
I'm not sure what I'm doing wrong. Please Help!

rlh,
A basic method would be a parameter query behind your report.

[quoted text clipped - 6 lines]

 

[Guest]

Yes. I put in in the criteria of my Hire field. Any suggestions???

Did you put this in the criteria of the Hire date?

Al,
I tried this and it just ask for the Holiday Date and then showed everyone
with there 90 Day Date. I put it in the Query that the report runs off of.
I'm not sure what I'm doing wrong. Please Help!

rlh,
A basic method would be a parameter query behind your report.

[quoted text clipped - 6 lines]

calculate from hire date to see if has been here 90 days and can get holiday.
I'm having a problem where to enter the holiday date????

 

[Al Camp]

What is the "exact" criteria you placed in the Hire Date column of the report query.
I don't understand that statement...
Do you mean that the criteria didn't work, and the query returned "everyone's" Hire
Date in that column... not just the one's that have a Hire Date older than 90 days ago?

What did you enter for a Holiday date (show what you typed into the parameter request)
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Yes. I put in in the criteria of my Hire field. Any suggestions???

Did you put this in the criteria of the Hire date?

Al,
I tried this and it just ask for the Holiday Date and then showed everyone
with there 90 Day Date. I put it in the Query that the report runs off of.
I'm not sure what I'm doing wrong. Please Help!

rlh,
A basic method would be a parameter query behind your report.
[quoted text clipped - 6 lines]
calculate from hire date to see if has been here 90 days and can get holiday.
I'm having a problem where to enter the holiday date????

 

[Guest]

Al,
I typed DateAdd("d"+89,[Enter Holiday]) in the criteria. Is this not right?
I'm not to up on how to type this stuff in. Any help is appreciated.

What is the "exact" criteria you placed in the Hire Date column of the report query.
I don't understand that statement...
Do you mean that the criteria didn't work, and the query returned "everyone's" Hire
Date in that column... not just the one's that have a Hire Date older than 90 days ago?

What did you enter for a Holiday date (show what you typed into the parameter request)
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Yes. I put in in the criteria of my Hire field. Any suggestions???

Did you put this in the criteria of the Hire date?

rlh wrote:
Al,
I tried this and it just ask for the Holiday Date and then showed everyone
with there 90 Day Date. I put it in the Query that the report runs off of.
I'm not sure what I'm doing wrong. Please Help!

rlh,
A basic method would be a parameter query behind your report.
[quoted text clipped - 6 lines]
calculate from hire date to see if has been here 90 days and can get holiday.
I'm having a problem where to enter the holiday date????

 

[jahoobob via AccessMonster.com]

You left out the less than sign "<"

Al,
I typed DateAdd("d"+89,[Enter Holiday]) in the criteria. Is this not right?
I'm not to up on how to type this stuff in. Any help is appreciated.

What is the "exact" criteria you placed in the Hire Date column of the report query.

[quoted text clipped - 19 lines]

 

[Al Camp]

rth,
I typed it for you in my previous post...
In the HireDate column of your report query...

< DateAdd("d",-90,[Enter Holiday Date])

If someone offers a solution, it's best to follow those instructions exactly...

Take some time to study the DateAdd Function in Help.

Also, please do not delete any posts in the thread when you reply. Others trying to
help you don't know what code I suggested, because you snipped it out of the thread. That
way, the history of the problem resolution is available for everyone to review in the last
post.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Why didn't you try what I suggested?

Al,
I typed DateAdd("d"+89,[Enter Holiday]) in the criteria. Is this not right?
I'm not to up on how to type this stuff in. Any help is appreciated.

What is the "exact" criteria you placed in the Hire Date column of the report
query.

I tried this and it just ask for the Holiday Date and then showed everyone
*with there 90 Day Date*

I don't understand that statement...
Do you mean that the criteria didn't work, and the query returned "everyone's" Hire
Date in that column... not just the one's that have a Hire Date older than 90 days ago?

What did you enter for a Holiday date (show what you typed into the parameter
request)
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Yes. I put in in the criteria of my Hire field. Any suggestions???

:

Did you put this in the criteria of the Hire date?

rlh wrote:
Al,
I tried this and it just ask for the Holiday Date and then showed everyone
with there 90 Day Date. I put it in the Query that the report runs off of.
I'm not sure what I'm doing wrong. Please Help!

rlh,
A basic method would be a parameter query behind your report.
[quoted text clipped - 6 lines]
calculate from hire date to see if has been here 90 days and can get holiday.
I'm having a problem where to enter the holiday date????

 

[Guest]

jahoobob,
I have my field that figures my 90 days from the hire date. I want to be
able to ask for a uniuqe date that will give me the names of the employees
that are < or = the date I put in. This date will change with each holiday.
Anyone with a crappy attitude need not reply.
Thanks,
rlh

You left out the less than sign "<"

Al,
I typed DateAdd("d"+89,[Enter Holiday]) in the criteria. Is this not right?
I'm not to up on how to type this stuff in. Any help is appreciated.

What is the "exact" criteria you placed in the Hire Date column of the report query.

[quoted text clipped - 19 lines]

calculate from hire date to see if has been here 90 days and can get holiday.
I'm having a problem where to enter the holiday date????

 

[Guest]

Just wanted to thank you for your help. I finally figured a round about way
to let me know if an employee should get holiday.I used the following in two
seperate unbound text boxs in my report to say no if they would not.

=DateDiff("d",[What Date],[90 Days])
=IIf([Days Diff]>0,"no")

 

[John Spencer]

You should be able to do that all in one. IF that is what you want to do.

=IIF(DateDiff("d",[What Date],[90 Days])>0,"No", "Yes")

Just wanted to thank you for your help. I finally figured a round about
way
to let me know if an employee should get holiday.I used the following in
two
seperate unbound text boxs in my report to say no if they would not.

=DateDiff("d",[What Date],[90 Days])
=IIf([Days Diff]>0,"no")

Report for Holiday pay. Need to be able to put holiday date in and have
it
calculate from hire date to see if has been here 90 days and can get
holiday.
I'm having a problem where to enter the holiday date????