Click here to Skip to main content
16,021,112 members
Home / Discussions / Database
   

Database

 
GeneralRe: Get Max Number for each department Pin
SatyaKeerthi1521-Jul-10 20:28
SatyaKeerthi1521-Jul-10 20:28 
GeneralRe: Get Max Number for each department Pin
Mycroft Holmes21-Jul-10 20:56
professionalMycroft Holmes21-Jul-10 20:56 
GeneralRe: Get Max Number for each department Pin
Goutam Patra21-Jul-10 20:32
professionalGoutam Patra21-Jul-10 20:32 
GeneralRe: Get Max Number for each department Pin
Luc Pattyn21-Jul-10 20:36
sitebuilderLuc Pattyn21-Jul-10 20:36 
QuestionAccess Form - datasheet view, which OnEvent Pin
john john mackey21-Jul-10 11:22
john john mackey21-Jul-10 11:22 
AnswerRe: Access Form - datasheet view, which OnEvent Pin
David Mujica22-Jul-10 2:46
David Mujica22-Jul-10 2:46 
GeneralRe: Access Form - datasheet view, which OnEvent Pin
john john mackey22-Jul-10 10:51
john john mackey22-Jul-10 10:51 
GeneralRe: Access Form - datasheet view, which OnEvent Pin
David Mujica23-Jul-10 4:29
David Mujica23-Jul-10 4:29 
Ah ha. I think I see what you are doing.

How about this ...

When you are building your dataset with a query, add a column where you can calculate a value you want displayed.

For example:

SELECT Payroll.WKNum, IIf([wkNum] Mod 2=0,"Even","Odd") AS OddEven
FROM Payroll;

This query displays the Payroll Week Number and a Text value of "Even or Odd"

This would free the DataSheet View from having to do any logic processing on the dataset, it would just display it.

If you need more complex logic, maybe you could extend this by manipulate a temporary table, then display that contents.

Give it a shot.
Cool | :cool:
QuestionT-SQL Address line Packing Pin
Pascal Ganaye20-Jul-10 1:24
Pascal Ganaye20-Jul-10 1:24 
AnswerRe: T-SQL Address line Packing Pin
Goutam Patra20-Jul-10 3:16
professionalGoutam Patra20-Jul-10 3:16 
GeneralRe: T-SQL Address line Packing Pin
Pascal Ganaye20-Jul-10 3:28
Pascal Ganaye20-Jul-10 3:28 
GeneralRe: T-SQL Address line Packing Pin
Goutam Patra20-Jul-10 3:31
professionalGoutam Patra20-Jul-10 3:31 
GeneralRe: T-SQL Address line Packing Pin
Mycroft Holmes20-Jul-10 12:16
professionalMycroft Holmes20-Jul-10 12:16 
AnswerRe: T-SQL Address line Packing Pin
Luc Pattyn20-Jul-10 12:43
sitebuilderLuc Pattyn20-Jul-10 12:43 
QuestionHow to retrieve binary file from Sql Server database to hard disk using SQL? Pin
Ahmad Safwat18-Jul-10 5:29
Ahmad Safwat18-Jul-10 5:29 
AnswerRe: How to retrieve binary file from Sql Server database to hard disk using SQL? Pin
Ahmad Safwat19-Jul-10 1:25
Ahmad Safwat19-Jul-10 1:25 
AnswerRe: How to retrieve binary file from Sql Server database to hard disk using SQL? Pin
PIEBALDconsult19-Jul-10 3:59
mvePIEBALDconsult19-Jul-10 3:59 
GeneralRe: How to retrieve binary file from Sql Server database to hard disk using SQL? Pin
Luc Pattyn19-Jul-10 4:40
sitebuilderLuc Pattyn19-Jul-10 4:40 
GeneralRe: How to retrieve binary file from Sql Server database to hard disk using SQL? Pin
PIEBALDconsult19-Jul-10 4:58
mvePIEBALDconsult19-Jul-10 4:58 
GeneralRe: How to retrieve binary file from Sql Server database to hard disk using SQL? Pin
Luc Pattyn19-Jul-10 5:19
sitebuilderLuc Pattyn19-Jul-10 5:19 
QuestionCreate a virtual table for form RecordSource Pin
john john mackey16-Jul-10 7:09
john john mackey16-Jul-10 7:09 
AnswerRe: Create a virtual table for form RecordSource Pin
Mycroft Holmes16-Jul-10 12:07
professionalMycroft Holmes16-Jul-10 12:07 
GeneralRe: Create a virtual table for form RecordSource Pin
Goutam Patra16-Jul-10 19:57
professionalGoutam Patra16-Jul-10 19:57 
GeneralRe: Create a virtual table for form RecordSource Pin
john john mackey19-Jul-10 9:47
john john mackey19-Jul-10 9:47 
GeneralRe: Create a virtual table for form RecordSource Pin
john john mackey19-Jul-10 9:48
john john mackey19-Jul-10 9:48 

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.