Recent content by Pezzini

Well, been playing with this for a while, and the crosstabs worked for some of the answers, the problem was that for others there are so many options when I put them all together, there access tells me I've selected too many columns and can't run the query. But I can see how Crosstab queries...

Wow, Ranman256, I'm both impressed and horrified. I'm impressed you have an answer and horrified that I look at this code and understand nothing. It's not just that my vba is rusty, I'm not sure that I would ever have understood that. I'll give it a go though. While on here should say that...

I tried posting pictures, but it didn't work. I'll try crosstab queries. If they fail, I'll give up and tell the boss to go back to Excel.

Try this, highlight all your data, then do conditional formating, hover over the data bar options and then click on "More Rules". In this set Minimum to Number and 0 and Maximum to number and 1. Do this and 100% is full bar, but so is 1000%, but if that's what you're after, this works.

Hi Having a problem with Access 2013, I believe I could have done this with pivot tables before, but now they’ve been removed as an option, I’m more sure how to do what I need to do, so any advice would be welcome. The situation is that I have a number of tables which hold sub data for a...

The parts you have highlighted are the names of the queries you are raising queries on to get the necessary totals. I've put in the names of the queries as given above, if you've used different names then you put the name of your queries in there instead. so if you called the queries Query1...

Not sure what this question is aiming at, but here's two possible answers. If you are refering to the queries above, you don't need to do any more grouping that has already been done. If this is a more general query, then you create your query, I'd suggest using the graphical interface for...

Minty - Logically I agree with you, only the datatype is set to autonumber and it autopopulates with the next number when a new record is added.

Wouldn't have the vaguest idea how to post the DB - However I solved the problem late last night. It's a bit Heath Robinson but it works. What I've done is created an append query that takes the maximum of the existing project numbers and adds one to it to insert that as the ID. Now it's a...

Followed exactly, but still get error 3022 (duplicate values). It seems to try to set the autonumber instead of letting the table set that. Weirdly the number it tries to set seems to be a count of the number of times I've run (tried to run) the duplicate function.

Looks interesting, will give that a go. Thanks.

Hi, I've been asked to give users the ability to copy a record to a new record - sounds easy enough I know, and I've definitely done this before. The fact that I have to actually duplicate information in four different tables doesn't even phase me, but I am rather struggling with the fact that...

Since you are so new, I’d suggest that you do this in four steps, I’ve slowed this right down in hope that it helps you learn (a) how to write enquiries and (b) think in the smaller steps that are sometimes necessary before leaping into the more complicated single step versions that many of the...

Woohoo! It works - brilliant, thanks for all the assistance, it's really appreciated. Here, for anyone else that has similar problems, is the final code: ' set parameters for summation query Qry-SumIC putProjectID Me.ProjectID.Value putGateway100 Me.Gateway.Value 'Do DLookup to...

Here's a quick mock up as a slower version to what arnelgp, but if you're that new to access it might help you see what's going on: Qry-TotalCount SELECT Sum([tbl-centres].Enquiry) AS SumOfEnquiry FROM [tbl-centres]; Qry-CenterCount SELECT [tbl-centres].CentreID, Sum([tbl-centres].Enquiry)...