Search Result

ariful alam · Jun 19 '12, 07:38 PM

Hello,

I have a ms access table named transaction. The fields are:
trans_id,
trans_date,
product,
storage,
received,
issued

Now, i want to create a select query that include all the columns mentioned above, plus two more columns named,
Opening_balance and Ending_balance in the query.

Opening_balance should contain previous row's Ending_balance column value...

emilyjac · May 24 '12, 06:39 PM

Hi.

I have a function that produces some temporary queries. I create the queries instead of just executing from VB because I need one temp query to depend on another temp query. All the queries are named "rqt_tmp_someth ing" and once I'm done with them I run this handy procedure to find and delete them.
This one query called "rqt_tmp_pop_gr p_struc_distinc t" doesn't delete.
I have noticed while watching...

mrdatabase1 · Apr 29 '12, 11:16 AM

I have this query and it works fine however i need the query to display the forename and surname and currently it only displays the max value of the sum it performs

Does anybody know what i can do?

Thanks

Code:

SELECT MAX(Intermediate.Total_Amount_Of_Likes) AS Total_Amount_Of_Likes
FROM (
SELECT Forename, Surname, Sum(Likes) AS Total_Amount_Of_Likes
FROM Instructors, Exercise_Class_Type, Exercise_Class_Staff,

...

sg2808 · Apr 27 '12, 10:13 AM

Hello,

I will give a simple example. I have a table [RuleMap]. It has a field called [Rulename] and[Ruletype]. [Ruletype] has entries like Handbook, Guidance and Legislation. Some of the records do not have the [Ruletype] mentioned against [Rulename].

I have designed a query in the Query design view. I do not want to see the [Rulename] where [Ruletype] is Legislation. I have used "<> Legislation" in...

bbaaking · Apr 19 '12, 02:57 AM

Hi,

I have be in trouble for 2 weeks, hope some nice people can help me.

Background:Ther e are some technical service data (ServiceID, TCID, EndTime, and QoS) submitted by client in a whole year about technical support, and there are a unique primary key (ID by name) because there are some duplicates. I must use one single query statement(not insert/delete/update, and not stored procedure) to process a computation,...

Merlyn · Mar 16 '12, 09:05 AM

Hi,

I have a form with a subform. On the subform a combobox is shown. It contains over 500 items. I want to offer the users to find results containing the entered letters. (Eg. when entering "for", the results "effort", "ford" and "therefore" should be shown).

So in the properties of the combobox I use this as the rowsource:

Code:

SELECT tblOnderwerp.*, tblOnderwerp.Onderwerp

...

edwardcga · Mar 11 '12, 04:11 AM

I am trying to write a query to extract product sales data. Columns are product code, qty, current month sales, ytd sales for current year and comparative number for last year. How do I write the query to pull data for current year and comparative period for last year. I will have a pararameter for user to enter the month end date e.g Mar 31, 2012 as 03/31/2012.
Also, anyone can show me what criteria should be for Month to date and year...

David123 · Mar 5 '12, 05:25 PM

Good Afternoon Ladies and Gentlemen of this forum, I had a question for all of you.

I am trying to write a query. The idea of the query is showing when a person needs a new appointment. I now have a query which gives the Last Name, the first date they visited, and a so called 'visit number'.

The visits follow a set pattern. The second appointment is always 10 days after the first one. Then, the third appointment is 2...

jimmcd · Mar 2 '12, 06:46 AM

i need an access query to combine the lithologies to only have one dpeth from and to for each interval. should look like this
ID Bore Depth1 Depth2 Lithology
96 DDH_1 0 14.48 OOO
100 DDH_1 14.48 22.56 USE
103 DDH_1 22.56 25.6 WOO
105 DDH_1 25.6 30.18 USE
106 DDH_1 30.18 34.75 UOO

with min max querry the USE will go from 14.8 to 30.18 overlapping with the WOO type

but currently...

Rugbykorn · Mar 1 '12, 11:14 PM

Hi,

I have 11 tables each with a large data set. I then have have one query for each of the 11 tables (11 queries) that pulls the person ID and the data effective date for each line in the respective tables, using a <= prompt criteria.

This results in a reduced data set showing all of the records that started on or before the prompt date. For each of these 11 queries I then created a new query that pulls the maximum...

Yannt · Feb 24 '12, 12:26 AM

I'm stuck into something I thought would have been easier that this....

I've got 2 tables
1. tblClubs (clubID, ClubName)
2. tblTrainingSess ions (sessionID, ClubID, Weekday)
Note: Weekday is the day number (Mon=1, Tue=2, etc).

I need to create a roll for each club.

i.e. Club Alpha has training sessions on every Tue and Fri. I need to generate the following report (1st day is a parameter...

zemsiz · Feb 8 '12, 04:29 PM

is there anyone to answer this?

Hello to everyone..

i upload a theme to my wordpress. but a section isn't working correctly,

i get that fatal error: Fatal error: Call to undefined function dt_parents_wher e_query() in /xxx/xxxxx/public_html/anasayfa/wp-content/themes/xxxxxx/front-gal-plus.php on line 22

and the codes are below:

Code:

<?php
$box_name = 'homeslider';
$images

...

maff811 · Jan 30 '12, 12:12 PM

Hi there,

I have a small database in MS Access that is causing me some issues.

I have a Main Form "A" which has a number of Subforms "B", "C", etc.

Main Form A has 'autonumber' as the unique identifer for each record, whereas subforms B, C etc have their primary key as simply 'number'. These fields are linked.

I am able to show records for each subform that...

Isabella · Jan 28 '12, 06:58 PM

I'm making shopping cart, and I have s problem displaying the products. Here's a part of the code where I think the problem is. I'm using xampp. Is something wrong with the query? Please help, Thanks

Code:

<table border="0" cellpadding="2px" width="600px">
		<?
			$result=mysql_query("select * from products");
			while($row=mysql_fetch_array($result)){
		?>

...

Reboot · Jan 12 '12, 05:59 AM

Hi!

I have this php code which looks like this:

Code:

$sql = ......
$result = mysql_query($sql,$connection)
or die("Couldn't execute SELECT query");
 
while ($row = mysql_fetch_array($result)) {
......
}

What i want to do is be able to read the next row in the query. So for example:

Code:

while ($row = mysql_fetch_array($result)) {
......

...

Search Result

using previous row's closing column in current row's opening column in Access 2007

cannot find action ou select distinct queries

I Can't select the fields i need in the query result!

How To Show All Other Records When Using A Critieria In Query Design?

complicated SQL:how to using a query to compute rank of order(Outstanding of Class 1)

Searching results in Combobox in subform with 'Like'

column for month todate, year todate and comparative number from last year

Conversion Query

access query to show min max for overlapping intervals

Many queries feeding into one big query runs very slowly.

Query Nightmare

Call to undefined function _parent_where_query() in

No data shows when I run a query

What is wrong with this code?

How to read next row in a mySql Query