By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,653 Members | 1,354 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,653 IT Pros & Developers. It's quick & easy.

Entered data in query to form

P: n/a
I have a query that the user inputs last name of the customer and
wants the output to be a specific form (that form is the form that all
the information is entered originally). How do I set up the form to
print to the created form instead of to the optional columnar,
tabular, datasheet or justified?

Hope this makes sense.


Posted using the interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL:
Visit Topic URL to contact author (reg. req'd). Report abuse:
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
create a report and use it to format your data any way you want in any
layout you want.

Nov 13 '05 #2

P: n/a
> Hope this makes sense.

st_moose wrote (paraphrased):

I have a query with a parameter for the Last Name of the customer.
When the user runs the query they type the Last Name into the box that
comes up. The user wants a report to come up where the data is
arranged the same as it was on the form used to input the information
originally. How do I set it up so that the report prints in this
format rather than the way the query shows it?

Create a report and find the menu item called Properties. Then under
the 'All' tab click to the right of the 'Record Source.' Then click on
the three dots. Select the query you are using. Highlight the first
field then hold down the shift key and highlight the last field. All
of the fields should turn blue. Click and hold the mouse button down
on the blue area and drag all the fields into the first box labeled
'Field:.' Close the QBE editor with the X button and click 'Yes' to
save the changes. Now select 'Field List' from the 'View' menu. You
should be able to drag each field onto the Detail section of the
report. Then you can arrange them in a way that looks like the input
form. When the user opens the report, the query will run and prompt
for the Last Name like always. Note that if several people have the
same last name the report will have several pages.

I hope this helps,
James A. Fortune

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.