In a field there are entries starting with letters and ending with numbers.
For example:
ABC12345
AA2564

Hi. I have some external applications running over my access databases.
Sometimes some queries has no registers to show up.
In this cases I would like to insert a logical record in order that the
recordser count would be one.

I can't seem to get the replace function to work correctly in Access. I'm
trying to convert "Mr" to "Male" for a gender specific project. I know that
the string I'm using sees the text as "Mr" as I have used a selection query
to test it. But I'm unable to get a result using

Hi there,
I'm trying to create a rather simple query and though it seems to run (no
errors, just an endless wait - 6 hrs so far), it's taking forever and have
not seen a completed result yet.

I am doing a db to keep track of my classmates.  I have written two queries,
one for men and one for women.  What I am trying to do is get one query that
sorts alphabetically by the original last name.  The men's have not changed
but the womens have for the most part so I put in ...

I have four tables that I need to query to use as the control source for a
combo box. The combo box is cbLocations and the four tables and fields are:
[tblCustomerDCs].[txtCustomerDCID].[txtCustomerName]
[tblCustomerIDs].[txtCustomerID].[txtCustomerName]

I have a table that counts a set of neat indications to which are
associated two values.
In a calculation that I must achieve, I must have n and n-1.
Either to be more precise :

I have a update query that uses the DCount function to rank the scores for an
athletic event.  It parses one table (ENTRIES) for the scores, Event ID, and
AgeGroup which it uses to determine the scope of the ranking process.  It has
worked for years but now, due to changes in the ...

I am importing an Excel spreadsheet into Access.  There are several columns
where a carriage return has been used to separate the data in the field.  I
would like to use the InStr command to find the posistion of the newline
character--which appears as a small square when I'm ...

Access 2003.  I have this expression in my query which is used for a report.
If the DOB field is blank, I would like to insert the word Need DOB.  How
can I do this using my query grid?
PtNameRmAdmitNum: [PtLocRmNum] & "  " & [BedNumber] & "     " & [PtLName] &

@ All, I do not know, how to get my query done. Here is the situation:
I have a table with the following data:
Table:
JobNo          as String

I have setup my access database like an excel sheet. I realize now Access
likes everything in 1 column rather than in rows. I can't rewrite the whole
program so I need help finding the 4 highest values.
Dance Students are judged in 5 disciplines.  we give a 4 class high score

Hello.  I am trying to run a query that will post information to a
table when the database opens.  I want it to post the balance from a
query with today's date.
I want to know if there is a way to post the informtion only if it is

I have 9 fast food locations in my sales table. There is a field for net
sales, month and one for year. I would like to compare January 2006 (etc)
sales to January 2007 sales in a report. Is there a way to build a query that
would compare month by month? The formula is a simple ...

I have a database that is designed to update a list of credit union members
from a master list so that vehicle insurance coverage can be tracked.  I have
been able to run an unmatched query to achieve a list of old members who have
either paid off their vehicles or moved their ...