I was able to get my query to work with your help. Thanks so much! Without your help I would sill be clueless. Thanks again and hopefull one day I will be an...

Using Access 2003 I have a form with combo boxes for selecting criteria for a query. I would like for the user to be able to select a specific critieria from...

I am using the formula which runs a query to obtain the previous day's data (Friday's data on a Monday). I want to also run a query which gives me Saturday's...

I would like to query my table to output and based upon the presense of multiple entries in . In my example below, "Jones" and "Smith" will output in my...

I know that you can create a query with sSQL = some SQL statment me.recordsource = sSQL I have looked at other threads that have talked about using...

Hi, I have a data base with names and address. The street addresses are stored in two fields and the field is stored as a three character code, for...

How do I write a query that returns the product from each order that has the highest price? Each order can have multiple products, so there is an...

I have a table for files in our office. There is a field for date files are received and a field for date files are completed. I would like to make a...

I usually update one of my users access database by accessing his folder and the database through the network connection. Since last week, the folder and the...

i have a report must be done like this list of projects p1-p2-p3-p4-p5......etc names yasser 8% - 0% - 4% -...

Hi, please help I've just run a 'find duplicates' query on a table. Now I'm trying to select a single unique record from each duplicate. One of my fields is...

I copies and followed the instructions and installed the module from the site below: http://allenbrowne.com/ser-24.html It is not working and hangs at the...

I am fairly new to using Access and I need some assistance in working with an expression.... Working with Access 2007 I have a table that has a column (Name)...

I have a table that contains real data and then I have a table that has dummy data that is needed for another program that I'm sending the file too. I need...

Please Help - I have searched the posts and have found some ideas, but nothing seems to work. Here is the sql statement Error 3086 resolutions do not apply...

Thanks for taking the time to read my question. I want to use a field in a table as a list of items to filter out in a query. I have this: SELECT...

I have table Named OutStationTab having the data as below field EName - Text Field OsDate - Date Field OsAmt - Numeric field I want to make a cross tab query...

Hello I have the following query with 3 columns: SELECT tblRegister.TransID, tblRegister.Payment, tblRegister.Deposit FROM tblRegister; How can I have a...

columnA ColumnB ColumnC columnD 12345 23 78956 10.00 12345 23 89153 15.00 56780 23 15687 20.00 ...

Hi, I posted a Question but in The list its Grayed out... Is that Normal... or Some thing Wrong with my Windows Live... Mail ? thanks.. And Thanks ALL ...