I'm trying to determine the number of times items are found together on a
delivery in a database.  Each delivery is a unique number with multiple
items.  Each line of the data base is unique to an item/delivery combination.
So, if the delivery has 10 items, there will be 10 ...

I have a table with the following structure:
BookingId    StaffId    MemberId    BookingDate    BookingFrom    BookingTo    Cancelled
117    14    2025    2/8/2005    10:00:00 AM    10:30:00 AM    No
118    14    2025    2/8/2005    8:30:00 AM    9:00:00 AM    No

I have numerous fields that need to summed in various ways.
Is there a function (or formula..) that will drive a query to sum a range
horizontally because my expressions are getting way to large....
Any suggestions?

I have 3 tables joined together.  The relationship between the 3 tables are
based on a field called record number.  
when I try to run the query I keep getting the Could not delete from
specified tables.

I'm trying to build a report and a query from several tables using the
wizard. On going into preview I get a message "type mismatch in expression.
I've not included an expression in either item.
Can anyone help?

To generate the following table,
        Last    AVG    AVG
AREA - EQUIPMENT        Day    MTD    YTD
Lombo-Skimmer    163    147    91

I have a query with multiple tables with a one to one relationship except
one table, it is a one to many.  When I run the query I get the ambiguous
error.  If I understand the error, it is telling me to create one query with
two tables, one being with my one to many table and put ...

I need to get the number of week in the year from a date. I've tried Format
(Adate; "ww") and a lot of ways more, included the specific spanish
sentences.
Any idea?.

Hi im trying to create a query...and everytime i try to run it it say
"type mismatch" but this only happens when i have my linking tabl
open...but then when i get rid of it...there is no link between th
remaining two tables and hence the results returned is all th

I created a union query using Select * from each query.  When I run it I get
an error message that says too many fields definded.  How many fields can be
in a union query?

Hi, i'm trying to select certain records from my file. For example, how can I
select all records that end in '-5' or that contain a particular word
Thanks

Is there any performance benefit to using a SQL view over an Access
pass-through query when using SQL server as the backend?

HI, HOW CAN I REMOVE THE ACTION BOX "THE EXISTING TABLE WILL BE DELETED
BEFORE YOU RUN THE QUERY, DO YOU WANT TO CONTINUE?" WHENEVER I RUN MAKE
TABLE QUERY. SO AS NOT TO MANUALLY CLICK YES EVERY TIME I RUN THE MAKE
TABLE QUERY. THANKS.

I am trying to replace chars in field without replacing all the chars.  I
have many fields in Member TBL called MbrName. The data will have  many
different values with the chars #### embedded in the name .ie  BC1D#### or
BCP.FIle###.Daily  ect.  I need to run a query that promps ...

I have a report that is based off of query #3.  Query #3 consolidates the
data from Queries #1 & #2.  Queries 1 & 2 each run in about 10 seconds, but
query 3 takes 8 minutes to run.  Query #1 is as follows (#2 is similar):
SELECT Data.LogNo, Data.Clock, Data.YrsPos, Data.Date, ...