Windows XP Pro MS Office 2002 (XP) Getting this error message in a database I've used for years without problems. Have unistalled office, rebooted, and...

"Leslie Isaacs" wrote So on behalf of all of us questioners, I'd like to raise a glass of nice, warm English beer, and say...

"Jan Il" wrote Agreed! Those who come to these groups and give of their own personal time time and expertise, no matter how little...

i'm trying to calculate some running totals of some fields but i'm having some problems... I have a querry that calculates some other things for a table so...

I'm not sure this can be done, but I hope so. I have a query with over 6000 records and within that query I have a field that is titled Department. The...

Hi Experts. I have a yes/no field called "Replace" which I would like to be automatically "YES" (or checked on my form) if the previous field, "ManholdCond"...

I am fairly new to access and have a question, so i have 2 tables, they both collect simiar information but we want them seperate for data input... (if that...

I saw this in another thread but not sure where I would put this in my query. I have phone numbers stored as text and when I run a certain query to export I...

I would like to let users to choose a radio button and get different result from the query. I would like to know how to implment it. For example, the radio...

I have a table (tblBudget) that contains three fields: , and . Each has one header record (=0) and may have many detail records (=1+). The field in the...

I have information in my form and tables. Lines 1-3. I built a query. It correctly reflects the information from lines 1-3. Now I add infomation (or...

is there a way to specify single spacing for entries in the detail section? tku

I have a query that counts dates in a field SELECT tblvehicles., DateValue() AS Expr1, Count(*) AS Expr2 FROM tblvehicles LEFT JOIN tbldispatch ON...

Hi, I have managed to extract first name, middle initial and last name into individual word in query from a person's name, from there I retreive the first...

I have two tables with a many to many relationship joined through a junction table. The first table contains data from scientific experiments. The primary...

Hi, I am trying to implement a query to find the most recent records for a series of datapoints. i successfully used the following SQL statement on a small...

I am trying to write a query where I have the fields: admission date, discharge date and I subtract the two to get hours in hospital (Total Admission Hours:...

I have this expression in a query of a sample database downloaded from Microsoft and was wondering if someone could help explain what it does. Also, what...

I have a largequery where 90% of the data output is correct, but then I get a high number of duplicates (up to 30 of the same) for the remaining 10%--the...

Dear all.. Good day... Kindly help me . I have created a table d1. d1 fields are date, r1,r2,r3,t1 r1,r2,r3 are numeric values t1 is text