ms access output query

[kurokotoque]

---

pwd ko magpatabang kon unsa ang sql query kon mao ni ang sulod sa table nako?

Location Date Name Total_Sales
Cebu 1/15/2010 Branch1 3,337.20
Cebu 1/15/2010 Branch2 2,294.10
Cebu 1/13/2010 Branch3 2,202.30
Cebu 1/13/2010 Branch4 2,829.60
Cebu 12/30/2009 Branch1 2,029.50
Cebu 12/30/2009 Branch2 2,669.40
Cebu 12/29/2009 Branch3 931.50
Cebu 12/29/2009 Branch4 2,746.80


dayon ang output nga format kay:

Location Date Branch1 Branch2 Branch3 Branch4
Cebu 1/15/2010 3,337.20 2,294 0 0
Cebu 1/13/2010 0 0 2,202.30 2,829.60
Cebu 12/30/2009 2,029.50 2,669.40 0 0
Cebu 12/29/2009 0 0 931.50 2,746.80

kaya ba kaha ni sa ms access kon kani ang gigusto nga output?

sori diay kon ing-ani ang presentation.

[dodie]

The rest ok. you can do whatever you like. The issue is you have problem with DATA formats and data tyes.

I totally forgot about MSACCESS, i worked with it long time ago, so let's reflect this to another DATABASE, which you can relate by the way......

If you are using MYSQL,
DATE format should be YYYY-MM-DD
DATETIME format should be YYYY-MM-DD HH:MM:SS

with function you're output should be
date("m/d/Y", timestamp_equivalent_converstion ); <-- it depends on the language you're using , ignore the syntax.

With numeric, you must use DECIMAL datatype, your output should be formated with commas and decimal point.
You are using MSACCESS, know the DATATYPES that it requires.

And for the presentation or records by your number of columns, if you are sure about it, then give it a try. It's part of learning to dynamically process with your records. Don't forget NORMALIZATION techniques.


cheers!!

[MarkCuering]

pwd ko magpatabang kon unsa ang sql query kon mao ni ang sulod sa table nako?

Location Date Name Total_Sales
Cebu 1/15/2010 Branch1 3,337.20
Cebu 1/15/2010 Branch2 2,294.10
Cebu 1/13/2010 Branch3 2,202.30
Cebu 1/13/2010 Branch4 2,829.60
Cebu 12/30/2009 Branch1 2,029.50
Cebu 12/30/2009 Branch2 2,669.40
Cebu 12/29/2009 Branch3 931.50
Cebu 12/29/2009 Branch4 2,746.80


dayon ang output nga format kay:

Location Date Branch1 Branch2 Branch3 Branch4
Cebu 1/15/2010 3,337.20 2,294 0 0
Cebu 1/13/2010 0 0 2,202.30 2,829.60
Cebu 12/30/2009 2,029.50 2,669.40 0 0
Cebu 12/29/2009 0 0 931.50 2,746.80

kaya ba kaha ni sa ms access kon kani ang gigusto nga output?

sori diay kon ing-ani ang presentation.

just simply use QUERY WIZARD together with QUERY DESIGN...zzzZZz

[kurokotoque]

pwd ba sa query nga isagol ang 'field name' hasta ang 'field value'?kay ang 'location' ug 'date' kay field name man dayon ang 'branch1', 'branch2', 'branch3' ug 'branch4' kay mga field value man...posible kaha ni?