I have two tables that are being compared. If field_1 from TABLE B is the
same as field1 from TABLE A, then there QCTV1 field from TABLE A should have
a check else is should be left unchecked. How do I do this? Note: TABLE A has
many QCTV fields because many fields from TABLE B ...

ex:
I have a table:
idex  name codequestion       mark
1        A         MS_HR_RI1      45

Hi, I have a query where I want to retrieve only records from a Table where
one of th e Fields in that Table does not contain the two letters BR in upper
case. I am currently using the criteria Not Like "* BR" but it excludes both
the upper and lower cases as well. Can anyone ...

The query is:
Employees whose Bonus is at least 10% of their Salary.
Thanks
Myrna

I hope someone can help me.
I have a query that I want to execute using a date range in the criteria. It
works fine if I prompt the user to enter the dates into the query - by using
"Between [Enter 1st date] And [Enter 2nd Date]" in the criteria section.

For the first time I'm trying to base a query on a user selection via a
list box.  My simple test db has one table, two forms and two queries.
Tbl_1 contains four records, two fields:
1 abc

Hello, I need some help with a query...
I have two tables table1 and table2 they are linked by table1.Upas_i
---> table2.Upas_id.
In table2 there are only few Upas_id, while in table1 there are al

Hi
The query I need
All employees, except those with missing Birth dates.
Thanks

Is there a way to consolidate data for one particular item (record), without
converting into a Pivot Table? Example: If I have 60 units for the year 2005
and 50 units for the year 2006 and I wanted to have them combined into the
same product number (1111), the moment I run the ...

Hi
The query that I am having difficulties with.
Query. Employees whose first name and last names begin with the same letter
(e.g.

In short: I have two join query, qryJoinApproved and qry JoinPending. How can
I excluded rercords from showing in qryJoinApproved if the same record ID is
found in qryJoinPending.

I am trying to run a make table query from existing related tables that are
linked through a connection that updates their information daily.  I have
dragged all the fields i need into their respective slots.  When I tried to
switch to design view I was prohibited from doing so ...

I'm trying to build a query that gives me the first day of the current
month.  This is what I currently have:
When I run my query it returns 10/1/06 and I want 11/1/06
DateAdd("m",-1,Date()-Day(Date()))+1

How would I go about creating a Top 12 values query?
My data is as follows:
2101...1/1/2003...CVIP
2101...2/2/2003...RR

Hello, any help or suggestions anyone could offer me with this would be
greatly appreciated.
Right now, I have a query that matches on Date and Zip Code and sums at
Weight and Cube for those records that match.