GoToRecord

[Guest]

I want to go to the next null record for First and Last name. In a macro I
have GoToRecord, Record-GoTo, Offset-Where I am confussed. I tried =[First
and Last Name] is null.

Thanks

 

[Allen Browne]

The expression would be:
([First Name] Is Null) AND ([Last Name] Is Null)

However, I don't think you can use this with GoToRecord, as the offset
expects a numeric value, not a criteria string. Try FindRecord instead.

 

[Guest]

My field is [First and Last Name]
so my expression is =([First and Last Name] Is Null)
and in the following boxes I have Match-Whold Field
Match Case-Yes
Search-All
Search as formatted-Yes
Only Current Field-Yes
Find First-Yes

Some reason the combination I have will not work the error message tells me
to change the search as formatted to yes. so I did that. But I still get
the error.
Any suggestions?

The expression would be:
([First Name] Is Null) AND ([Last Name] Is Null)

However, I don't think you can use this with GoToRecord, as the offset
expects a numeric value, not a criteria string. Try FindRecord instead.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I want to go to the next null record for First and Last name. In a macro I
have GoToRecord, Record-GoTo, Offset-Where I am confussed. I tried
=[First
and Last Name] is null.

Thanks

 

[Allen Browne]

You are trying to enter that in to the Find dialog?

That won't work. Try the Filter By Form button on the toolbar, and enter
Is Null
beside both fields.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

My field is [First and Last Name]
so my expression is =([First and Last Name] Is Null)
and in the following boxes I have Match-Whold Field
Match Case-Yes
Search-All
Search as formatted-Yes
Only Current Field-Yes
Find First-Yes

Some reason the combination I have will not work the error message tells
me
to change the search as formatted to yes. so I did that. But I still get
the error.
Any suggestions?

The expression would be:
([First Name] Is Null) AND ([Last Name] Is Null)

However, I don't think you can use this with GoToRecord, as the offset
expects a numeric value, not a criteria string. Try FindRecord instead.

I want to go to the next null record for First and Last name. In a
macro I
have GoToRecord, Record-GoTo, Offset-Where I am confussed. I tried
=[First
and Last Name] is null.

Thanks

 

[Guest]

okay none of that is working. All I want is for the focus to go to the next
null record. If I cant do that then how about this. In my query I only want
the null records for [First and Last name] in criteria I put is null.
however it did not work. I do have in another critera for TA Number between
1 and 350 and between 400-500. This wouldn't stop the is null from working
will it?
So if I could only get the records to show that have no name then that would
work even better.
Thanks

You are trying to enter that in to the Find dialog?

That won't work. Try the Filter By Form button on the toolbar, and enter
Is Null
beside both fields.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

My field is [First and Last Name]
so my expression is =([First and Last Name] Is Null)
and in the following boxes I have Match-Whold Field
Match Case-Yes
Search-All
Search as formatted-Yes
Only Current Field-Yes
Find First-Yes

Some reason the combination I have will not work the error message tells
me
to change the search as formatted to yes. so I did that. But I still get
the error.
Any suggestions?

The expression would be:
([First Name] Is Null) AND ([Last Name] Is Null)

However, I don't think you can use this with GoToRecord, as the offset
expects a numeric value, not a criteria string. Try FindRecord instead.

I want to go to the next null record for First and Last name. In a
macro I
have GoToRecord, Record-GoTo, Offset-Where I am confussed. I tried
=[First
and Last Name] is null.

Thanks

 

[Allen Browne]

Do you actually have a field named:
[First and Last name]

If not, you will need to place:
Is Null
under the both fields in the criteria of your query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

okay none of that is working. All I want is for the focus to go to the
next
null record. If I cant do that then how about this. In my query I only
want
the null records for [First and Last name] in criteria I put is null.
however it did not work. I do have in another critera for TA Number
between
1 and 350 and between 400-500. This wouldn't stop the is null from
working
will it?
So if I could only get the records to show that have no name then that
would
work even better.
Thanks

You are trying to enter that in to the Find dialog?

That won't work. Try the Filter By Form button on the toolbar, and enter
Is Null
beside both fields.

My field is [First and Last Name]
so my expression is =([First and Last Name] Is Null)
and in the following boxes I have Match-Whold Field
Match Case-Yes
Search-All
Search as formatted-Yes
Only Current Field-Yes
Find First-Yes

Some reason the combination I have will not work the error message
tells
me
to change the search as formatted to yes. so I did that. But I still
get
the error.
Any suggestions?

:

The expression would be:
([First Name] Is Null) AND ([Last Name] Is Null)

However, I don't think you can use this with GoToRecord, as the offset
expects a numeric value, not a criteria string. Try FindRecord
instead.

I want to go to the next null record for First and Last name. In a
macro I
have GoToRecord, Record-GoTo, Offset-Where I am confussed. I tried
=[First
and Last Name] is null.

Thanks

 

[Guest]

yes I have a field called First and Last name. Well it works now. I tried
and tried that over again. but now it works great. Thanks for your help.

Do you actually have a field named:
[First and Last name]

If not, you will need to place:
Is Null
under the both fields in the criteria of your query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

okay none of that is working. All I want is for the focus to go to the
next
null record. If I cant do that then how about this. In my query I only
want
the null records for [First and Last name] in criteria I put is null.
however it did not work. I do have in another critera for TA Number
between
1 and 350 and between 400-500. This wouldn't stop the is null from
working
will it?
So if I could only get the records to show that have no name then that
would
work even better.
Thanks

You are trying to enter that in to the Find dialog?

That won't work. Try the Filter By Form button on the toolbar, and enter
Is Null
beside both fields.

My field is [First and Last Name]
so my expression is =([First and Last Name] Is Null)
and in the following boxes I have Match-Whold Field
Match Case-Yes
Search-All
Search as formatted-Yes
Only Current Field-Yes
Find First-Yes

Some reason the combination I have will not work the error message
tells
me
to change the search as formatted to yes. so I did that. But I still
get
the error.
Any suggestions?

:

The expression would be:
([First Name] Is Null) AND ([Last Name] Is Null)

However, I don't think you can use this with GoToRecord, as the offset
expects a numeric value, not a criteria string. Try FindRecord
instead.

I want to go to the next null record for First and Last name. In a
macro I
have GoToRecord, Record-GoTo, Offset-Where I am confussed. I tried
=[First
and Last Name] is null.

Thanks