Article View: comp.databases.ms-access
Article #404Re: Last Invoice Number
From: Javier Moncada
Date: Sat, 21 Feb 1998 00:00
Date: Sat, 21 Feb 1998 00:00
27 lines
1951 bytes
1951 bytes
Claudio V. escribi� en mensaje <6cknt8$7o1$1@duke.telepac.pt>... >Hello, i�m Claudio and i have a problem with Access that make me crazy. >Let�s suppose the following : > >Database �A� =main program with invoices numbers and the last one it�s >Nr. 25,i created a safe copy database called �B� in which i copy all the >transactions from database �A�,after that i zap all the transactions in �A� >database to save some space. >Now i want to copy the last invoice number from �B� database to �A� database >so i can restart my transactions with the right consequentely >invoice number which will be Nr.26. >How can i do this ????? >If anybody could help me i would really be an happy man........ >Thank you for your time >Claudio > Hola Claudio, realmente tu problema se entiende dif�cilmente. �Para salvar espacio eliminas la tabla Facturas y la copias en otra Base de Datos?. Tal vez sencillamente debieras sacar una copia de seguridad de la BD original. Si por lo que sea has de hacerlo as� todo lo que tienes que hacer es adjuntar (Vincular) la tabla Facturas de la Base de Datos "B" y buscar el valor m�s alto de factura, para lo que puedes emplear una consulta con el predicado TOP o la Funci�n DMax. Si necesitas m�s informaci�n postea de nuevo. Saludos Jom. Hope you finally be a happy man ...
Technical Details
Message-ID:
<6cncpr$6tn$3@diana.bcn.ibernet.es>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6cknt8$7o1$1@duke.telepac.pt>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 111a5a,a883f7396feb79bf X-Google-Attributes: gid111a5a,public X-Google-Thread: ff0ac,a883f7396feb79bf X-Google-Attributes: gidff0ac,public From: "Javier Moncada" <jmoncada@infomail.lacaixa.es> Subject: Re: Last Invoice Number Date: 1998/02/21 Message-ID: <6cncpr$6tn$3@diana.bcn.ibernet.es> X-Deja-AN: 327336962 References: <6cknt8$7o1$1@duke.telepac.pt> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: Unisource Espana NEWS SERVER Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access