How to I add query results to a form using MSAccess?

Question

I am fairly new to Access. I made a query to calculate fields such as Total Price:[Quantity]*[Unit Price]. When I run the query the calculations show up however I would like the results to also show within a form. Is that possible?? And if so, how can I get it done (step by step)

Okay, I figured out how to do this. However can anyone tell me if I can maniuplate a field in an Access query that will turn red if the number is below 5? How would I go about writing the code for this and where?

Answer 1

As for the second part of the question: simple use "Conditional Formatting" from the menu. Will to the trick in most of the cases without programming.