Filtering data right at the start

[Joshua Mills]

i my data base i have a entries for when people arrived and what there visit was classed as (there are like 4 types)



i am trying to create a stacked area graph of the differnt visit classes each day but within the query i cant seem to workout how to
get data looking something like

date | class 1 |class 2 |class 2|
19/7/22| 1 | 2 | 3
..... .... ... ....

any help would be very much appreciated

Josh

[xps35]

Maybe with a crosstab query?

[Joshua Mills]

i am not shore i see how that would solve this problem but i am pretty inexperienced in access

[mike60smart]

Upload your database so we can see the table structures.

[Joshua Mills]

i cant really do that doe to GDPR

but here is a screen shot of a couple of entries. would that suffice

[Welshgasman]

You need to show how your data is stored, normalized or not normalized.

[Welshgasman]

Group by date, category and count category.

[Welshgasman]

i cant really do that doe to GDPR

but here is a screen shot of a couple of entries. would that suffice

Data structures are hardly GDPR compliant?

Jeez, everyone uses GDPR as an excuse for everything these days.

[Joshua Mills]

but that gives data like this
how would i the maked a stacked area graph of each day

I believe it is in UNF

[Joshua Mills]

the database has things like people phone numbers postcodes and that kind of thing.
some of that data is for vips thus i cant post it online

[Welshgasman]

the database has things like people phone numbers postcodes and that kind of thing.
some of that data is for vips thus i cant post it online

Yes I understand that, but all that was requested was the structures. That pretty much determines how to get the data as you want it.
I have never played around with graphs in Access, but the key here is getting the data correct.

As mentioned, if you put that into a crosstab query, what does that show you?
I'd get rid of the blank entries, which I would have thought should not even exist?

I do not even have a stacked area graph option in 2007.

Edit: Certainly seems like there are more than 4 category types?

[Joshua Mills]

that works thank you.

i also didnt know you could upload a database without the data in it.

the blank entries are a common thing in this database the people who use it tend to mange to break stuff

thank you very much for your help

[Welshgasman]

that works thank you.

i also didnt know you could upload a database without the data in it.

the blank entries are a common thing in this database the people who use it tend to mange to break stuff

thank you very much for your help

A picture of your relationships would have been a start.

See this link for hiding your real data should you need to upload a db with data in the future.

https://www.accessforums.net/showthr...ight=randomize post #19