Search results

Your Authorization Form needs to be a main form and a subform. The main form should be based on your Patient table. This will allow you to display all info you need about the patient. Then the bottom should be a subform based on your Authorization table and linked to the main form via...

From a developers perspective, 1 form based on 1 table and you'll never go wrong. From a users perspective, by using pop-up forms, tabs and subforms a lot of those forms are seemingly integrated into 1 form. So no, you can't do all those things you want with one form. Or even from a users...

How is TOTAL being calculated? Can you show us that code and any subsequent downstream code? My guess is TOTAL is rounding rounded values. For example: 1.114 2.224 3.334 If you add then round you get: 6.672 6.67 If you round then add you get: 1.11 2.22 3.33 6.66 I think your rounding too...

Excel is the CRUD application. You're trying to reinvent a wheel with a wheel. You can create records by typing in a blank row, you can read and even print data from it, you can update values by overwriting the cells, you can delete records by right clicking and deleting.

Huh? The column name doesn't display. The label of the list box does display-- center that (or add leading spaces to it) instead of trying to fix a formatting issue in SQL.

No it doesn't make sense. 1 table makes sense. With what you have given us, I see only 1 table, exactly as it is. Again, you only need one table for this data, exactly as you have it now.

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.