I have query that counts how many bookings were made on a certain date, but I
need to total it by each week (for example 5 on monday and 2 on wednesday,
week 1 total = 7)
I have worked out that you use:   Format([dteDate],"ww")  for the week, but I

How Can i calculate this running total? In Report's it´s ok, but in
sql/query's...
Help, somebody?

I'm working with a user who recently got a new computer. On her old machine,
this query would run fine. On the new machine, it tells her that her query is
too complex. We're running Office 2003 SP2, on Windows XP SP2. The query is
as follows:

Within my table, I have two fields, 'Tagname' and 'System'. Tagnames
are a list of tags I'm using e.g. 06TI293.PV. Often these tags are
duplicated. For each tag, there is a corresponding system that it is
on - either 'PHD' or 'XANS'. Not all tags are on both systems, some

I need to run a query where one of the values should be a Percentage of the
bottom total (not the "right" total). It's kind of an ABC analisys.
Almost every sql language allows that. Access doesn't?
If it does, how?

I want to build a query with which to find the greatest number of figures in
the field.I have a field called Plates where single numbers are entered.For
example
Visits      Plates

I would like my present table with 2 columns:
ID     tekst 1, tekst 2, tekst 3
ID     tekst4, tekst5, tekst 6, tekst n
(text in second column is comma delimited)

Howdy Folks,
I would like to be able to use the Access crosstab query function to
make a more human-readable table for me. However, there are two
limitations I run into:

I created three Sum Queries which resulted in SumofBegBal; SumofATotInc;
SumofTotExp. I tried to create a new query which would give me my ending
balance. In the new query, I put the reference month, and each of the sumof...
in a new column, I put EndBal ...

hiiiiiiii friends
my problem is concern about a querry  for example i have numbers in a field
whose data type is number
400004780

I made up a table with a field which originally contained text and numbers.
So left it as a text field.  After entering data and then subsequently trying
to query the field I feel it would be better to just use the numbers however
when I try to query pull the data on 1 and 2 it ...

i am trying to write a query which groups students to each module studied
and counts the number of students studying that module. I.e. there may be two
students studying a course which contains five modules there will be five
names and the answer should be two.  Can you help me ...

I have the following fields in a table:
DateofExam (date field), #ofExams (number), Examiner (text)
Example:  8/15/2007, 5, Jones
I can't figure out how to build a query that will sum the "#ofExams" field?

What will execute faster?
strSQL = "UPDATE usysAppProperty "
strSQL = strSQL & "SET usysAppProperty.FIELD_VALUE = "
strSQL = strSQL & "Format(Date(),'Short Date') & ', ' & "

Hello, We have few applications accessing a MS Access mdb to retrieve a query
data. When the number of calls sent to the mdb are more than a limit, we get
the error called "Too many active users" and all the extra calls are rejected.
Can anyone help me on this? Is there any ...