Hello.  I have a union query that returns the correct records.  I want a
count of how many records are brought back.  After moving to a union query
I'm having problems getting a count.  I'd appreciate suggestions.  Thanks.
SELECT [LastName] & ", " & Nz([NickName],[FirstName]) AS ...

I am trying to split on field into three in a query,
Redgum QLD 4850
Newcastle NSW 2300
Rye VIC 3950

I've used a database for a year, many users adding info to it. I've written
many queries and they've worked beautifully. This week I've been getting a
"record is deleted" error and the query changes before my eyes to all the
cells reading "#name?". What gives?

on a continuous form with the record selctors on, can the record selector
icon be changed from the asterisk to something a little more application
specific like maybe the words 'new technician' on a continuous form where
technician info is entered. Or, turning the record selectors ...

When creating a query, using the simple query wizard the linking of all
tables are done correctly. However, when designing an existing query the
tables that I add are not automatically linked. The database is split (all
forms, queries, reports are in one database and all the ...

I've tried to research this question, but maybe my terminology is
wrong.... but basically this is what I am after...
I have a table which includes a field containing a percentage. I which
to convert this percentage to a value based upon a pre-determined

In palin English, I have a table based on club members and several other
fields of numeric data. Some of the fields are numbers, some currency and
some text. This data deals with members betting on horse races.
My question is how to display a summary of each members bets based on ...

I have a database in which I store some date and times.  When from Excel I
use the MSQuery Tool to return the information it is bringing the date and
time back as
9/3/2005 0:00    1/0/1900 11:00    1/0/1900 12:00 When what I want is:

I would like to have a Query that the user will only need put in the month
and year and the Query will only give them record that fall in that month.
Jan 2005  is what I would like the user to type in.
Thanks

Sir/Ma'am,
    I have a query that searches out specific records by date. The query
works the only problem that I am having is when I run the query and it
prompts me for the date, it will only accept dates such as 22-Sep-81 or

I have a query called qryCustomers.
I have a combo box called cboShip_Month. When the user selects Jan in the
combo box, a 1 is placed in my table under the Ship_Month column for each
customer; for Feb, a 2 will be placed, for Mar, a 3 will be placed etc...

so i followed these directions from Sidney Linkers and it works great:
http://groups.google.com/group/microsoft.public.access.queries/browse_thread/thr
ead/0086ac09357304ee/740038393f778528?hl=en#740038393f778528
I'd like to add a twist i was hoping someone could help!!
[RecID]   ...

I have an append query that will not work and causes all the records to be
rejected because of validation rules.  This is the SQL view of the query I
bult with the query builder.
 INSERT INTO PHYSICIAN ( physician_id )

Hi, I am using Access 2003 on a PC with Win XP, 2Gb RAM, etc., etc.
I have a table with 4 columns, and 73,766 records:
ID: Autonumber
Row: Text (to be used for my row headings), 458 unique headings

I need a query to report 2 columns of the same field, but with different
criteria.  Example:   [Type]  Criteria of   "Like16"  and  [Type] Criteria
of  "Like 17"  This way I can have two columns in a report.  Can I do this?
Thanks..Randy