Hello, I have a table with 181 fields and I have the following select query: "Select * from Table1 where = and =;" This query works fine for sometime and then...

Bellow is my query. It gives me the result it is supposed to give me which is each customer has 7 records because I have 7 months in the system. But when...

need help to fix the SQL querry. this querry shows perticular inventory of a specified month and year. the result it shows is also correct. but the problem...

I am using Office 2003 on Windows XP. I am trying to run a make table query against an Oracle DB into Access. The following line is causing the...

Help! For some reason one of my forms has stopped working in that I can't change any values in the fields The status bar says "The recordset is...

I have a db that I make several data manipulations on (delete, insert, updates, etc). The database is large ( 1GB) and I constantly make updates to tables...

We have a table that saves meter readings and dates. We need to calculate latest useage ( MINUS ). Dmax function will return the latest reading, but how can...

I have a query that Ken Snell helped me with. It detects missing dates in my employee timesheet db. My query has a field of form tbl "Q", a field of where...

Is there a way (running a query, macro etc) to combine all data from one field (different records) into one different field. Example we have 500 records. ...

I have a saved query object with a replace function embedded in it (update xx set xx=replace(xx,'|','EOR'). This query works in several different...

I am using Office 2003 on Windows XP. I am using ADO combined with JET. Is this the most current provider to use? Microsoft.Jet.OLEDB.4.0 Could someone...

I have a field called categories. In this field there are 8 categories. Some records have more than one catergory. Is there any way I can use a combo box to be...

Hi there, I have a report that shows impression reads for two consequetive months. I am looking for a way to alter my query to allow me to see all devices...

So after reading documenation and Usenet help replies this morning I have concluded that the IIf function in Access is not going to help with my current...

I am working on a web application for a company that uses an existing company database. I just found out before the long weekend that a couple hundred of the...

I have a dilemma with a multi-level BOM which has plagued me for months. I use linked tables which are in a data warehouse which I have no control over so the...

Hi Folks, I'm looking for some advice please. I have an orders table and a inventory table - one to many. When the items in the inventory table are received...

I have a query with the following fields: dateA, dateB, dateC, dateE, dateF 1/1/05, , 2/1/05, 6/15/05, 12/5/04 , ...

Hi Access Profs, I create a report which has a stored procedure as control source. To select the right record for the report, the ID of the active record...

I have a list of clients all with dates of birth. I can create a querry that will calculate their exact ages fine but I want to analysis this in a chart...