Query

[Guest]

I have a query with many fields. But two inperticular I am working with.
[First Name] and [Cancelled]
Right now I have is null under [First Name] but if the field Cancelled has
the word cancelled ticket then I want that record to show. Can someone tell
me what I should right and under which field to put it?
Thanks.
Chey

 

[Guest]

Post the SQL of your query.
Open the query in design view, click on menu VIEW - SQL View. Highlight
all, copy, and paste in a post.

 

[Rick B]

On the same line in the query (this creates an AND operation) put =True
under the Cancelled field (I assume this is a Yes/No type field.)

This would return records where the name is null *and* the cancelled field
is checked.

 

[Mike Labosh]

I have a query with many fields. But two inperticular I am working with.

[First Name] and [Cancelled]
Right now I have is null under [First Name] but if the field Cancelled has
the word cancelled ticket then I want that record to show. Can someone
tell
me what I should right and under which field to put it?

Is this what you're looking for?

SELECT ...
FROM...
WHERE [First Name] IS NULL
AND Cancelled = 'cancelled ticket'

Alternately,

....
WHERE [First Name] IS NULL
AND Cancelled IS NOT NULL
--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

 

[Guest]

Chey:

Put the value of the Cancelled field for which you want to show rows even if
First Name is Null on the second criteria line (labelled on the left as or
under the Cancelled column in the query design grid.

Ken Sheridan
Stafford, England

 

[Guest]

This is what I have where do I place the code you gave me?

SELECT [TA Numbers].[First and Last Name], [TA Numbers].[TA Last 3], [TA
Numbers].[TA Number], [TA Numbers].Employee, [TA Numbers].Orgin, [TA
Numbers].Destination, [TA Numbers].[I/O Travel], [TA Numbers].Puropose, [TA
Numbers].[Date Leave], [TA Numbers].[Date Return], [TA Numbers].[Advanced
Y/N], [TA Numbers].[Date Finalized], [TA Numbers].[Trip Cancelled], [TA
Numbers].[Personal Check], [TA Numbers].[$0 TA Y/N], [TA Numbers].[Today's
Date], [TA Numbers].[Travel Complete], [TA Numbers].[Sent to finace], [TA
Numbers].[Travel Approved], [TA Numbers].[Date Approved], [TA
Numbers].[Travel Not Approved], [TA Numbers].[Date Not Approved], [TA
Numbers].[Trip Cancelled Date], [TA Numbers].[Travel Cancelled]
FROM [TA Numbers]
WHERE ((([TA Numbers].[First and Last Name]) Is Null) AND (([TA Numbers].[TA
Number]) Between "06CA060001" And "06CA060099" Or ([TA Numbers].[TA Number])
Between "06CA060300" And "06CA060399"))
ORDER BY [TA Numbers].[TA Number];

I have a query with many fields. But two inperticular I am working with.
[First Name] and [Cancelled]
Right now I have is null under [First Name] but if the field Cancelled has
the word cancelled ticket then I want that record to show. Can someone
tell
me what I should right and under which field to put it?

Is this what you're looking for?

SELECT ...
FROM...
WHERE [First Name] IS NULL
AND Cancelled = 'cancelled ticket'

Alternately,

....
WHERE [First Name] IS NULL
AND Cancelled IS NOT NULL
--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

 

[Guest]

What is your primary Key field in your table containing the (First Name)

Is [First Name] and [cancelled] in the same table?

Please provide information on the "many fields" and their relationships

 

[Guest]

SELECT [TA Numbers].[First and Last Name], [TA Numbers].[TA Last 3], [TA
Numbers].[TA Number], [TA Numbers].Employee, [TA Numbers].Orgin, [TA
Numbers].Destination, [TA Numbers].[I/O Travel], [TA Numbers].Puropose, [TA
Numbers].[Date Leave], [TA Numbers].[Date Return], [TA Numbers].[Advanced
Y/N], [TA Numbers].[Date Finalized], [TA Numbers].[Trip Cancelled], [TA
Numbers].[Personal Check], [TA Numbers].[$0 TA Y/N], [TA Numbers].[Today's
Date], [TA Numbers].[Travel Complete], [TA Numbers].[Sent to finace], [TA
Numbers].[Travel Approved], [TA Numbers].[Date Approved], [TA
Numbers].[Travel Not Approved], [TA Numbers].[Date Not Approved], [TA
Numbers].[Trip Cancelled Date], [TA Numbers].[Travel Cancelled]
FROM [TA Numbers]
WHERE ((([TA Numbers].[First and Last Name]) Is Null) AND (([TA Numbers].[TA
Number]) Between "06CA060001" And "06CA060099" Or ([TA Numbers].[TA Number])
Between "06CA060300" And "06CA060399"))
ORDER BY [TA Numbers].[TA Number];

Thanks
Chey

Post the SQL of your query.
Open the query in design view, click on menu VIEW - SQL View. Highlight
all, copy, and paste in a post.

I have a query with many fields. But two inperticular I am working with.
[First Name] and [Cancelled]
Right now I have is null under [First Name] but if the field Cancelled has
the word cancelled ticket then I want that record to show. Can someone tell
me what I should right and under which field to put it?
Thanks.
Chey

 

[Guest]

It is not a check box. It is drop down with Cancelled or Ticket used.
If it says Cancelled and [First name] is null I want to show.
Thanks a bunch.
Chey

On the same line in the query (this creates an AND operation) put =True
under the Cancelled field (I assume this is a Yes/No type field.)

This would return records where the name is null *and* the cancelled field
is checked.


--
Rick B

I have a query with many fields. But two inperticular I am working with.
[First Name] and [Cancelled]
Right now I have is null under [First Name] but if the field Cancelled has
the word cancelled ticket then I want that record to show. Can someone
tell
me what I should right and under which field to put it?
Thanks.
Chey

 

[Guest]

Got it to work thanks

Chey:

Put the value of the Cancelled field for which you want to show rows even if
First Name is Null on the second criteria line (labelled on the left as or
under the Cancelled column in the query design grid.

Ken Sheridan
Stafford, England

I have a query with many fields. But two inperticular I am working with.
[First Name] and [Cancelled]
Right now I have is null under [First Name] but if the field Cancelled has
the word cancelled ticket then I want that record to show. Can someone tell
me what I should right and under which field to put it?
Thanks.
Chey

 

[Mike Labosh]

Right here:

WHERE ((([TA Numbers].[First and Last Name]) Is Null) AND (([TA Numbers].[TA
Number]) Between "06CA060001" And "06CA060099" Or ([TA Numbers].[TA Number])
Between "06CA060300" And "06CA060399"))

AND [First Name] IS NULL
AND Cancelled = 'cancelled ticket'

--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei