In access, I need to run a query that will give me a concatenate of certain fields IF the same order number number shows up more than once (if the order #...

I get a text file and link it to a Access table. I then transfer it to another table with a text field that is a date and data is in this format: 091105. I run...

Hi, I set up a parameter query that asks the user for a serial number and then it displays the record matching that number. But if the number doesnt exist it...

I am trying to run a query using: Between and formula. The dates I entered are in Data Type Text instead of Date/Time because sometimes I need to enter text...

I am working in Access 2000, and I posted a similar question a while back, but was unable to make this work. I would like to set up a cross tab query that...

Hello! Here is part of my database: tblStudents: StudentID tblStudentsAndMajors: StudentID, MajorID tblMajors: MajorID tblMajorsAndClasses: MajorID, ClassID

I have a query where I want the variance between amount fields in two different tables. It calculateds the variance if both fields have values but not when one...

Hello advisors. I want to create a parameter query with my start date as any date possible and my end date being today. I don't want the user to have to put...

I have a table with 3 date fields in it. I want to pull the earliest date out of all three fields and put it in a field in a query. example. Fields...

I'm using Access XP. I am trying to produce a query that lists students in our database who are first or second year students in our program. To that end I...

I am trying to perform a reconciliation by matching bank records with general ledger records. The unmatched query is great at telling me what amounts are in...

I am getting all fields from a table displayed in a query even thogh I have selected only a couple. How do I display only the fields wanted?

I want to incorporate a message "Processing..." for the user when a page is running a lengthy query. I don't know how to do it. I have tried a Response.Write...

Can anyone tell me what I am doing wrong here? strsql = "Insert INTO tbltemp (strdriver) SELECT distinct tblpurchaseorders. FROM tblpurchaseorders...

Hi All, I have two tables with a one to many relationship, one table has a single record with an autonumbered field for Clients, the other table (for...

My duplicate records really are duplicates. Our Oracle Server is returning multiple instances of the same record when we query it. (The sys admin people are...

I have a net amount that is negative and another amount that is negative. I want to know the difference of the two and show that as another amount. Just so...

In Access97 how can I print the SQL code for a query. In the Design of the query, I go to SQL view and all of the code is highlighted, but I do not see any...

I have a crosstab query with a sum of the values as a row heading called TOTAL. In other words if my columns are 1 through 12 then the 'total' field reports...

I am trying to create a query where the user will require to enter the from and to date and also the query to create a sum of the amount field. When I apply...