Search results

You make it sound so simple. :rolleyes: Ill get to reading up Thanks again, have a good weekend

That works a treat dude :D interesting to see how you can abbreviate and it will still understand. im gonna do some experimenting to understand it better. One last question regarding GROUP BY iif([Bin Size ID] in (6,7),67,[bin Size ID]) specifically 'iif' why the extra I? why not...

SELECT Bins.[Bin Size ID], Sum(Bins.Collections) AS TotalCollections FROM Bins GROUP BY Bins.[Bin Size ID] HAVING (((Bins.[Bin Size ID])=1)) OR (((Bins.[Bin Size ID])=2)) OR (((Bins.[Bin Size ID])=3)) OR (((Bins.[Bin Size ID])=4)) OR (((Bins.[Bin Size ID])=5)) OR (((Bins.[Bin Size ID])=6)) OR...

aaaaaand its that simple :eek: That works, I've not had any previous experience using group by queries, something ill look in to now. But just as a further question there are 14 total bin ID's and im only interested in 1-7 (and having 6+7) combined. would it be as simple as SELECT([Bin...

Hi all, I Have a database for bin collections and I need to know the total number of collections for each bin. The code below works and return the sum of all collections for all bins with a Size ID of 1. SELECT DISTINCT SUM (Collections) AS Total120 FROM Bins WHERE (((Bins.[Bin Size...

Oh damn a double cross :eek:

Much appreciated, tho the comment was written in sarcasm if no one could tell :D

The title says its all, how can you mere peasants call out such a work of art. It is clearly beyond all of you, future generations will remember your folly!

Damn I knew this would be my fault. Naw I was referring to businesses as people cause im special. Now we know :D

With regards to GDPR - I think ill change the name of the thread :D Under Article 5 paragraph 1 (purpose Limitation) of GDPR you must be clear in what you intend to use the data for and from then on it can only be used for this, unless you get consent, of have a clear basis in law. (there are...

I use a form, just the standard delete record button right now to remove data, this is always done one record at a time btw. I hear what your saying about the removal of data being bad on the whole but im subject to GDRP regulations with my work so once we no longer need the data we have to...

Just spitballing here. I have a database with records being added and removed frequently as people come and go. I was just wondering if there was a way of logging or keeping track of how many records are deleted without having to keep their associated data? Ideally I would want to have a...

Il have to do some research then, at the moment its not essential im more just tinkering out of curiosity and thought id see if anyone had any experience/ideas.

Also doc, yes it is functional as is but it isn't the most user friendly interface. Ideally I would want to add annotations and explanations, move relevant fields closer together i.e address. This isn't simply for my vanity but to make it on the whole a more user friendly experience.

Yes I navigate to external data --- Collect data --- create email.

A picture speaks a thousand words - LOL here you go. Is there any way to change the layout? it was created like I said using the wizard from the External data tab --- Collect data ----- create email. Ideas?

Hi all, im experimenting with collecting data via email. I have used the wizard to creat a functional email that dose what I need but I was wondering if there is a way to make it look.... better is probably the best word. All it is at the moment is a long list of the fields that I have...

Solved for any interested: The issue was with my structure. All the info I needed was there it just wasn't structured right and I was trying to use VBA to get around the issue. I have since restructured my database so that my Pricing popout shares a relationship with my Bin's subform...

Hi all its me again. Before posting this I have done a good bit of reading on the issue, even looking in to some of the older posts on this site but nothing seems to work this far. (Namely these posts/sites: https://access-programmers.co.uk/forums/showthread.php?t=195350...

Okey, ill do some more reading on the suggested. I wanna try solve it on my own just need prodding in the right direction. Thanks