I cannot make a secure connection with my bank & often cannot access google. Can I download to fix this problem jan

I just had MS Office 2003 installed on my computer at work. I previously had Office 2000. I am always copying query results and pasting them into Excel. This...

Please help! I have a database that consists of physicians and their medical specialties. They can have as many as 3 (Spec1, Spec2, Spec3). I need to link...

I am trying to select records based on the value of a combo box column. I am using it as criteria in a query and referring to it as...

Dear Jon: If is is the case that there is no row, or combination of rows, that uniquely identify the rows in a table, then the only way would be to use...

I have a form that I use to input criteria for a query. The inputs are in the form of comboboxes. It works great. Of course when I enter the criteria and hit...

How can I prompt for the same result in multiple fields. This will have to include a partial ie. Like ("*" & & "*"). I can get this pull up the proper...

I need to write a query that would be based off of what kind of training someone has. My information is stored as 1's & 2's as it is entered from a data entry...

I frequently need to change the source table in my queries. Eg. 10-1-05 to 10-15-05 to 11-1-05. I open up the previous query, then add the new table, delete...

A number of my queries using functions now do not work since my PC has been migrated onto a new OS whereby the administrator has locked out access to...

does anyone know how to get a query to choose the maximum number only. I have a spreadsheet that includes students and their test scores and want the query to...

Hi members, I just need to know is there any mechanism for autonomous transactions in SQL server 2000 as I have to maintain a log inside a transaction, If I...

SELECT Count(employeeinfo.) AS Expr1, employeeinfo., progress., progress.status, progress., progress.award, employeeinfo.surname,...

I have three tables with the following fields: Table 1 Table 2 Table 3 Payer Name (primary) Payer Name ...

How do I un lock read only in a Access 2000 file? I sent to workmates for them work with it, but they could only read. The file was zipped before I sent it....

I have 2 tables, one is the main data tables and another an audit table, hence unless an activity has taken plan will not contain related records to the main...

In my table, Field10 is full of negative numbers. I want to change them top positive numbers in an update query. In the Update To: I have *(-1) has no effect....

I don't know if I'm doing this wrong..but it seems as if the datediff is adding 6 extra days. I'm using it in a query as this: DateDiff("d", , ) The DOB...

The following error is not addressed anywhere. The following formula does not recognize 2 digit months as being greater than the conditional expression. Life...

How would I list all records where a value in a column appears more than once? EG: Table 1: id letter 1 a 2 a 3 b 4 c