ISTech Support Forum - Problems with displaying Serial N.o's in Access

Welcome, Guest. Please Login.

	05/03/24 at 07:14:47 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

Pages: 1

Problems with displaying Serial N.o's in Access (Read 900 times)

davson Browser I love YaBB 1G - SP1! Posts: 35	Problems with displaying Serial N.o's in Access 09/07/04 at 15:37:02 I am hoping to be able to use Access to allow users to enter a particular Invoice N.o and for the relevant Serial N.o's appear for all Items. Now I haven't programmed in about 3rys so I very rusty. I was just wondering if anyone had any hints on there been an easier way in Access to do this. Thanks.
Back to top	IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Problems with displaying Serial N.o's in Acces Reply #1 - 09/08/04 at 09:36:04 Shouldn't be too much programming involved. If you bring in the BKARINV, BKARINVL, BKARHINV, BKARHIVL, BKSOHSER tables and do your inner joins correctly, you should be able to get the info you want. You may have to create a couple of expressions in the queries, but that should be about it.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

davson Browser I love YaBB 1G - SP1! Posts: 35	Re: Problems with displaying Serial N.o's in Acces Reply #2 - 09/09/04 at 07:19:40 Thanks Lorne.
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues