Does anyone know how to make a report, edit a query. To make it print a certain name only within a field
-
-
Hi,
Click on queries, New query, Select your table with data on it!
When the table appears in your query designer, click 2 times on the field that you want to visualize and you are ready!
You have to pass to datasheet view from view menu! And your report is ok!
Have a nice chance!
:) -
i've already designed the query but i'll want the user to change the criteria as soon as the report is open with the use of a combo box with a list of names taken from the field in the query, is this possible.....
Originally posted by PEBComment
-
Yes it is...
So you need a form with combobox on it with the needed list!
Also put a button that will be pressed when the user does his choice! This button will open your query or report!
Connect your query with your form! Every field in your form has a name! The reference from the query is by name
for exemple:
=Forms!My_form! Test0
Where Test0 is a control in form My_Form
Have a nice day!
:)Comment
Comment