When I run my query, I get nothing.  I know I should at least be getting one
record, as there is currently only one record that contains this information.

I have a tblCandidates.  Calls are made to candidates.  The date the call is
made is stored.  The result of the call is stored, i.e. "message" left.  The
Result of the call is stored, i.e. "CO".  I would like to cfreate a report
that will look like this:

I have a form with the field "Control_Number". I want to store the value
contained in that field as a variable for use as a criteria in a select query.
How do I do that? BTW, I'm not a VB programmer yet, so all my actions are
contained in Macros.

They now show as having been sent on '9/29/2005 5:16 PM'. I'm using Outlook
Express as my news reader.
Is there a way to either get rid of them or reset the date? They are very
irritating.

I would like some help doing this. I have created a field that would hold
these values, called PLANCOUNT. I have 12 different check box fields that I
need to count and update PLANCOUNT with. Would an update statement similar to
this do the job:

I don't know what happened, but it's happened before. Has anyone seen this?
When I try to edit the contents of a query field, wherever I put the cursor,
the text from the end of the field to the placement of the cursor is
highlighted. I can't just put the cursor in and delete one ...

Hi with you all,
I can't obtain what I want with my queries.
I've got a table with a lot of fields witch I only want to test Not null case.
Sample of records

I am trying to update 2 fields in a database that match a certain
criteria. The SQL I am using is:
UPDATE tblProducts SET Version = "TEST" And Revision="T1,T2,T3"
WHERE (ID=119 And SheetNumber=0 And Product="H2600");

I am trying to write a query using >#8/1/2005#, however, this expression does
not produce the results I was hoping for.  I am trying to pull information
from my table for dates greater than August 1, 2005.  Am I using the wrong
expression, I would think that the expression above ...

If I use this line:
Expr26: IIF([CONSUMP_MDDTL_HIST]![OS_PLATFORM_TYPE]=[Service Unit Conversion
table]![SERVICE LEVEL],[Service Unit Conversion table]![SERVICE UNITS])
I get two duplicate line in my out put. One with this expression with the

This has probably been asked quite a few times but I cannot find the
solution on Google so apologies for asking again.
I have two tables and I want to get a count of all the records in Table 2
but based on the records in Table 1.

The outer form is based on the 'Site' details table and the main form for all
input of data. Nested in the 'Site' details form is a form for identifying
each new 'Survey' conducted. 'Species' details are then nested within the
'Survey' details. When drawing information to create ...

I want to count how many orders a customer placed in a month, in the case of
a customer did place order in that month, I want it show me 0. Unfortunately,
my statement does not show me the customer without a order. Any idea? the
following is the statement:

Hello, I've got a query that is searching through the body of an email
message.  I have it getting the target text by using the mid function.  Is
there any way i can have it keep track of how many times a specific text is
retreived?  i.e.  the query outputs a username (john_doe) ...