Search results

In on hand field paste this expression =[Products Subform].[Form]![UnitsOnHand]-nz(DSum("[QuauntityOut]","IntStockControl","Forms!Products.[ProductID] = [IntStockControl]![ProductID] and isnull([IntStockControl]![DateIn]) = true "))

:) No ... left join doesn't say that you are looking for unmatched records but this does WHERE (((av.name) Is Null)); You are able to pull the columns from both table it just the fact that there nothing in this columns to show ( I mean av table ) Simply remove the criterion.

Table2 - Names Table3 - commitee member Table4 - event member SELECT Table2.First_Name, Table2.Last_Name, Count(Table3.Nameid) AS x, Count(Table4.Nameid) AS y, Count(table3.nameid)+Count(table4.nameid) AS Total FROM (Table2 LEFT JOIN Table3 ON Table2.First_Name = Table3.Nameid) LEFT JOIN Table4...

You can use something like this Private Sub locid_DblClick(Cancel As Integer) DoCmd.OpenForm "yourformname", , , "[Flockid]=" & "'" & Me![locid] & "'" End Sub

First please define the term period : is it a quarter, month, year. If the data is structured like this: Name Period Amount AAA Period1 100 BBB Period2 100 AAA Period2 100 to show the raw numbers you can use a crosstab query, the result query will show you : Name Period1 Period2 aaa...

Can you post the SQL of this query?

:) Your query name is the answer to your question. Master without matching AV That means: "show me the records from Master table which don't have related records in AV table". Surely if you select any field from av table it would be blank.

Try to post your db.

First I suspect that your db design is wrong, but anyways: If your table is structured only (!) the way you showed in example then you need to 1. create a query of your tbl1 with SQL like this, call it query2 SELECT "Total:" AS Total, Sum(tbl1.Jan) AS Jan, Sum(tbl1.Feb) AS Feb, Sum(tbl1.Mar)...

There is a number of ways of doing what you said: First there is no way of making access an html page ( as far as I know ) but you can make look like it. Good example of simuliting the web interface would be http://www.mvps.org/access/resources/downloads.htm Download The Access Web (Access 2000)

Oops my fault ... it deletes only one record Hmmm.

I was confused with this part of the code at the beginning " If IsNull(Me.cboTraining) Then MsgBox "No Class selected...", vbExclamation Exit Sub End If " but then I thought that this part was check by joslinmk and there is some combo box that returns proper values so I remarked it, and it...

I don't know but you code works absolutely fine. What was the question then ?

Can you post your db ?

Create five ubound fields in the header of your form. The fields where the information from the ubound fields will go make invisible. In the properties of the invisible now fields set the DEFAULT VALUE = YourUnboundFieldNames In the properties of your unbound fields "ON CHANGE" add code...

I didn't understand the "interpolation" part of your message. Am I correct in the following?: Result 1 Volume*Filling = 300 Result 2 from SOUNDING: Exact value = 300, XCoGlo = 1.3 Lower values = 298,297,296 ;XCoGlo values 1.2 , 1.1 , 1.0 Higher values = 301,302,303 ;XCoGlo values 1.4 , 1.5 ...

:) Not simple but doable

Being frank I don't know why it keeps giving you a hard time. Try to pass the parameters value 3 Values for the pole fields are the values from the ID field in tblspisok It works absolutely fine for me. May be gurus from the forum may have an answer.

You were lucky that your code didn't work :) It would delete the records instead of updating the field. Anyway slightly modified code: If Response = vbYes Then sSQL = "Update tblAddress set chkPrimary = false WHERE anCandID = " & anCandID & ";" Docmd.runSql sSQL Me.chkPrimary = True...

Lets say you have 3 tables : Science, Students , Classes. Each of the student is supposed to learn every science. Classes holds information who studies what. 1. Create query with 2 tables science and students. Do not link them. Select ScienceID and Studentid as output fields of this query. 2...