The right hand data of Field1 is a numeric number consisting of either 3, 4
or 5 characters. I need to update field3 with this information
Is there an easy way to do this please
thanks

I have a query that pulls name/address information.  There is an adrcode
field that shows if the address is work or home and there is a company field.
I only want to pull the company field if the adrcode field = work.  How can
I do this?

I'm racking my brain and I cant for the life of me figure this out.
It's probably simple for you SQL Gurus, so could you please take a look
and help?
I have a Team Schedule database is Access with 2 tables.

Using CInt(cbPartNbr.Column(3)), I get an overflow. cbPartNbr.Column(3) is
not the bound column, and it's presented for some reason as a string. It's a
number, and often over 32,767. I don't know the limit for CInt(), but I can't
seem to find any other function that might convert ...

After making changes to records in an MS Access table (not programatically,
rather graphically using the MS Access GUI), I want to "commit" the changes.  
I'm successfully reading data in the table I made changes to using Perl w/
Win32::ODBC.  But the only way I can see the ...

How do I insert a comma between the mames in the following query.
WholeName: [LastName] & " " & [FirstName]
Doesn't work 1:- WholeName: [LastName], & " " & [FirstName].....??
Doesn't work 2:- WholeName: [LastName]","[FirstName]...............????

I've created multiple queries based on a "raw data query" where i have a
beginning and ending date parameter.  How can I make a pick list to choose
specific beginning and ending dates?  I'm trying to control the selection of
beginning and ending dates because all of our reports ...

I have two tables of pricing data that are by item for Jan through Dec;
one of current prices with the second of future prices.  I am trying to use
an update query to update the monthly buckets in the base table with the
prices from the future table; however I only want to update ...

I have an Access Database Table with 2 fields:
1. ID
2. Name
I want to Select all the records which [Name] is contained in a

I have an expression that I want to keep at 4 decimals:
ID Cube: [IDLength]*[IDWidth]*[IDHeight]/1728
How do I do this?
Thanks!!!

I have a database with unique serial numbers.  Each serial number has
component part numbers.  The part numbers can be the same for some of the
serial numbers, but not all.  What I need to do is count all the duplicate
part numbers for each component?  Not sure if this is clear, ...

How do you NOT display a field when the record is not selected?
School Name:   AAA BBB CCC DDD or ALL Schools
when i select AAA, the result would be only:
Student:   GPA       School Name

I have a table of 25 employees (tblEmployees), each with an EmployeeID field
(primary key) and first name, last name, etc. fields.
Another table (tblPayrollRecords) holds monthly data on each employee,
linked on the EmployeeID field in a one-to-many relationship.  One of the

I am trying to total up the number of events in a given week over the
current year using the following formula in my query.
format([date], "yyyy,ww")
however this formula returns weeks 1-9 in a 1 digit format, therefore my

Hi,  i need to update field 2 with the contents of field 1 minus the first 6
charaters, and i cant work out the syntax.  Could someone help me please
thanks
A