Search results

Paul, I see but there is no proper properties to set the format of the report control, e.g. change font color. Mike

I noted that the maximum number of conditions you can put in on a report contol is 3. Does any one know how to include more than 3 conditions to format a control in report? I tried to search the forum and google it without avail. Is there an alternative way to change the format of a field on a...

Why don't you create a selected query based on the table and create a new field - PriceWithTax:[intModelPrice]*1.18 When ever you run this query, field PriceWithTax will calculate the total price. Rule of thumb is never try to enter calculated fields in tables. Mike:)

Hi mhinkle, I know it would be messy to put everything in one formula. I have inserted formula into different fields in query qselTestTime and it should make things easier for you to follow. You may run another query qselTimeDiff_ForBoss and show it to your boss. Please see db attached. Take...

Challenge on Crosstab Query - RESOLVED :)CraigDolphin, Thanks for your quick response. You are very resourceful and helpful. I believe I did put the function name correct on the test db. I used CombinePurpose as the field label only. Anyway, you hit it right on the nail - the problem is with...

HTH, Your suggestion is a good approach but the problem is I can not make the function work. The CombinePurpose field in the query always return nothing. Not sure what I have done wrong. The Cross Training table have the TrainerID & TraineeID looked up to the Employee Table for Employee Name. I...

I don't know if there is a simple solution to this due to the limitation on the DateDiff function but you may do it in a long & winding way as follows: 1) Get the time difference in minutes and convert the result to the unit of hour, then convert the result to string. TimeDiff =...

Challenge on Crosstab Query -RESOLVED Hope any Access guru can help me with this problem. I want to create a cross training matrix with crosstab query in Access to show the relationship between the trainers and trainees with purpose of the trainings from the following table...

I have a question on Crosstab query and hope someone on the forum can help me to resolve the problem. I want to create a cross training matrix with crosstab query in Access to show the relationship between the trainers and trainees with purpose of the trainings from the following table...

Crosstab query - concatenate values I have a question on Crosstab query and hope someone on the forum can help me to resolve the problem. I can not create a new thread on this topic. I want to create a cross training matrix with crosstab query in Access to show the relationship between the...