Click here to Skip to main content
15,916,318 members
Home / Discussions / Database
   

Database

 
AnswerRe: Problem with Decimal Places and Rounding off Pin
Kornfeld Eliyahu Peter10-Aug-14 0:00
professionalKornfeld Eliyahu Peter10-Aug-14 0:00 
GeneralRe: Problem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd10-Aug-14 1:28
professionalVimalsoft(Pty) Ltd10-Aug-14 1:28 
QuestionSelect and Update Pin
jkirkerx8-Aug-14 11:43
professionaljkirkerx8-Aug-14 11:43 
AnswerMy none soup version Pin
jkirkerx8-Aug-14 12:11
professionaljkirkerx8-Aug-14 12:11 
AnswerRe: Select and Update Pin
PIEBALDconsult8-Aug-14 20:57
mvePIEBALDconsult8-Aug-14 20:57 
Answer[Solved] Pin
jkirkerx10-Aug-14 12:50
professionaljkirkerx10-Aug-14 12:50 
AnswerRe: Select and Update Pin
MeutherOlaf11-Aug-14 20:36
MeutherOlaf11-Aug-14 20:36 
QuestionWeird problem with UNION query in Access 2010 Pin
Peter R. Fletcher8-Aug-14 3:46
Peter R. Fletcher8-Aug-14 3:46 
I have created a UNION query as the source for a report that is written to a Word Document using VBA. The UNION joins a Table (historical information from before the current database Application was written) and the output of a Query that extracts corresponding information from the live data. I have recently added a new text field to both 'sides'. The value of the text field for the Query (either "S" or "") is generated in an IIF() statement within it.

When I Open the UNION query via the Access interface, it works as intended - the new text field is set to the correct value for records derived from either source. When I open a ADO Recordset based on the UNION query in VBA, the records derived from the Table are correct, but the contents of the new field in the records derived from the Query is always a Null String (N.B. not Null). If I convert the Query which is the second source of the UNION into a Make Table Query, run it, and then UNION the two Tables, everything again works as it should. Does this make any sense to anyone?
QuestionFind the right SSMS Pin
Corporal Agarn8-Aug-14 1:53
professionalCorporal Agarn8-Aug-14 1:53 
AnswerRe: Find the right SSMS Pin
Richard Deeming8-Aug-14 2:18
mveRichard Deeming8-Aug-14 2:18 
GeneralRe: Find the right SSMS Pin
Corporal Agarn8-Aug-14 2:25
professionalCorporal Agarn8-Aug-14 2:25 
Questionsql server insert into select + in select part if else Pin
Karan_TN7-Aug-14 0:16
Karan_TN7-Aug-14 0:16 
AnswerRe: sql server insert into select + in select part if else Pin
Mycroft Holmes7-Aug-14 0:55
professionalMycroft Holmes7-Aug-14 0:55 
QuestionHow to change multiple date formats in Sql server Pin
AzeeM_R6-Aug-14 2:51
professionalAzeeM_R6-Aug-14 2:51 
AnswerRe: How to change multiple date formats in Sql server Pin
Corporal Agarn6-Aug-14 3:38
professionalCorporal Agarn6-Aug-14 3:38 
AnswerRe: How to change multiple date formats in Sql server Pin
Richard Deeming6-Aug-14 3:50
mveRichard Deeming6-Aug-14 3:50 
AnswerRe: How to change multiple date formats in Sql server Pin
Mycroft Holmes6-Aug-14 14:16
professionalMycroft Holmes6-Aug-14 14:16 
SuggestionRe: How to change multiple date formats in Sql server Pin
AzeeM_R11-Aug-14 8:14
professionalAzeeM_R11-Aug-14 8:14 
QuestionHandling Duplicate records Pin
Ambertje5-Aug-14 4:35
Ambertje5-Aug-14 4:35 
Questionsplit datatable column using c# Pin
Jaimin H. Soni4-Aug-14 22:31
Jaimin H. Soni4-Aug-14 22:31 
QuestionRe: split datatable column using c# Pin
Eddy Vluggen5-Aug-14 2:35
professionalEddy Vluggen5-Aug-14 2:35 
AnswerRe: split datatable column using c# Pin
Jaimin H. Soni6-Aug-14 1:12
Jaimin H. Soni6-Aug-14 1:12 
GeneralRe: split datatable column using c# Pin
Eddy Vluggen6-Aug-14 1:56
professionalEddy Vluggen6-Aug-14 1:56 
GeneralRe: split datatable column using c# Pin
Jaimin H. Soni6-Aug-14 2:00
Jaimin H. Soni6-Aug-14 2:00 
GeneralRe: split datatable column using c# Pin
Eddy Vluggen6-Aug-14 2:30
professionalEddy Vluggen6-Aug-14 2:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.