a (to) simple format question

hello,

it concerns the following question:

i would like to format negative numbers(money format) as red and positivs as black(without sorting and in the same column).

something like:

IIF(Fields < 0 , red, black)

thx

You've pretty much got the answer.

Set the BackgroundColor property of a textbox to the follofing expression

=Iif(Fileds!your_filed.Value < 0, "Red", "Black")

7.0 backup format

is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
sound too naive.
yes if you mean the extension for full backups
|||The extension of a file name (like .bak) doesn't say anything about the contents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might enforce a special
extension. SQL Server doesn't. There is a convention, however, to name database backup using "bak"
as extension.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegr oups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>

7.0 backup format

is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
sound too naive.yes if you mean the extension for full backups|||The extension of a file name (like .bak) doesn't say anything about the contents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might enforce a special
extension. SQL Server doesn't. There is a convention, however, to name database backup using "bak"
as extension.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegroups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>

7.0 backup format

is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
sound too naive.yes if you mean the extension for full backups|||The extension of a file name (like .bak) doesn't say anything about the cont
ents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might
enforce a special
extension. SQL Server doesn't. There is a convention, however, to name datab
ase backup using "bak"
as extension.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegroups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>

7.0 and 2000 .BAK incompatibility?

i just got a disk w/ a .bak file on it. when i tried to restore it on
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthur
Arthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegr oups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>
|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.
|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegr oups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
|||Are you certain this is indeed a SQL Server backup file? It could just have been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descriptive error message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegr oups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>

7.0 and 2000 .BAK incompatibility?

i just got a disk w/ a .bak file on it. when i tried to restore it on
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthurArthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegroups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>|||Are you certain this is indeed a SQL Server backup file? It could just have
been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descri
ptive error message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>

7.0 and 2000 .BAK incompatibility?

i just got a disk w/ a .bak file on it. when i tried to restore it on
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthurArthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegroups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>|||Are you certain this is indeed a SQL Server backup file? It could just have been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descriptive error message.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>