Split data in single field in a table to 2 fields using queries.

[Guest]

Hi All,
I have a large database with tables, queries and macros.My task is I have a
table with the following format.I am writting only the relevant fields which
I have to split.

ID FItGap ID Localisation Type Max SLA SLA status Actual Res days
corrected
Fit01 Fit01 Local 20 ok 35
Fit02 Fit02 Global 15 nok 12
Fit03 Fit03 Local 25 nok 15
Fit04 Fit04 Global 30 ok 30
....
....
....Like this we have some 20,000-30,000 records.
Now I have to split fields in this table to Local and Global seperately so
that Local
and Global data r shown seperately using queries.Like:-

MaxSLA-------MaxSLA_Local,Max_SLA_Global.

Actual_Resolution_days -----Actaul_Resolution_days_Local , and
Actual_Resolution_Days_Global.

Actual_Days_corrected,------Actual_Days_corrected_Local, and
Actual_Days_corrected_Global.

SLA_Status.-----SLA_status_local, SLA_status_global_----OK/NOK.

So could anyone please help me in solving this issue.Basically how should I
distribute data using queries between these local and global fields.

Thank you in advance.

 

[Jeff Boyce]

Tina

I'm not sure I understand what you are trying to do.

If you are saying that you want one list of "local" rows and another list of
"global" rows, you can do that with different approaches using queries.

One approach would be to design a new query and put "local" in the criterion
under the relevant field (and a second query with "global" as the
criterion).

A second approach would be to leave out the criterion, but sort by the
[Localization] field.

Another approach would be to create a new query and "group by" the
[Localization] field, which would generate one list, but grouped in "local"
and "global".

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Thank you Jeff Boyce ,I got the result.

Thank you once again.