I have a field named CityStateZip that shows the City Name, a comma, State
and Zip. i.e. Houston, TX 77478.
I used SQL as below:
Trim(Mid([04 Name address].[CityStateZip],1,InStr([04 Name

I realized I was posting on the wrong message board, so I thought I would
post it here. Here's my question:
Now I have another question. When select from two different combo boxes, I
want it to only be narrowed down to those two selected. For example if I

tblCustomers: CustKey(pk); CustNo; CustName
tblCharges: ChrgKey(pk); CustKey(fk); ChrgDate; ChrgAmount
tblPayments: PmtKey(pk); CustKey(fk); PmtDate; PmtAmount
I want to display  CustNo, CustName, [Chrgs-Pmts(00 to 30 Days Old)],

I currently have one table in a database that holds all information for each
project.  It is currently set up so the the user enters the job name and is
given a job number via autonumber.
It is quite large and I would like to break the 1 table into several - for

COMPDATA IS FULL OF INFORMATION ON UPGRADING MY PC FROM WINDOW 2000 TO
WINDOWS XP ALL THIS DATED WAS ON IT BEFORE I RECEIVED IT SO I AM THINKING
THIS IS NOT NEW  PC BUT UPGRADED THE COMPANY I PURCHASED IT OF HAVE E-MAILED
ME AND SAID THAT I SHOULD LEAVE COMPDATA ALONE BECAUSE IT ...

I'm looking for a search pattern to match call numbers in a library
catalog database. I want to find all call numbers that begin with 8 and
end with 3. The call numbers are anywhere from 3-7 digits,with or
without a decimal point in them. The call number field is designated as

Ive produced some reports in Access. Id like to rank the results.. IE. 1, 2,
3 etc through 10.
Can anyone tell me how to add a ranking?
Thanks,

I have created a query by form (QBF) that allows the user to select the
parameters for a query from drop down lists. I know how to allow them to
search for the exact value selected from the box, and i was also able to
allow them to search for the value from the box with a ...

I've either had too much Mountain Dew or not enough, because I cannot get
what should be a simple query to return desired results.
My only criteria is trying to find records with the current date using
Date(). The field is formatted as General Date because it stores date and

Hi there - hope somebody can help?
I've created a query to base a report on and I want the query to limit the
lines returned based on what is selected in several unbound combo boxes in a
form I created.

I need to set up a table of (Distinct) countries that exist in a master file,
for use in a list box, and add an extra "(select Country)" record up front,
so that it is the default visible choice in the list box.
I thought of creating a replica of the master file ...

Below is a table of dates used in the company to determine holidays and
workdays:
NGCID    CalendarDay    Weekday    NonBusinessDay
2727    6/19/2005    1    Sunday

I am trying to use an update query where use a form to select a record from a
table, and then by using a button, it runs an update query to update a memo
field in another table -- the fields CustomerRequestDescription and
CommonItemLongP are both memo fields.  When I run the ...

I have asked this in reports, but now it is more of a query problem (I
think)
I have a query that pulls all the orders and order details. In each row I
have a orderdetailID and a product. I need to get the total weight of

In one of our queries we have a parameter set to enter a project number, but
we would also like to have the date sorted as well. We put a decsending sort
on the date column and now the project number parameter box pops up twice.
How can we get the box to only pop up once?