Hi all, I have 2 stored Crosstab queries which are basically the same in structure but which pull data from different sources: qryXtab_tblTemp: TRANSFORM...

How can I attach a macro to a action querie so i can create a button that will run the action querie?

I have been given a solution to an earlier post that I understand but can't get to work. Is the Select * From function used in Query Criteria box or elsewhere?...

Hi How do I write expression eg 1 of 3 where 1 is field and 3 is field in excel I would use concatenate but I don't know how to do in access TIA Tina

Hello All I have a data base which I have inherited and Im trying to sort ... In my data base I have an employee number which is unique to the...

I am trying to get the column order in the Design View of a query to match the order in the Datasheet View. I know how to move columns in each view but if you...

I am working on a project and there is an existng table which includes a FirstName and a LastName field. I am trying to design a query to include the data from...

I have an Orders table that has a Freight field, a ShipCity field, OrderId field, and CustomerID. I want to create a query that displays Order ID...

This is from famous "Northwind" DB example. Suppose you have an Orders table that has both a Freight field and a ShipCity field. You can create a query that...

Hi there, We've just converted our Access 2000 databases to Access 2003. A simple SQL query: Select ID, format(MaturityDate, "dd-mmm-yy") as MatDate From...

I really need some help. I have been trying to get this to work for hours but can't solve it. I have a list of Facilities that were inspection (tbl1). In the...

I have a table where there could be multiple rows for each lender which I would like to combine in a query. For example: Lender Property Type Lender A ...

Hi, I'm having what seems like a common problem where ' (apostrephes) with a record are causing trouble when run through a query. I've read about double quote...

I have 2 dates I want to know how many days weeks and months went by (for rental purpose) I did Days: - and this gives me a flat number of days (26 days, 13...

Please explain why there isn't an Append Update Query function. How can I create a query to append and update data?

I have a questionnaire database that contains participant’s demographic information such as age, salary range, employee type, age group,...

How do I go about getting the programs that are in "programs" to be alphabetized? I have Windows ME. thanks in advance. cl.

Need help trying to figure out how to make a 2 field query showing multiple phone numbers (home, business, mobile) with the contact ID in the...

Simplified, I have one customer table with customer no. and name and one order table with customer no, order no, valid date from and valid date to. That means...

I wanna prepare a make-table query. I have a field name with "number of students". there are values like 0,1,2,3..etc. in it. What I want to do is that when...