Replies

It is better now – however I can’t seem to make it work.

If Not rst2.BOF Then
rst2.MovePrevious

On MovePrevious – error no record.

Thanks

I got it – removed!
However ‘too few parameters’ occures far before that at second line of below:

strSQL2 = “SELECT * FROM GRADES WHERE ID=” & rst1!ID & ” ORDER BY Date”
Set rst2 = dbs.OpenRecordset(strSQL2, dbOpenDynaset)

The Logic:
Find Max Date per ID and check the SalGrade.
Find Previous to the MaxDate and check IF SalGrade is different.
If so – write into table.

It use to be
Find Action PRO per ID and check the SalGrade etc…

Thanks for helping me. I am miffed because it works fine for the old Grade table with only difference that it has Action field.
What is wrong with my new one?
Maybe when it was looking for Action=PRO – it was looking at the single record, now it is grabbing whole bunch and says ‘too many – need 1’ – so this is why I want to have Max Date but it is not reading it right.

1 you have modify Date to Dates in the table Grades, but not in your code.
Done
2 you have comment out the line with rst2.findfirst and not those that follow with If rst2.NoMatch.
Done
3 In the Insert lines you have value rst2!Action that don’t exist.
What to do to correct it?
4 Did you remove the field Action it the table Grades
I did.

Still get ‘too few parameters’ though…
Thanks

Got it – Zips only!!!!!

I hoped you would ask

It seems I can’t upload 220KB database. Is there anything wrong with an upload feature?
Will try again. Thanks

ID is numeric.

Now it says ‘too few parameters – need 1’ at the
Set rst2 = dbs.OpenRecordset(strSQL2, dbOpenDynaset)
line.

Thanks

Nope! It says ‘no current record’.
I thought making it sort desc will not solve the issue because I will be still going up where there is no record.
Maybe I need to change dbOpenForwardOnly to something?

Thanks

WOW!
It is amazing!
Hans, how do you know all this???
I just told my boss it is impossible but I have last resort…

THANKS SO MUCH

I am sorry – I will try better.

Main report is as follows:

____________Report__NAME___________ xxx(Page Header)

________________________CityA__CityB__CityC___Totalxxx(Page Header)

Countryxxx(Group Header)___x_____x______x________x

Totalxxx(Group Footer)______x_____x______x________x

SUB Report1xxx(Report Footer)

Body of the Sub Report :

____________Report__NAME___________ xxx(Page Header)

_____________________Totalxxx(Page Header)

Citiesxx(Group Header)___x

Totalxxx(Group Footer)___x

_____________________________________________________

So the SUB Report is the summary of the Main.
It is one Report with 2 SUBs that are different cuts anf totals of the Main.

Here is what is happening.

Report has a Page Header:

____________Report__NAME___________

_____________ColA__ColB__ColC___Total

********Data etc….

Report_Footer has 2 SUB Reports with Page Headers:

____________Report__NAME___________

_____________CityColA__CityColB__CityColC___Total

********Data etc….

AND

____________Report__NAME___________

_____________SumColA__SumColB__SumColC___Total

********Data etc….

So – Report names are the same – headers for the column s are differentfor each.

When I am printing – Main Report’s Page Headers appearing on SUB Reports.
I had tried to set RH to Not with Rpt Hdr – this way nothing gets printed for SUBS.

I am playing with different options and none seem works. I am sure I am overlooking one that is correct one.
I hope there is one, thank you.

P.S. Desired outcome is each of 3 Reports showing same Report name and different headers per each. Every Report has more then 1 page. Thanks

Thanks, Hans, I did it and it works.

Sorry, it did, exactly! Thanks so much.

My apology, I was wrong. I forgot some conditions I had entered manually and it made your formula seems off.

How do I enter into conditional formatting that
If Name has + – color it green? What do I chose – Expression Is field or Field Value Is?

Thanks so much and good week to all!!!

Thanks, it is awesome!

I want to report a slight problem.

The original query from Crystal looked like following:

if {TABLE1.FULL/PART TIME} = “F” and {TABLE1.Transfer} = 0 and {TABLE1.New Hire} = 0
then
{TABLE1.LAST NAME}& “,”& {TABLE1.FIRST NAME} & “-” &{TABLE1.SUB LOB}

else if
{TABLE1.Transfer} = 0 and {TABLE1.New Hire} = 0
then
{TABLE1.LAST NAME}& “,”& {TABLE1.FIRST NAME}& ” (” & {TABLE1.FULL/PART TIME} &”) “& “- ” & {TABLE1.SUB LOB}

else if
{TABLE1.New Hire} = 0 then
“~” & {TABLE1.LAST NAME}& “,”& {TABLE1.FIRST NAME} & “-” & {TABLE1.Prior SUB} & ” to ” & {TABLE1.SUB LOB}

else
“+” &{TABLE1.LAST NAME}& “,”& {TABLE1.FIRST NAME} & ” (” & {TABLE1.FULL/PART TIME} &”) “& “- ” &{TABLE1.SUB LOB}

************************************************************************

When we re-did it for the Access we lost else if and else and now I am getting records that are both – tilda and plus etc…

When I am using OR – it makes my names into -1 for some reason.

I think Crystal gets each part as a remander of the previous.
Like a cieve effect. It extracts following portion from left over data after first portion was extracted.
Am I confusing you completely? Sorry.

I have one more task to complete that is strange.

I need to color those names
those with tilda in front should be pink, those with plus sign – purple. Is it doable? Thanks