I have a query that summarises sales data for a particular month and cost centre. The data comes from our accounting system and is held in a single table in...

Hi I have created an Access 2000 database which links to all the tables on a remote SQL Server 2000 database. How do I write the sql statement (or modify the...

Beginner in Access 2007. Question related to queries: concatenante fields. Does the expression results show in forms? Also, pre-existing lookup data type...

Hi, I have a form called Test. On this form, I have a textbox where I can type query criteria. I would like to be able to type multiple criteria into this...

I am having a problem with the iif statement when I use it in the criteria for a query for a combo box (Combo2) that is based on the selection of another...

Problem: Eliminate duplicate values based on one field and still maintain the availablity of otherfields for the retained record. I sort on date to bring the...

I have 6 columns with Contact information and 6 date columns. (ie. Contact One, Contact One Date, etc.) How do I return the latest Contact and Date. An...

what is the best way to go about doing this? i just created a report that first runs a query for current month info in teradata sql assistant and exports to...

Hi there, I was hoping that someone might be able to help me. My Access knowledge is at best, rather limited, and I am stuck now and cannot proceed further...

Hello, I'm using Access 2003 with an Access 2000 database. I've got 1 form which is correctly pulling data from 2 tables. I'm having problems updating both...

I would like to create a form that asks for start date and end date (with defaults) that will then send these values to a report that starts with a query. I...

Does anyone know why the SQL view may not be available to use for a table of form? I have read that you can get the SQL view by clicking on the view button...

I have delete query in a form module that can potentially produce a key violation because it would delete the table's PK which is used as a FK in another...

Hello, I have a combobox on a form and currently I manually select the next item for a member as needed. This is fine for 1 or 2 but typically I have to do...

I am trying the use a query to modify some data and append the modified data to an existing table. The source table has forty some field. The destination...

Thanks Daryl, I changed the SQL and it works. -- mmk "Daryl S" wrote: MKuria -

Hi Duane, Thanks for your reply. I have been trying to get this to work for a few days without success so I have broken it down to a simple problem. I have a 3...

I'm trying to open Two reports with one command button. But everytime I click the command button it goes to the report2. How can I open report1 click until I...

I am trying to run this pass-through insert query but everytime I try I keep getting ODBC connection Failed and then when I click OK I get an Oracle error ...

I have query that has the following fields: Date Revenue Source 1 Revenue Source 2 Revenue Source 3 Total_Revenue Status Booking_Type FiscalPeriod