Search results

The access database includes 9 tables. i'm trying to complete part B, question SM3 and PO... so question 3rd and 4th of part B. Question SM1 ( query SM1.png ) of part B, allows me to know what product must be ordered and how much (so the starting point), but it does not tell: - Who is the...

Well, this is clearly written in the PDF in the ZIP file. Data are in the database and the result of product we have to order returns the data in screenshot Query SM1. and then we should get for SM3 what i partially got (see both query SM3 screenshots) except that for NTB0001 we should have...

Hi Plog, You have attached file with the whole documentation and database. i'm trying to complete part B) question SM3 according to business rules described in part B) If you have any question just let me know. thx.

this select can return several matching records. SELECT s.s_prod_code,s.s_manu_code, s.prod_cost, s.supp_stock FROM supplier_prod AS s,[SM1 Query] AS [Prod2Buy] WHERE s.s_prod_code=[Prod2Buy].[Product Code] ORDER BY prod_cost ASC) and in this case, the master select can have several records...

Hi, i'm trying to refer to previous record in a query and i'm stuck as i do not know how to do it. Here is my query: SELECT [Prod2Buy].[Product Code], IIF([Missing] IS NULL,0,[Prod2Buy].[Quantity To Order]-[To Order]) AS [Rest To Order], s.s_manu_code AS [Manufacturer Code], s.prod_cost...

Here is the exercise text: Procurement manager, Bob, wants to generate procurement orders for the suppliers. These procurement orders will be based on the available data and the business rules. Upon further investigations, we have found out the complete set of business rules: Business Rules ●...

The problem is that i do not use any Form, or report. and as far as i understood the exercise text, i had to do it using only queries... and sub-queries

Ok so to make you understand a little bit better. Here is the result of my previous Query: http://prntscr.com/6m0hin so you can see what are the product code to order, their respective quantity and if they are promotional or not. and this is the supplier/manufacturer prod table...

in the query you wrote, it request a manual field parameter that i do not use unfortunately.

except the random freezing at the boot without any solution, i have no issue with win8.1

Hi, i'm looking for a great forum about angularjs except the google group. Any idea ? thx

Hello, i was wondering if someone has the same issue as me. sometimes and without any reason, Win8.1 freeze at boot, while seeing the blue/green windows logo. I checked in the windows event logs but i saw nothing special. thx.

So if it is impossible, how could it be using VBA and queries ?

I have to use only queries, no VBA :(

Hi, I have a SQL Query that returns me: - the "product code" i must purchase, - the "quantity" to purchase for this product - and if it's in "promotion or not". Based on this result, i must to look at "manufacturer" table and find the cheapest "price" for each product to purchase and the...

Hello, it's been a long time since i did some SQL queries on MS Access, but i forgot how to do to return a text for each row (as field value) when a table field contains "1" as value ? for example i have a table named "products" with a field/column called "promotion". Sometime a product is...

Hi, i'm looking for a free grid control... i know that iGrid exists but they ask $225 as license fee. thnx

Hi, i have 2 tables (clients, frequencies) where in table "clients" i have a column to store ID of "frequencies" table (id, description). in my form "FClient" i display data stored in table "clients" and i have a combobox that should display the "frequencies" descriptions, but with a frequency...