hi I have written a query that has worked fine for the last few weeks and
today has suddenly stopped working. I didnt do anything to the design of the
query today. the only thing I did today was to implement user level security
using the security wizard. when I try to run the query, ...

Some help please.  I have an original log as follows:-
NAME            TIME                    OLD VALUE  NEW VALUE  No
W53    3/20/2006 10:45    STATION1   STATION2    1
W53    3/20/2006 10:46    STATION2   STATION3    2

Hi gang,
One more little problem to work here:
I have a form 'formadmintestmain' with 3 tab pages on it. On one of these
pages is a subform 'formadmintestpage1' which gets its' data from a query in

I have three tables - tblRoster,  tblMeetingDates and tbl Year .  The roster
table has all the names, address, city...    The meeting tables has when and
where each students meeting will be held (one a year). The roster table has
a 'year' field that holds the current school year ...

Maybe I haven't worded my search phrases properly, but I can't seem to find
an answer. I can't wrap my brain around how to get a report to return only
that data found using specific criteria. I tried following the steps in
Access Help but to no avail.

Is there a way to import data from excel into Access when the column names
are in one column?  Everything is in one column.  For instance, column A as
Column A
row1: idno

Hello Access community,
I am a novice and want the sum of a query that results in
CountID         Type
10                 1

I don't really think this is that complex.  My medical database includes
mixed data, text, numbers,  yes/No's etc  Specifically, patients that have
undergone a specific operation by a specific surgeon, some have certain risk
factors and some have had certain complications.  I can ...

I setup my update query trying to remove the last 4 of a FileName
I tried
LEFT([Powertabs],4) but this left only the first 4 letters of the file name.
I tried RIGHT([Powertabs]),4 but this gave me .ptb

I have several yes/no check boxes that I which to concatonate only if result
is positive.  (By the way I am also changing the result to a letter is
positive. I also want to add a comma in between results but once again only
if the next result is positive.  What I have is ...

I have a query based upon a table (ClientInfo) with 362 rows that because of
a Select statement in one of the  Fields it translates to 14560 rows.
Here's what I am doing:
ClientInfo Table:                                SiteChange Table:

I have created a query (QryAverage) based on a table.  The query contains all
the fields contained in the table (AdNo, Forename, Surname, Test Result 1,
Test Result 2, Test Result 3, Test Result 4, Test Result 5, Test Result 6).
The query then contains 3 calculated fields - Total ...

When trying to crate an OLAP CUBE from an access database in excel, i get the
following error. Does anyone know how to fix this?
CLIENT SAFETY OPTIONS DO NOT ALLOW PAS THROUGH STATMENTS TO BE ISSUES TO THE
DATA SOURCE

I'm building a query that shows the total sales value of our company's
widgets over time. I have the following tables:
1. A table with the various widget types
2. A table with units sold for each widget type by date

I have a query with one field (text) that needs to be parsed into two
separate fields (num, date)
Ie.
Field 1 -  [Hits]