DFirst

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I'm trying to use DFirst function to return the first
value of a field, Expr1: DFirst
("[AB]","avicc_PROP_MOD","[Vehicle_Code] =""&[Veh_Code]
&""")

For each record, I should get one value only. But I get
more records than there are. And they are also all empty.
Why?

Alex
 
Alex,

Where are you doing this?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
I'm using it in a query.

Alex
-----Original Message-----
Alex,

Where are you doing this?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

I'm trying to use DFirst function to return the first
value of a field, Expr1: DFirst
("[AB]","avicc_PROP_MOD","[Vehicle_Code] =""&[Veh_Code]
&""")

For each record, I should get one value only. But I get
more records than there are. And they are also all empty.
Why?

Alex
Click to expand...


.
Click to expand...
 
I think I know why now. There are duplicate records in
my "avicc_PROP_MOD" table. Is there a way to quickly
delete the duplicate records?

Thanks.

Alex

-----Original Message-----
I'm using it in a query.

Alex
-----Original Message-----
Alex,

Where are you doing this?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

I'm trying to use DFirst function to return the first
value of a field, Expr1: DFirst
("[AB]","avicc_PROP_MOD","[Vehicle_Code] =""&[Veh_Code]
&""")

For each record, I should get one value only. But I get
more records than there are. And they are also all empty.
Why?

Alex
Click to expand...


.
Click to expand...
.
Click to expand...
 
Ok, I fixed the duplicated records. But my query returns
empty values. something is not right with my expression, I
think, especially those confusing quotation marks.

Expr1: DFirst("[AB]","avicc_PROP_MOD","[Vehicle_Code] =""&
[Veh_Code]&""")

Thanks for any help.

Alex

-----Original Message-----
I think I know why now. There are duplicate records in
my "avicc_PROP_MOD" table. Is there a way to quickly
delete the duplicate records?

Thanks.

Alex

-----Original Message-----
I'm using it in a query.

Alex
-----Original Message-----
Alex,

Where are you doing this?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

I'm trying to use DFirst function to return the first
value of a field, Expr1: DFirst
("[AB]","avicc_PROP_MOD","[Vehicle_Code] =""& [Veh_Code]
&""")

For each record, I should get one value only. But I get
more records than there are. And they are also all empty.
Why?

Alex


.
Click to expand...
.
Click to expand...
.
Click to expand...
 
ok, got it.

it should be Expr1: DFirst
("[AB]","avicc_PROP_MOD","[Vehicle_Code] =""" & [Veh_Code]
& """")

Alex
-----Original Message-----
I think I know why now. There are duplicate records in
my "avicc_PROP_MOD" table. Is there a way to quickly
delete the duplicate records?

Thanks.

Alex

-----Original Message-----
I'm using it in a query.

Alex
-----Original Message-----
Alex,

Where are you doing this?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

I'm trying to use DFirst function to return the first
value of a field, Expr1: DFirst
("[AB]","avicc_PROP_MOD","[Vehicle_Code] =""& [Veh_Code]
&""")

For each record, I should get one value only. But I get
more records than there are. And they are also all empty.
Why?

Alex


.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top