I ahev a text field in my table that display quantities like this, (5 EA, 16
PAC, 1,000 EA).  There is always a space after the number.  How do I strip
everything to the right of the space (i.e. EA, PAC) so I can then convert
this field to a number?

I have a query that has the following fields; AtlasSection, AtlasPage,
PersonName, AddressInfo.  The result of the report should look like:
AtlasSection    AtlasPage   PersonName    AddressInfo
1                     1                 JohnDoe          Anywhere

How/where would I kick off the GetBusinessDay function in the following query
expression.  I want to calculate 120 days ahead and, if that date falls on a
weekend or holiday, get the next business day.:
Express1: IIf([Ident]=4 And

I wrote this query
Base Pay: IIf([Emp Base Pay Rate] Is Null Or [Total Amount Docked] Is Null
Or [Total Pay Adjustment] Is Null,0,[Emp Base Pay Rate]+[Total Amount
Docked]+[Total Pay Adjustment])

I need to query for dates from current day to 7 days out. What I have here
will count weekends in the query. I need to improve this SQL so it does not
take weekend days into consideration:
Between Date()-"1" And Date()+"8"

SELECT tblFullSelectInfo.Name, tblFullSelectInfo.DateSelected,
tblFullSelectInfo.Rank, tblFullSelectInfo.SSN, tblFullSelectInfo.Notes,
tblFullSelectInfo.WorkCenter, tblFullSelectInfo.WorkPhone,
tblFullSelectInfo.PendingPool, tblFullSelectInfo.DueDate,

Ok i have an infopath form where users enter a number and it is stored into
an access database...
Problem is, Infopath throws a fit if you format those fields as numbers in
access.

I have the following SQL but Sales has duplicate values that don't show up in
the result of the query what am I doing wrong
SELECT CashReceiptAmount AS Cash, 0 AS Sales
FROM tblCashReceipts

Access 2003
I'm mystified by a series of basic queries in a database I originally
created in Access 2000. They have simple names such as "qryCountByYr" but
when I try to run them, I get that invalid query name error message.There's

I am trying to compare values and calculate the difference between them based
on the compairason.  Here is the code I have so far but I always get a syntax
error.
IF [U_Start date] <= [C_Start date] AND [U_End date] <= [C_End date] THEN

I have 2 tables.  (Table1 and Table2).  I want to append on piece of data
(Data1) from Table1 to Table2.  This append query is ran everytime I open a
form.  I only want records that have not been added to Table2 yet.  So only
new records.

I have an update query that is calculating a field based on other criteria in
the table. The calculation works ok, except it round the result. in this kind
of calculation there is a big differnce between 4.4 and just 4. I tried Val
and CCur and CDbl as well as formatting the ...

We like to replace some of our item code.
i.e. sales history database, item database...
We have a a replacemene code database has 2 fields.
old item code and new item code.

I created a macro that runs  OutpuTo a txt file.
Can I rename the file with this naming convention:  "mmddyy (now)" & "query
name".txt  = 040808Sales.txt
Thank you.

I need a query to provide results of people based on a date range entered on
a form.  The trick is the date they enter on a form needs to get the people
using their STARTDATE field.  Meaning, if the user enters on the form
1/1/2008 to 4/1/2008, people with a STARTDATE between ...