I am using the following query to create running balance at every change of Invoice Number but no luck, here Invoice Number is a text field SELECT...

Hi, I have a query in which I have fields TransactionID, AmountDeposit, AmountWithdraw I want to make an other field named Balance which shows diffrence of...

Hi All MVPs Could any MVP define & describe uses of all query types use by Ms Access which is Slect Query, Cross Tab Query, Update Query, Append Query,...

Hello all and please excuse me for the long post. I have the following tables in my databases: ,,, , with a common field name I want to have a query which...

I'm using this formula from the office help to calculate a birthdate: =DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format( , "mmdd") ) My fields...

I have an Access 2003 project connected to a 2000 SQL Server. All in-line functions that requires a parameter is not working by any user that got the windows...

Using an update query to count records for statistical analysis. The table has a field, Count, that has a 1 in each record. Thus trying to count the number of...

Hi, I'm new to MS Access and studies it through exploration and by reading Q&A's from Microsoft.com. I entered syntax query IIf(1,((+1)-)) in design view of...

I have table with two fields. One field is number and other one refrence codes. Number of rows for a given number varies. I want to convert table to a query...

Once relegated to the realm of national laboratories, supercomputers have started to move downstream. These days, any business with $25,000 to $100,000 to...

Hi! I am wondering if this query is possible somehow: I have a table with many fields that all can have a value from 1 to 5. if I wanna see the count of each...

Microsoft recently did its best to promote its Software Plus Services strategy at its S+S: The software giant’s chief executive officer, Steve Ballmer,...

Hi, I am opening a subform which basically writes to the same table as the form. What I want is I have a field in the form called DtRecd and one in...

I am facing a problem writing a query. The problem is I have a column with different formulas of chemical molecules. for eg CH3Cl CbF-(Cb2) CBF-(Ca) Now I...

Is there any way where I can query Adobe Acrobat 6.x from ITK showing if the object is Approved/Non-Approved and also take the Adobe Acrobat 6.x from Results...

I have 2 Tables: ITK and Results I have objects in ITK such as: Adobe Acrobat 6.x, Microsoft Office 2000. These Product names are split into 3 columns:...

I am a novice to Access : is it possible to sort a database of education establishments by creating a query that will find only schools containing the text...

I am working on a database for a client in MS Access 2003 - the way they handle their accounting is as follows: Invoices are Generated Debit May be Generated...

I created a query using the IIF function and although it gives all the correct answers, it only does so if I enter the parameter values. I have no need to...

Basically, I have a string in a query (used as rowsource for a list box). I've pared it down to try to find the error. Right now, I've got: --- Outgoing...