Search results

This is very handy. I applied it to a query on a crosstab query, which enabled me to find the mode of each row (the column containing the highest number).

Thank you, Collin, I'm going to give it a go.

What I would like the query to return is (a) the count in case there is a match, and (b) a value of zero if there is no match - in the same query. I'm somewhat of an SQL/Access amateur, but if I interpret your answers correctly, they are only a way to get (b), at least that's what I found when I...

For what it's worth, this site will always dominate the search results for me because I have bookmarked it. As an Access/VBA noob, I found this site the best by far (like lightyears) in terms of clarity and helpfulness. I'm a firm believer that content is still king on the internet and this...

On this thread, plog helped me out with a bunch of queries I was struggling with. My question concerns the query Review_sub_10: SELECT public_tblreview_items.review_id, Count(public_tblreview_items.review_item_id) AS observations_animal FROM public_tblreview_items WHERE...

From looking at your queries, I also noticed an erroneous assumption I have been working under, i.e. that you can't use the result of a calculation in a query for another calculation in that same query. Turns out I just used the wrong syntax and misinterpreted the error message. So now the...

Thank you for your time, plog, I really appreciate it. Since your post yesterday, I was thinking about condensing the queries along the lines you suggested yesterday. But in the db you posted, you also used a few tricks I wasn't familiar with yet, like putting a table in a query twice. Is...

I created a sample db with the relevant tables and queries. This application is a tool to create cigar reviews. While smoking (which can take up to an hour or more), the user can enter flavour observations in ten categories (which are stored in public_tblreview_item_types). With these queries...

Posting the db might be tricky, I haven't secured anything yet since I'm the only user so far. Let me see if I can make a local copy. Anyways, thanks for your offer to help!

OK, I'll keep an eye on performance and check with my buddy who set up the postgresql backend for me about the possibilities for calculations in stored procedures.

Good to know, that's a deal breaker right there. I'll just have to rely on the math being so complex that a hacker would have a hard time figuring out the algorithm. God knows I need my notes to remember what I did and why...

For my project I want to make some complex calculations. One calculation requires six consecutive queries, each one building on the results of the previous. This calculation has to be applied to ten categories, so 60 queries in total. I have made the six queries using the Access interface. Easy...

I put in the NoMatch for completeness sake, but it's basically impossible for a user to call this part of the code without a match. If there were no match, they would be calling a previous IF-statement. The way this works is that in the regular flow of my application, reviewid (PK) would be the...

Thank you both. I first tried Moke's solution, and it worked. But then I was also sensitive to pbaldy's argument (my only programming experience was in the dark ages with Pascal and allocating memory blocks on 4 MB of RAM, so that left a scar...). Again, thank you both. Being able to...

Like my wife, Access doesn't understand me. In case of my wife, it usually means I'm doing something wrong, but with Access too? Here's what I'm trying to do: 1. Retrieve an ID from table1 (pending_review) 2. Use that ID to retrieve a corresponding value from table2 (pending_model) Part one...

Thanks for the replies, everyone. I'm going to go with Moke's suggestion first, mostly because I don't fully understand what the others are saying, being an unexperienced VBA-user. :o ETA: I didn't notice Uncle Gizmo's file at first. Thanks, that helps a lot!

I have a form2 that opens by clicking a button on form1. On loading form2, some VBA code is executed. I would like to create an option to open form2 from another form, say form3, and perform a different bit of code on loading. Is it possible to identify whether form2 is opened from form1 or...

So, I read up on transactions and modified my code as shown below (added the bolded parts). I am not sure if it works, though, because nothing happens - that is to say, the code is executed as expected, but I don't "see" the transactional aspect of it. Am I doing it right? I used the code on...

Thanks for the pointers, CJ. I found that Access automatically uses transactions in Make table, Append, Update and Delete queries. I found this web page that explains transactions in simple terms. Now I'm thinking if it would be a good idea to replace some of my VBA code with calls to...

My project has a postgresql backend hosted on Amazon Web Services, for which I am developing a frontend in Access. With your help, I'm making good progress, so I started to think about the best way to make the application available to multiple users (think of them as consumers, so no company...