![]() I am trying to check for fields that have missing foreign keys in my ExpensItems table. Messagebox Number 3 was to show me the count which all added together came to 51. 7 Comments 3 Solutions 2003 Views Last Modified. Messagebox Number 2 Was to make sure all variables were set to 0 and to show which Quote Type I was querying Messagebox number 1 was to verify for me how many records total which was 43 ![]() You can use the Running Sum property of a textbox on a report to do all the work for you: 3. ![]() MsgBox "Quote Type = " & Rs1!QuoteTypeID & Chr(10) & Chr(13) & "Open = " & QOpen & Chr(10) & Chr(13) & "Lost = " & QLost & Chr(10) & Chr(13) & "Won = " & QWon & Chr(10) & Chr(13) & "Expired = " & QExpired & Chr(10) & Chr(13) & "Closed = " & QClosed If your objective is to generate a report, then you don’t want numbering to be a part of your query but rather a part of the report itself. Ok look at this and tell me what happened lol.
0 Comments
Leave a Reply. |