How do I count the number of ROW?

  • Thread starter Thread starter Noah
  • Start date Start date
N

Noah

I am trying to run a query and then, in another query,
look at how many rows where returned from the first query.

Here is what I am trying to do: I have a query that runs.
Then I have another query, based on the first one, that I
want to examine how many rows where returned. If the
first query didn't return anything then I want to display
a message or put something in the missing fields. If it
did find something then I will display those fields.

I tried using COUNT but can't get it to work. I don't
know where to put the code at or how to word it.

I you have any ideas about how to do this please let me
know.
 
Noah said:
I am trying to run a query and then, in another query,
look at how many rows where returned from the first query.

Here is what I am trying to do: I have a query that runs.
Then I have another query, based on the first one, that I
want to examine how many rows where returned. If the
first query didn't return anything then I want to display
a message or put something in the missing fields. If it
did find something then I will display those fields.

I tried using COUNT but can't get it to work. I don't
know where to put the code at or how to word it.

I you have any ideas about how to do this please let me
know.
Click to expand...
 
Noah said:
I am trying to run a query and then, in another query,
look at how many rows where returned from the first query.

Here is what I am trying to do: I have a query that runs.
Then I have another query, based on the first one, that I
want to examine how many rows where returned. If the
first query didn't return anything then I want to display
a message or put something in the missing fields. If it
did find something then I will display those fields.

I tried using COUNT but can't get it to work. I don't
know where to put the code at or how to word it.

I you have any ideas about how to do this please let me
know.
Click to expand...
Look up RecordCount in VB help.
There are examples.
In the past many have felt a .movelast should be done before executing the
..recordcount
 
Back
Top