I'm trying to concatonate values from a related table for reporting purposes. I'm on my third day and fourth different approach to getting this done. The...

Hi everyone I'm trying to write a nested IIF statement to calculate commission for an ROI report. The particulars a If revenue =0, commission =...

What does "Operation failed" mean after checking for new mail through Send/Receive??

In a database, I have a table with tree fields: FirstName, MiddleName and LastName Using a Query, I would like to get either: Firstname & " " & MiddleName...

Keeping track of test results, I have a database containg two related tables - Names and Scores (one person may have more than one score). Using a query to...

I need to test to see if a query comes back null or not. If not null, it should enable a control. Ron

The following appears on a dialogue box when I try to open the file: "Cannot find the file C:\WINDOWS\DESKTOP\file namemdb." I have a Windows 95 operating...

I have a select query that works fine as follows: SELECT StudAddress.* FROM StudAddress LEFT JOIN Student ON StudAddress.SID = Student.SID WHERE...

Hi, I have two tables both have company ID and company name. but they are from different coding systems. That means, I have table1 with ID1 and name1 and...

I have to tables and both has a field "tougou", one table has another field "flag", I want to match the value of field "tougou" and for those doesn't match...

------------------------------------------------------------------------------ -- The format is date/time When i run the statement : SELECT...

I am trying to create Outlook Appointments for our field staff from an access query that is being pulled from our SQL DB. I am using Visual Basic. I am...

could someone please help, is there a way of showing a zero in a query field that shows a blank (empty) field.

I am creating a school locker database. I am trying to create a report that will list all the locker numbers and combos and then list the names of the...

How can i export all saved queries sql into a text file or an excel file.

I'm using a Query Crosstab with 4 Column Headings: None, Low, Medium, and High. As long as I have each heading selected as an entry in the database it will...

when I build a query in design view using query builder. I can see all the criteria fields like field, table, sort, show, criteria, or but there is no total...

due to a jet engine error (80004005)i have changed the date format in my db from short date to medium, however, when i run a query the criteria (Now()) or...

I have a query from multiple tables which records visits to patients, hence a patient can have more than one visit per month or infact none. I want to produce...

Hi, hope this isn't a dog's breakfast to follow but I'm banging my head against a wall here. I've read & tried tons of your posts for the last 2 days on...