Search results

I understand normalization, but have no idea what your organization does, nor how this database fits into your organization. So, let's step back from the database for a second and explain 2 things to me, using a paragraph each: 1. What does your organization do? Pretend its career day at an...

Probably not. You need to fix every single JOIN you have, none seem right. Does StudentID really equal EnrolledID, GradeID and MathsID? That can't be right. You never link the primary key of one table to the primary key of another table. The primary key in one table gets linked to a plain...

You need to tweak your tables and also the way you handle moving inventory. Moving inventory should involve 2 records in your InventoryTransactions table--a debit from one location and a credit to another, not just one record that handles both things. With ToLocationID, TransactionDate and...

Ugh, you're triggering me and by that I completely agree and then some. When I see aliases in the FROM I know I am dealing with someone who's main objective isn't to write good SQL but to convince other people they know how to write good SQL. Like 90% of the tattoos in the world are on people...

This is getting painful. The screenshot is of your table. I need to know what you expect your query to return.

You need to use the database you uploaded to demonstrate. The database you uploaded has no ID=21. So either upload that database or provide a screenshot using the existing one.

Again, an explanation is not the best way to communicate this. Show me exactly all the data you want the query to produce based on what is in the table you uploaded. If needed take a screenshot of the existing query and put the correct expected values where they should go.

Define 'not work'. It's runs for me and produces a total exactly as what I expect it to based on the logic in it. Instead of an explanation, I suggest you give me the actual data you expect that query to produce.

When you create an aggregate query (SUM, COUNT, MAX, MIN, etc.) then every field that is in the SELECT must either be in an aggregate function (SUM, COUNT, MAX, MIN, etc.) or be in the GROUP BY. You have no GROUP BY. So, you either need to get rid of [Employees Extended].ID, [Employees...

Private Sub Form_Click() ' Comment summarizing what this sub does Dim Rs As DAO.Recordset ' comment about what this will do Dim ctl As Control ' comment about what this will do Dim varItem As Variant ' comment about what this will do pubProjectID =...

I did, you quoted it.

Can you logically explain what data you need from the file? 'Where the red squiggly line is on the screenshot' isn't something that can be coded into Access. Is it somehow related to a date? Is it related to where the first blank row appears? And don't give me logic for just this one...

First and foremost review this: https://support.microsoft.com/en-us/windows/use-snipping-tool-to-capture-screenshots-00246869-1843-655f-f220-97299b865f6b Second, why do you have 2 tables with the exact same structure? That's a big error. Instead, all that data just needs to go into one...

Your table structure is incorrect. 1. Tables with the same structure. You're two tables are virtually identical. Why is that? Why can't you just use one table for this data? 2. Credits and debits in separate fields. If you want to aggregate the data (e.g. add it up). You don't store...

That's a lot of fields for a table that is properly set up. Also, "replicating data" is another sign of things not set up properly. If you have a bunch of data that is common and related, then perhaps you need another table just for that data with another table for the data that is different...

Can you expand the tables so we can see all the fields in the tables please

By focusing on forms you are attacking this the wrong way mentally. Put forms aside and focus on your tables/fields. Forms are the last element to work on in an Access database. I don't know what the right way is, but I know that is wrong. If tblStops has LoadID in it and tblStopFeeDetails...

NextCount = CurrentCount + (((CountOfRows - (CurrentCount MOD CountOfRows)) MOD CountOfRows) edit--the above finds the number greater than or equal to CurrentCount that is divisible by CountOfRows below will find number greater than CurrentCount divisible by CountofRows NextCount =...

It's a pretty simple aggregate query: https://support.microsoft.com/en-us/office/sum-data-by-using-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a Instead of Summing, you get the MAX: SELECT Player, MAX(Points) AS HighestScore FROM YourTableNameHere GROUP BY Player ORDER BY MAX(Points)

So...don't update them? I still don't understand why they are unbound. Even if not unbound and you don't trust yourself to not update them you could lock/disable them on the form so they can't be updated.