473,320 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to get value in query if you have these condition

215 128KB
I have 2 table join on ID field.
to be ez to understand, that ID only have 1 item 1
and I won't show it on table

how to get Listprice value after calculate pricechange as I need on this image:



is it possible to get value of item ID 1 between the date given with condition like image ?
Attached Images
File Type: jpg P_20151008_122425.jpg (49.4 KB, 157 views)
Oct 8 '15 #1
2 872
Seth Schrock
2,965 Expert 2GB
I can't figure out what you are asking and the picture doesn't make anything any clearer as I don't see a condition in your image. You can join two tables using two fields such as
Expand|Select|Wrap|Line Numbers
  1. FROM Table2 INNER JOIN Table1
  2. ON Table2.Date >= Table1.From And Table2.Date <=Table1.To
Does this help?
Oct 10 '15 #2
hvsummer
215 128KB
Thank Seth, I've posted too much post and forgot to mention that I resolve this by 2 join like your answer, and group by sum since that's Many-to-many relationship.
Oct 11 '15 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: gudia | last post by:
Two tables: T1 (c1 int, TestVal numeric(18,2), ResultFactor numeric(18,2))--c1 is the primary key. T2 (x1 int, FromVal numeric(18,2), ToVal numeric(18,2), Factor numeric(18,2))--x1 is the...
4
by: Alexandre Jaquet | last post by:
Hi, I'm looking for the shortest way to write : if (form.interface_template.options.length > 0) { template = form.interface_template.options.value } else { template = ''
2
by: JMCN | last post by:
hi i have a general question regarding append queries in access 97. each week i need to update my table(tblonlinereg) with new or modified records. firstly, i import the text file into my...
3
by: thomas goodwin | last post by:
I have a query which asks for a parameter value to execute it. To see the results I have to: a) click on the query -- the "Enter Parameter Value" window pops up. b) enter the parameter value c)...
1
by: son | last post by:
i need some help with my database i'v got a qyery with a field orderdate from a table orders with a condition date, when a user opens a rapport from this query a popupbox is asking for the date of...
3
by: vstolmech513 | last post by:
Here goes nothing... I'm trying to make a report that shows what guys work on what crew, ie. day crew or night crew. For this selection I've got a form with a combo box with either a "D" or "N"...
4
natalie99
by: natalie99 | last post by:
Hi All :) I am trying to stipulate rules for the return of a pricing value in Access. I know this should be very easy, I simply cannot seem to make my expressions work! The two tables have...
2
by: de_ja | last post by:
Hi, If, for example an access database that concerns insurance claim investigations. The database comprises only one table containing data - investigation reference number, referral date,...
3
by: lakshmikant | last post by:
I have a file ------------------------------------------------------------------ Port Speed Duplex Flow Ctrl Link Name ---- ----- -------- --TX-----RX-- ------ ------ 1 10000 full no no down 1 ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.