Does anybody know how to do this?

[Mak 7]

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

 

[Mak 7]

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

 

[Mak 7]

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

 

[Mak 7]

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

 

[Mak 7]

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

 

[Mak 7]

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

 

[Ziggy1]

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

 

[Mak 7]

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....

 

[jfgambit]

I believe I answered your question at the following:

Report Question

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

 

[Mak 7]

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...

 

[Ziggy1]

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