I have an Insert Query as follows:
INSERT INTO web_MailingList ( SubscriberName, SubscriberEmail,
SubscriberDate )
SELECT [@SubscriberName], [@SubscriberEmail], [@SubscriberDate];

I have an Access database table, named web_MailingList, with 4 fields:
SubscriberName, SubscriberEmail, SubscriberDate, SubscriberId
SubscriberId is the primary key and an autonumber.
I want to insert a new record in the database.

I have following query it just work fine and faster with say below 100
records or so. But I want the same query to
run in a table where there are about 50 fields and the number of records are
about 10,000. The query works but it is very slow.

I am working with a Microsoft Access Database helping a non profit
organization try to figure out how many nights in a month people are staying
in there shelter.  I have two fields a Check In Date and Check Out Date
Field.  Therefore to figure out the nights a person stayed, I ...

Access 2003
I have a query called MyRoster. I setup a form and ask user to type in
Employee Number which will be a criterial in my MyRoster query.
I want user to click a command button on my form so the query result will be

I am trying to find out the delay in days occurred between two date
fields in an MS ACCESS 2003 Query.
ScheduledDateforProductApprovalbyOBI:IIf([ActualProductSubmittalDate]<([ScheduledDateToPlaceOrder]-10),(IIf(([ScheduledDateToPlaceOrder]-([ActualProductSubmittalDate]+15))<5 ...

I have aYes/No field in a table. When I output it's select query to Excel,
the field is printing out as True/False. How can I make it print as "Yes" or
"No" instead?
TIA,

I am trying to get a count of how many columns have data entered.  This is
non normalized and I'm not paid to fix that :(  So I am trying to get the
count of shirts in this case.
Alterations.Date, IIf([Shirt 1]="    ",0,1)+IIf([Shirt 2]="

I have a small business that I run, and I have used Service Time Management
wizard to build my database, with some personal changes due to the personal
preference and requirements.
I am right now stumped at creating a report from a query that sends out

When appending batches of records into a master table, I want ID numbers
automatically created to start with the next available record number after
the highest ID number in the Master Table that is receiving the appending
records.  I prefer an incremental numbering system rather ...

I am making a catalogue for a small library. The books come in one of x
bookcases. How can I  indicate, in a tabel in which there is a choice
between table 1, table 2, table 3 etc. that one of these must be ticked
 (in a "choice-round" for example) but not two of them can be ...

is access support the SQL Case statment? if not how I can get the similar
function in access query?
something like
Select CASE column1 WHEN "abc" THEN column1 ELSE column2 END as columnNew

Hallo All,
I have the following table with fields/columns and test data) called
tblExport03
ID  FirstName  LastName   BusinessEmail    PrivateEmail       NoMail

Can any one please tell me how to i write a query if TableB field MatchField
contains value FieldB then FieldB join with FieldD of TableD and FieldS match
with FieldSS. If MatchField contains value FieldC then FieldC join with
FieldD of TableD and FieldS match with FieldSS. If ...

if something is not = "Closed","Sent","Completed"?
I do not want to see these in my query when I run it.