I need to find an invoice number sometimes and decided to create this query:
----------------------------------------------------------------------------
SELECT Orders.OrderID, Orders.InvVWD, Orders.InvNorthern, Orders.InvPremium,
Orders.InvYork, Orders.InvVinylbilt, Orders ...

My query is pulling 2 fields, Item and code.  For each item I can have
multiple codes, i.e. C1, C2, C3 and so on.  When running a query for Item A I
get back 4 lines becuase I have 4 different codes (C1, C2, C3, & C4).  If I
write my query using first and last I can return 1 line ...

I have a query that has a seperate form used for entering data.  I am having
problems adding calculated controls and I will try to explain what I have set
up the best I can.  
First, I have a list box that is the total number of hours for a maintenance

I've got a database with a many-to-many relationship between two tables
(Employees and Customers). By this I mean I have a table that sits in-between
both tables and records the relationship. I want to create a query which
lists all the Customers with a calculated field that ...

I have a query on a table with the criteria on a date field set up as:
[Forms]![EntryForm]![StartDate]-7
In other words, I want the criteria to be seven days previous to whatever
the start date is in the entry form. I'm getting a "This expression is typed

I haven't worked with Access in a decade, so I'm rusty.
I have a table of wage increases that reflect a compensation polocy of
raises; table titled Raises.
An employee's raise is a function of (a) wage type and (b) step level

Hi there! Using A02 on XP, not a programmer but love learning in here.
I need to run a query that will show me all the records from a table called
tInfo where [SL]=2 and [ICSDateSent] Is Not Null.  I have a table,
tRPSAdminBills, that contains annual records that include a

I'm attempting to exclude all records that have a value in a particular field
if any part of the text matches values in a query.  Here is my attempt but
it's still bringing up all records:
SELECT item,  udref  FROM qrySelectedRepReturnsInXDays INNER JOIN

I am trying to create a query that will compare data within 2 tables. The
query will specifically look at 3 columns in these 2 tables. If the
information in these 3 columns is the same in each table, then the query will
NOT pull the rest of the info.

I'm having a real problem getting a query (or set of queries to work) and no
matter what I try I fail :-( I wonder if someone could help me with the
approach?
I need data from 4 tables and I'm aware I need to create a series of queries

I want my query to return a message based on the input received.  How do I
make this statement return a message to the same column
( IIf(IsNull(projects.date_filled),'Not filled',' ') ) AS Message
I want to be able to return a different message if the projects.date_ filled

I'm hoping that someone will be able to help me with a problem I'm having
with queries.
At the moment I have 3 tables as follows:
Table 1:

Hi,
Can someone get me started in the right direction.  I have 2 tables, one is
production the other is incoming_inventory.  In production we have a fields
for ProductionDate  PlantNo  ShiftNO  IngName1  IngName2  IngName3 IngName4  

My query does not work correctly but I really can't see the problem. What I
want to do is to count the number of times T_Details_EnFormation.NIP is
either in field EnFormation1 OR in field EnFormation2. Sometimes I get
expected result for maybe 1/4 of the lines. The remaining is ...

I have a field with Lastname, Firstname (ex: "Smith, John")
I want to extract the Last name and first initial (ex: "Smith, J).
What's the code?
Thanks in advance.