Recipt as a report

[tom1252]

My system is a sales system. When some one buys products i want to be able to print the recipt for the customer using a report. I dont store the total price but i have created a query to calcualte that. The problem is i dont know how to get it to do the report for the sale that i want. For example just made a sale on the transaction form and the customer want a recipt i want to be able to do it from there any ideas?

 

[pbaldy]

I'm not sure I'm understanding, but if you're asking how to print a specific record, I'd use this technique with OpenReport:

http://www.baldyweb.com/wherecondition.htm

 

[tom1252]

Basiccly i have two tables one which records time and date and servered the customer and the other shows each item in that sale. I want to be able to prin the out a recpit for that using a report

 

[themurph2000]

My system is a sales system. When some one buys products i want to be able to print the recipt for the customer using a report. I dont store the total price but i have created a query to calcualte that. The problem is i dont know how to get it to do the report for the sale that i want. For example just made a sale on the transaction form and the customer want a recipt i want to be able to do it from there any ideas?

Once the data is entered into the form, you can add a button to the form that opens up a report. The query behind that report should use the receipt number on your current form as the criteria for searching. The criteria box would read something to the effect of:

[Forms]![MyTransactionForm]![TextBoxWhereReceiptNumberIs]