report questions....?!?!

[Gmio]

hey, i am in the final progress to finish the project.

this database basically enter merchants details and sales record and at the end it will print out a Remittance Advice for them to look at. i have done all the calculation for the report.... such as GST on sales, merchants detail etc.

i got few questions i need to find out:
1- i need to create an autonumber for the Remittance Advice report(diffrent number when they create the REPORT), the text will show: RAEB2305 -> stands for Remittance Advice EBAY and todays date. so that the client can know when this is created and to who. ( any alternate way to do it?)

2- every merchants have diffrent sales details, can i have a function that will save the report everytimes i create the Remittace advice

3- Can the report convert to the PDF file? how?

thanks pro !

 

[neileg]

1- i need to create an autonumber for the Remittance Advice report(diffrent number when they create the REPORT), the text will show: RAEB2305 -> stands for Remittance Advice EBAY and todays date. so that the client can know when this is created and to who. ( any alternate way to do it?)

Not really an autonumber, is it? What I would do is create this number and save it in a field where the transaction is held. I'd also have a field that tells if the remittance advice has been printed. I'd use an update query for this. This way you can run a query that looks for unprinted transactions and groups them in a report by advice number.

2- every merchants have diffrent sales details, can i have a function that will save the report everytimes i create the Remittace advice

You don't need to do this if you follow my advice. You will be able to rerun the report from the advice number in the transaction table any time you want to look at it.

3- Can the report convert to the PDF file? how?

You need a piece of software that creates PDF files. You install this as a printer and then Access prints the report and it comes out as a PDF. I have used CutePDF before to do this. The most expensive software is Adobe Acrobat, but there are some free PDF applications out there in cyberspace.

 

[Gmio]

Not really an autonumber, is it? What I would do is create this number and save it in a field where the transaction is held. I'd also have a field that tells if the remittance advice has been printed. I'd use an update query for this. This way you can run a query that looks for unprinted transactions and groups them in a report by advice number.

.

very helpful thank you, but 1 thing i dont get it which is "This way you can run a query that looks for unprinted transactions and groups them in a report by advice number." can u make an example for me to look at? i dont quite get it

thank you pro!