进行中

Access 2016 SQL statement

In access 2016 I have several tabels i want to present - depending on the current date.

So one table (Budget) holds Budget costs for Jan, Feb, Mar, Apr, Maj, Jun, Jul, Aug, Sep, Okt, Nov, Dec

The other table (Used)holds actual used for Jan, Feb, Mar, Apr, Maj, Jun, Jul, Aug, Sep, Okt, Nov, Dec

I would like to be able to run a query so depending on the date it will first show Budget cost for each month - but as the month goes by it will show actual used.

技能: 微软Access, 微软 SQL 服务器, SQL

查看更多: sql view in access 2016, ms access sql syntax reference, where to write sql in access, how to use sql in access 2016, access sql query examples, access sql tutorial, ms access sql pdf, sql view access 2010, goto statement in pl sql, decode statement in sql server, looking for a computer programmer in devon with access and sql databases, convert access 2007 query run sql express, access filter sql apply query, write sql statement, decimal places oracle sql statement

关于此雇主:
( 0个评论 ) Denmark

项目ID: #16254891

授予:

crazynightwalker

Hi! I can help you with writing the SQL query that does exactly as you described, using Access 2016. I am ready to start now!

$25 USD 在1天内
(4条评论)
2.0

7 威客就此工作平均出价 $34

zu02

Hello, sir I saw your project and analyze your requirements. I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before. I am senior Access/SQL/VB /Excel de 更多

$55USD 在1天里
(40条评论)
6.0
Agiletechstudio

Hello sir i read your initial requirements and i have some question regarding to your database project. Sir can we discuss it?

$25USD 在1天里
(2条评论)
2.9
rarruda1988

I currently work with Business Intelligence, where my job is to turn data into information and presentations into reports and Dashboards. Work with information on the use of ETL, where I treat data from various source 更多

$25 USD 在10天内
(0条评论)
0.0
shiboi

i can develop query that you want if you send me the sample data or table structure. i am an expert on database queries

$30USD 在1天里
(0条评论)
0.0
$45 USD 在0天内
(0条评论)
0.0
$30USD 在1天里
(0条评论)
0.0