I have 2 database tables, Master and Detail. I would like to create a join
query to select the Master records that have no detail records.  I have tried
many ways but can't find the solution.
Thanks for your help in advance

I'm trying to concatenate separate fields in a query to make an output
file containing a single name record.  I've tried using the IIf( etc.
statement, but it doesn't seem to be working and I haven't been able to
find anything on a search.

I have a database in which due to past entries, some phone numbers include
the formatting, i.e. (555) 123-4567 and others used an input mask and simply
have the digits, i.e. 5551234567.
I would like to do an update query that changes only those numbers with the

I would request for a solution of this problem. I have a Select query that
uses PIVOT to show data vertically.
I always need to show all PROVCODE data in columns. Even If I dont have data,
I need to put a zero under that PROVCODE.

I have a database of our technical library holdings that includes a table of
books--title, author, etc.--and a table of keywords connected by the common
key "Book ID".  These come together in a parameter query in which the
parameter value is "keyword".  The "keywords" field ...

I'm trying to concatenate separate fields in a query to make an output
file containing a single name record.  I've tried using the IIf( etc.
statement, but it doesn't seem to be working and I haven't been able to
find anything on a search.

Hi, I'm trying to create a crosstab query that I can enter the dates,
but there dose't seem to be a function (newbie) for this.
What I'm currently doing is, using a crosstab query against another
query. Surely this can't be the way it's done?

My database looks like this:
ID    Time    Date             Code
1    93116    20060403    UMUD06C30.00
2    93137    20060403    QAAE06C65.00

I have two Excel Spreadsheets which I want to compare.  I have imported them
in Access.  I made the primary key in both tables an auto incremental field.  
I want to match the records on SSN and Effective Date Begin - not the primary
key.  Spreadsheet A has data pulled by operator ...

I need to insert data into Table1 from Table2 and the Main form. Here's the
scenerio: I need to insert into Table1 fields: ForecastID, PartNumber,
Quantity.
ForecastID is obtained from the Main form's txtForecastID textbox.

Can I get an error message to display if a select query does not find any
records? And can it be customized?
Thanks in advance.

I have a table that contains various fields. One of these fields is
[AreaOfWork], who's value is one of a possible 10 from a lookup table.
For each of these 10 values, I would like to count how many records
have the particular value.

I have a query that contains a field called [loccode]. I am filterin
data as follows:"61 or 62", "68 or 69" and "between 71 and 79".
Each filter criteria equals a department area:
"61 or 62" = Dept Area A;  "68 or 69" = Dept Area B and "71 through 79

I am using sql language to filter my database and I get an error message.  
The message says that I have eexceeded the 1024 character length.  Is ther a
way around this?  It lets me run the sql statement and query, but is not very
happy about it.

hi,
I have the following query for which I am getting a "syntax error in query
expression".  But I can't figure out what is causing the error:
SELECT M.[Loan Acct #], M.PopEnterDt, IIf(MP.[chg off date] Is Not Null And