I have a table in SQL. it contains employee details. Eg. name . id . sex etc.
.. the primary key is the ID no.
ok now there are around 18000 records in this table.
i have made a form in Access. the user enters the ID number and the details

I would like to add a column in an existing table with this code.
ALTER TABLE tCheckImport ADD COLUMN bStdOpt BOOL
But it doesn' t work, what' s wrong with it ?
Regards

I would like to think I am a pretty resourceful guy, but this is driving me
crazy.
In short, I need to use a combo box as a data filter, unfortunately this is
harder than it sounds for the self initiated.

I am working on a new website using asp with an Access database. I have
a problem with a Memo field when adding/updating - the SQL fails with
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC Microsoft Access Driver]Invalid precision value

Hi Can anyone tell me how to roundup and rounddown depending on if a number
is greater than = .50 then roundup >.49 rounddown.
1.69  = 2
1.5   = 2

I have written a query which pulls various bits of data from a number
of tables and then does some calculation based on information pulled
back. The results can either be positive or negative and I need to
sort this field decending....starting with the higest positive and

 Im not sure if this is possible in Access, but i got a table set up like
the following:
Name                  Ford   Chevy   Dodge
----------------------------------------------

hello.  i have 2 queries, 1 that has daily data entered based on how many
customers a salesperson had that day and one that is monthly for how many
cars that person sold for a given month.  i have a report that is based off
of the first query but now i want to add one field from the ...

How do i test if a field value is either a string, a number or null

Access 2000.  I need a delete query that will only delete the contents of
one or two fields in a table.  I have a table named "EMP"  2 of the fields
are named "FirstDay" and Last Day" I need to delete the entries of these two
fields, not the data of the other fields...Thanks.. ...

Ok - setup.  3 tables as below with obvious links.  Reservations, Tickets,
Events
I have a Reservations form with subform Tickets all working OK.
What I need to be able to do is to add new tickets to the subform and by

queries were working just fine earlier. Article 141351 didn't solve the
problem??

I am converting and updating a business contact database.
the first search is on "LAST NAME".  that works fine.
I would like to have a query that first prompts the user for the name of the
field that they would like to search on and then it runs a basic select query

Trying to do something in Access that I usually do on smaller recordset in
Excel.  Want to search a field for a string then have access return the
point at which the searched string starts.  That way I can do a mid
functions to try to strip the string and trailing characters into a ...

I have a table that contains claims data.  I need to isolate duplicate claims.
The combination of three fields (name, date and procedure) all of which must
be identical constitute a duplicate claim.  Any suggestions on how I would do
this?  Im a code novice and use query design or ...