I have two tables
table1:
========================
name                             sirname

I have a union query that list our clients in alphabetaical order along with
their case number.  How can I link it so that once I find the client I'm
looking for in the query all I have to do is click on the case number to open
the case file that contains that person's info.  Now ...

I need to create a query that: from a column BlockNo creates a
column:RowNo and a second Column:PosNo
There are 72 BlockNo ie. BlockNo 1 -> BlockNo 72
There are 8(1-8) different RowNo and 9(0-8) different PosNo.

Hi I am new to Access but have muddled my way through to create a
student tracking database.  This database stores core information
about pupils in the main table and individual subject data in subject
tables.  One of my subject tables stores scores for seperate modules

I'm a newbie trying to create the # of working days either in a query or via
a report between the date something was received & the date we finished it.  
Does something exist for this?
Thanks in advance for any assistance. (P.S. I know nothing about VBA)

I have a list of admissions that includes a start date and an end date. I am
trying to produce a list to show the number of members that are current.
I have tried searching for specific dates which works fine but it doesn't
show any dates between start data and end dates only ...

I've been trying to run a mail merge in Word from an Access query and I keep
losing records in doing so. I can see that they are all in the query results,
and I can even export them all to Excel (tried that as an alternative), but
for some reason they don't merge into Word.

I have an access db with 2 tables, one with members and their mailing
information (contact_infoTBL) and another with their order information
(member_yearTBL)  Since they can order membership by year, that table
only consists of 2007, 2006, etc. along with payment information.

I have been facing a strange problem in VBA
I have function in a module like this:
Public Function GetGroupCodes()
Dim rs As DAO.Recordset

I have two working queries that I would like to use to create one form.  I
get an error message that I have chosen fields from record sources which the
wizard can't connect.  You may have chosen fields from a table and from a
query based on that table.  If so, try choosing fields ...

In my database, I have checkboxes for 6 different industries.  I would
like to create a report that shows the total number of records where
the box is checked for each of the six industries.  To do this, I
figured I would first need to create a query.

Hi this is a repost actually.
I'm not sure if this can be done in a query by creating a function first.
Here's an example: I need to find NICKJM in the "HIER" field. If there is
none, then it would look for NICKJ, and if there is no value it would look

Using Access 2003 as a report generation tool front end to a SQL Server 2005
backend.  I have the latest MDAC, JET and or service packs.  My SQL Server
db is remote some 110 miles away and accessed over the internet through VPN
I have a query involving five 'linked tables' that ...

I have 2 queries and I am trying to get a list of unmatched MSEQ from the
qryYrMoSeq.
qryYrMoSeq is a listing of available seq#. In qryBoilerSerialNum is the a
list of seq# that are taken.

Hello .. I'm not sure where to post the following.  Originally I posted it
in the general access newsgroup but have had no reply .. apologies if this
is also the wrong newsgroup, if it is,  some re-direction would be most
welcome .. and the problem is: