I have a field "ITEM" that contains both an Item Code and Item Description
separated by a space.  I need to parse out the Item Code from the ITEM field.
The Item Code is of varying lengths so I need to find the position of the
first occurrence of the space character so that I ...

SUM EXPRESSION IN QUERY PRODUCES THIS EXTREMELY SMALL FRACTION WHEN IT SHOULD
= ZERO.  ANYONE SEEN THIS BEFORE???

I am in the midst of modifying an existing Access database used by a
single office into one which is used by and stores data for multiple
offices. Data for all offices is stored in the same database. When the
database is initially opened a global variable is set to the value of

I have a long list of partial numbers all of which start with "W" and then
have 4 numbers after it with the 4 numbers being any combination of numbers.  
The actual part number starts with any number of characters, but the majority
have mostly 3-5 leading numbers.  After the ...

I already can calculate the weekdays; but, eliminating holidays has me stumped

How can I set up an elapsed time module to show results as only minutes- not
like 1 hour, 2 minutes. Instead just as '62'?

Using Like "A*" will find all agents names starting with "A"....Is it
possible to use "Like" with brackets to have the user decide what letter they
want to start with?  For instance is there a way for me to run a query and
get all instances that Alex and Andy worked a service ...

I have the following line in a query:
Type: IIf([SelectedQuantity]=0 And [CorrectQuantity]>0,"SKIP","NO SKIP")
[SelectedQuantity] and [CorrectQuantity] are numeric fields but I want the
Type field to return text.  I have done this in other queries but for some

How to not select certain multiple criteria.  I want to not select certain
contractor codes.  I tried the not like function but can't get it to work on
not selecting multiple contractors.  I tried to setup the formula like this:  
Not like "Vic" or not like "Pioneer" or not like ...

If I simply enter the values into the criteria on the QBE grid it would be
"1C" Or "2U" Or "3M", this works as intended.
However I need to be able to reproduce this criteria via a form. I am using
a list box to provide the criteria and it works with individual criteria

This statement works fine if not nested or used in a union query:
select 0 as [id], "select record" as [text].
Used this way:
select 0 as [id], "select record" as [text]

I have a field that for EVERY record has a unique  text/number
followed by a common suffix so 2 records would look like this:
sfxhdbyrneo1234
hey7dtdbfkri503mf812n1234

I am attempting to design a query that will look up records from a single
category or a preset group of categories.  I have created a form where the
user may select a category from a list box OR they may select another control
that is SUPPOSED to indicate a preset group of ...

I have two different mailing lists, one from company A and one from
company B. To prevent company A & B from sending duplicate
invitations, I would like to combine the two lists in Access using e-
mail addresses as a unique identifier. How do I query to find and

I have a table with such data:
id      name
1       Mario
1       Mario Krsnic