Access 97 Report Conditional Formatting

[chris_dono]

I know you can't do this via conditional formatting and you have to use some code to do it in the format event....

BUT

I'm having problems with one at the moment (it's pretty complex)

Main report shows days that sales were made by someone
sub report linked via employee id shows days that were worked.

what I want to do is make the controls bold if the day if the same in the main report and subreport

I've tried creating a recordset and seeking through it to see if that day and that employee id are there, but it means that the report doesn't open anymore so I've removed it.

Can someone help ?

 

[chris_dono]

is there no-one that can help ?

 

[chris_dono]

you are right, that is the relationship between the two, but the report has to be backwards (it was asked for like that)

normally, I'd be able to do this without too much hassle, but I've tried it about 4 different ways and can't get it to work

 

[chris_dono]

main report part has days that sales were made, based on sales date (many side)
subreport has days worked regardless of sales (one side)

I want to make the days worked without sales bold

the subreport is linked to the main report via an employee id, not dates of any kind

 

[chris_dono]

not sure what you mean mate, both the report and the subreport are based on queries, and both of them look at the date worked, but one looks at them joined to sales and one doesn't