it's really simple, but I just can't figure it out
I have this Query , with Part#, S/N , and #Received

I just want to put them in my report the way I want it
Basically just fill in the blanks, I designed my report , it's My company form, that's how I want my report to look like, and all I want is to fill in the S/Ns in that report, all in one page.


Thanks

Use the query as the recordsource for the report. Since you didn't do this when you built the report, the controls are all unbound so you'll also have to go through the process of binding the controls. For the controlsource of each control, choose a column from the list of available columns.

Next time you need a report, build the query first. Then choose that query as the recordsource when building the report and Access will bind the controls as you place them.

thanks
but my problem is access shows all the records in that query one after another
in the details section it's just p/n ans s/n
what I have is, I choose a kit #
and in my query all the parts that belonge to that kit# show up,
now I have this Cmpany form, "Receiving report" , which I have to fill in the S/N for all the parts,
what I need is to tell access to go to this row, with p/n="xxxx"
and put the S/N of that part in this part of the report...
and next, go to the second p/n ,and same thing


thanks

my problem is , let's say s/n
they are all under one record in the query, named s/n
so i need my report to go to the line in the query i want it to, and then give me that s/n
and do the same thing for next part

I can't make any sense out of your question. Are you trying to choose a record on a form and then print out a report for just that record? Are you trying to synchronize a subreport?

ok i have this query with the following records

p/n | s/n | #received | Kit# |
--------------|---------------|-------------------|--------------|
pn1 | sn1 | r1 | xxx |
pn2 | sn2 | r2 | xxx |
pn3 | sn3 | r3 | xxx |

now , i create this report layout...

-----------------------------------------------------------------------
| p/n | description | # | value |
| | | | |
| pn2 | absdcscds | r2 | $ |
| | S/N.....sn2..... | | |
| pn3 | dsadasdasd | r3 | $ |
| | S/N......sn3.... | | |
| pn1 | ,jh,hj,hj,u | r1 | $ |
| | S/N......sn1..... | | |
| | | | |


so i want s/n matching the p/n in the right place in my report

ok i have this query with the following records

p/n | s/n | #received | Kit# |
-----|-----|-----------|--------|
pn1 | sn1 | r1 | xxx |
pn2 | sn2 | r2 | xxx |
pn3 | sn3 | r3 | xxx |

now , i create this report layout...

-----------------------------------------------------------------------
|-p/n-|description|--#--|value|
|------|------------|------|-------|
|pn2--|absdcscdso|-r2--|---$--|
|------|S/N...sn2...|-----|-------|
|pn3--|dsadasdas-|-r3--|---$--|
|------|S/N...sn3...|-----|-------|
|pn1--|jh,hj,hj,ujg|-r1-|---$--|
|------|S/N...sn1...|-----|-------|
|------|-------------|-----|-------|


so i want s/n matching the p/n in the right place in my report

basically what i want to find out is how to map my fields in a report....

Hi Mak,

Lets back up a little so we can get a better picture of your design....

Can you list the fields for each table and how you have them related.

Also your query, is it a single table query or one with "joins" to other tables/queries. Does your form have a Subform?

You should have at least 2 tables, One for the Kits and the other for the Parts. Ideally I think maybe a third for the s/n# (Serial number?).



Ziggy

hey,

ok i have a table called GFE, which includes
1.product ID
2. item number
3. part number
4. desc
5. unit price

then i have one table for called GFE transaction, which includes
1. Product ID
2. PO Number
3. KIT #
4. s/n (serial number)
5. # received
6. date received

then i have a table for kit
1. kit #
2. date received

in my forms section , i have one form called GFE , which is the details out of GFE table, and a subform, to enter PO number, S/N.... Kit number, for that specific part.

i hope you are following me by now

now i have a query , which asks for kit #
and then lists all the parts in that kit# with their s/n and #received



what i want is to be able to map those s/n , out of that query, in my pre-designed report...

and print the report with all the s/n in it, which will be my receiving report, and then i sign it, or whoever else, received these parts and enter them in the computer , can just print this and sign it....
i hope i explained it a bit better

sorry for all the confusion....

I believe I answered your question at the following:

Report Question (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47630)

Let us know if this is what you are looking for...

thanks for all your help...

ok one other thing i gotta explain is that , i got this report form from microsoft word, and just copy and paste it in my Access report's details...

i don't know if that changes anything or not..

so i got this form , from word, and i want to map my s/n fields into that form...

I think that you are asking about how to make a subreport. That is the method you would use when presenting data from both the one side table (main report) and the many side table (subreport).

If you open your main report in design view, you can use the subreport tool to add a subreport or if you already have the subreport built, you can just drag it onto the main report's detail section and resize it.

I wonder if Mail Merge will do the trick, I never use it. The transfer text Action in macro has an "Export Word for Windows Merge" option. I've never used it, but maybe the others can assist?

Ziggy