is it possible to display 2 data series in crosstab Query i.e.
Manager      USD
AAAA           100
BBBB            125

I am working an invite list.
I have 30 fields for each record.  When using a query, I shorten it down to
Title, First Name, Last Name, Spouse, Dinner Invitation, Event Invitation and
Total Invitees.

I have a form bound to a table of available tests for a summer Credit By Exam
Session.  I created a query that finds only the tests that were signed up for
by students.
I need to update information on each test for the day the test is given and

I am using the following formula in my Query.
Correct: Left$([List Name],InStrRev([List Name],"_")-1)
I am using this formula to convert some data to the following;
"aaaa_hi_e_28"      converts to   "aaaa_hi_e" or

Hope I explain this well enough...  I have two tables in my db.
Table1 'Request' and Table2 'User'.
These tables don't have any link between them.
I need to be able to count how many Case-ID (from Table Request) exist

I have the following formula in excel to find the base name in the cell.
=IF(ISERROR(IF(IF(FIND("_",RIGHT(G77,3),1)=1,FIND("_",RIGHT(G77,3),1),G77)=1,LEFT(G77,LEN(G77)-3),G77))=TRUE,G77,LEFT(G77,LEN(G77)-3))
Anywhere G77 shows up in the above Excel formula needs to be pointing to

I have a query (CombinedQuery) that pulls values from two other
queries to use on a subform.  If Query2 has no records, then Query1
comes up blank also.  Any idea why this happens?

I'm trying to consolidate 3 different databases - it's a bit of a nightmare
and requires a various number of passes to achieve the final result.
I have an email address field in one table that I want to move across to
another table based upon the critieria match I currently have. ...

I have a duplicate query set up which shows the duplicate entries in a table
- called 'april08" i need to remove those duplicates from the main table
permanently but manually what is the best way to do that?
In other words I need to go through the duplicates to see which ones ...

I have been asked to supply data from my database to another database.  My
database uses the detail in seperate lines such as
Claim  Ref  ClaimQty Part Number
200      1

I have a date/time field from a GPS device that I need to convert to a date
and time field in Access.
The data in the "STARTTIME" field is "2008-05-07T10:38:00Z".  I want to
display it in a query in two fields, a date field and a time field.  How do I

I'm creating a query to support a form. That form allows the users to make
some searchs.
To make those searchs I'm using this criteria: Like "*" &
[forms]![37_form_PesquisaArtigos_Expedicao]![artigo] & "*"

my boss gave me an excel file which contain a list of addresses for
hospitals and doctos
the first column is a serial number , which is a merged cell , as each
address will take 5 to 6 row , i.e.for those 6 rose  , there is one serial

I am trying to get my query to run but it is giving me an error about SQL.
"The SQL statemtent could not be executed because it contains ambiguous
outer joins.  To force one of hte joins to be performed first, create a
separate query that performs the first join and then inlude ...

I use Date Forms a lot to pass dates through to queries, but for some reason
I can't do the same for Cross Tab Queries. Any ideas?