I was creating a query in design view (access 07), and because it was a
bigger query than I normally do, and noticed that the number of columns
stopped at 16.  Is the number of fields in a query really limited to 16?  If
so, I find that very hard to believe.  If not, why does it ...

I've a table that has one column  with 2.5 million entries in the column.
When I create a query to group and  get a count of the entries  Access locks
up system advises "not responding". What can I do to speed it up? I've the
column in the table "Index yes dup" that hasn't speed up ...

Morning all,
I have field that contains dates.  I need to add up each time a visit
is made.  Easy enough.  In a query, I run the date count and all works
great.  However, I need to filter out if the date of the last visit

Date Differential between full date (month, day, year) and partial date
(month and day).
Really need you help on this one.
I am trying to write a QBE expression that identifies if the an employee's

Is there any solution for Max without grouping?
There are different data and only one distinct on the row to display for the
max value. For example, data are as : 1, 2 , 6 , 7  and another column to
find for max value  here is  for relation to it :   3, 4, 9,  2  so the only

For some reason thedesign grid in one of the queries that I have created
disappears.  I can still see the tables and queries upon which the query in
question is based but the actual design grid has gone.
The grid cannot be located by doing a grid search using the scroll bars (all

I have a database with street names and address names..field 2 is address and
field 3 is street names.  I need to find a way to see which in the two fields
are the same and which ones are not the same.  I am very new at this. Can
someone please help.

I have an Access “mdb” database that has multiple linked SQL Server tables. I
'm interested in querying a SQL Server table that has, as part of its primary
key, a date field. I would like to query the data field and retrieve the data
field’s milliseconds. Does anyone have any ...

I have a table of temporary employee data.
I must produce a 3 page report where each page has a different layout and the
employee printed is different on each page.
report  #1              report #2                     report #3

Hello, in a table there are two fields F1 and F2 that may contain similar
data. What I want is to find out which records have the same data in both
fields F1 and F2 and have the number "1" entered in field CH.
So if data of F1 similar with data of F2, 1 must be entered in CH.

DatePart("q",[name]) works for quarters for the year (total is 4)
DatePart("ww",[name]) works for weeks of the year (total is 52)
How can I determine weeks within the quarter (should be total of 13) ?
Thanks.

Is it possible to show the records that aren't in a query?
I have a select query which runs fine and selects what I tell it to but then
I would like to know which records are not in the query. Is there a simple
way to do this?

Is this possible with Vista_

I'm using the following sql to show items dated today +6 days in advance.
How
might I also show items dated prior to Date() (past due items).
SELECT * FROM tblReminders WHERE (((ReminderDate) Between Date() And

I have a query consisting of 4 tables and 2 subqueries that returns a wrong
value in a given field.  This is when no fields are linked where the value
is derived; if I try to link fields in the table then no records are
returned at all.