Search results

Still see only 1 table, exactly as it is now.

That's the only sentence you gave us that gives us insight into what your data is for. So, going off that and seeing the fields of the one table you posted--I think you only need one table--the one you have, exactly like it is. What do you think would be in a second table? Also, why would TD...

How is your query not working? What results is it producing that it shouldn't? What results is t it producing that it should? With that said, you need to fix fix StockLocations.Stock. Every discrete piece of data needs to be in its own field. Based off your query you've got at least 2 pieces...

Add me to the huge list of people saying your focus is wrong. Put forms out of your mind. You need to get your tables correct. I advise you read up on normalization (https://en.m.wikipedia.org/wiki/Database_normalization). Google a few tutorials. After you work through them apply what...

You need more than a new form, you need a new table: Parties partyID, autonumber primary key IDDispatch, number, this will hold the primary key numeric id in DispatchDetails partyName, text, data that was in PartyName of DispatchDetails is here now FreightCharges, number, data that was in...

But thats not what your doing. None of those Dlookuops have criteria to get 'the latest' values. Your just pulling random values from your table...

Like a website or an actual website? If you want this available in a browser and on the internet for anyone to use, then I would not recommend Access. There are better options for that, probably some open source, plug-in-play just load data systems available for that. If you just want this to...

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...

This will do exactly that: SELECT SUM(Amount) AS TotalAmount FROM YourTableNameHere WHERE [Is Head unit item] Of course what people say they want and what they actually want are often 2 different things. If the above code doesn't do what you actually want, please tell me how it fails...