I'm hitting a SQL backend database that has a time field in it, but it's
store as numbers.  Below is some of the data it contains:
Entered    Required    Start    Complete
675            615            675        676        data

I'm trying to install bluetooth usb adapter but this error is occuring on my
computer:
     "This problem was caused by a compatibility issue between this version
of Windows and Sync Profile.Sync Profile is usually distributed by the

I have a query in which I use a function to calculate the quantity that
needs to be ordered based on the stock and the demands of a customer.
The query run's fine the first time I start the database but when I scroll
in the query window I get different quantities that are ...

I'm trying to do a passthru query using two tables to just pull patient
diagnosis code from one table and the diagnosis description from another.  
When I run as a regular query I need to bring the diagnosis table in 4 times
in order to get the description for all 4 diagnosis ...

Hope someone can help me with this as, despite spending a lot of time looking
through previous posts, I'm still no wiser.
I have a table to log incoming complaints and now need to produce a summary
report which counts the number of complaints by various criteria.  I can do

I am a novice at Access and I have created a query to total statistical
information, I know how to create totals within a record, but I need to total
like records within a query as well.  Specifically:
Facility             Emp ID       Total proceedures     Date of proceedure

I amy trying to create an Update query to change the data type from numeric
to text.
i.e.: Field.[SUBTYPECD] is 1 and I want it to update the table with "Switch".
Thanks,

I need criteria for a date field in my query.  I want only the dates returned
that are older than 5 business days.
Thanks!

Is there a way to find all of the queries that use a specific table?
I have a table with names and codes for each name. My company has changed
all of the codes on May 1.
I added a new code column to the table, but I need to run reports & queries

I keep getting the "can't delete from specified tables" message.
I've tried using the totals query as it is, as well as using a table composed
of the records from the totals query.
The SQL for the latter is;

Hi guys, I would like to know if this is possible. I have a price column, in
my query I return this as a total row, so it shows the totals for each item I
listed in my query. I want to know if it's possible to also have a final row
or column that shows that grand total for each ...

I have a names & addresses database set up with an auto-numbering
reference field at the beginning. (Access 2002)
Today I tried to merge in same new records from a CSV text file, and it
wouldn't accept them as they 'didn't have a non-unique reference in the

I am also experiencing this.  I get the date from and Unjoined Table that
only has a single record which is system generated.
Perhaps you can guide me as well.
Thanks

Good morning,
I have a quick question, I have this database that has all of our tracking
information for about 30 locations based on 10 procedures.  We then look at
each procedure for each PDC and calculate the minutes it took each procedure

I have a table that has been sent to me that has multiple time stamps done
when individuals update the fields.  I need to find the min of 6 date fields.
can this be done in a query?
thanks!