🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #404

Re: Last Invoice Number

#404
From: Javier Moncada
Date: Sat, 21 Feb 1998 00:00
27 lines
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-mail
References: <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