Search results

"Tax" column: IIf([tblEmployees].[Basic Salary] Between 0 And 12760, [tblEmployees].[Basic Salary])/([tblEmployees].[Salary Pay Period]), IIf([tblEmployees]![Basic Salary] Between 12760 And 25520, [tblEmployees].[Basic Salary]-[tblpayrolltaxes]![Lower])/([tblEmployees].[Salary Pay Period])...

I missed this earlier: If this is all you have to support the scans to be performed at an appointment then you will only be able to indicate one type of scan for each appointment. Earlier you indicated that you can have more than one scan scheduled at an appointment. If so then this is a...

Yes: as shown with the table structure, a single appointment can have one or more scans (of same or different types). Your form, displaying the appointment, will allow the addition of one or more scans to be performed. and post the appointment, the scans performed (usually as a subform) at the...

I appreciate the complexity of the questionnaire/response needed for the medical setting. It is indeed quite challenging and you may not be up to rejigging (normalising) the structure as suggested above. Pat's arrangement supports a simple multiple choice survey style arrangement that will not...

You should have some attribute which will indicate the source of the appointment: for outpatients you will have a referral from the GP. For internal, the source will be Hospital Dept. For an appointment of type Hospital Dept you will need a table to identify the Dept as an attribute in the...

While you have begun to identify some of the key tables for the business data you need to store, there are some additional considerations: like - as a department in the hospital do you expect your patient data to be sourced from the patient administration system of the hospital, or will you be...

Duplicate declaration in current scope: Dim userName As String Dim DtTaken As Date Dim SQL as string in: Private Sub CheckWinCondition5() of frmMain Repeat of same issue in frmMainPolish Thanks, appreciate putting it out.

As a novice with Access you will be taking a learning journey that does not need to be confused by learning additional software. I have not used Figma so do not know it. If it is just used to set out a screen flow/GUI design which does not translate into actually building the software is access...

A dummy GUI may help you communicate your needs but what you must ensure is that the underlying data structures - tables and relationships - are constructed with proper regard to the principles of database normalisation. Inspecting the table structures for other order entry systems will give you...

@sergio vieira Your requirement is that the listbox display of files needs to show just the filename and not the path. You have a field in some table that holds the path to the document, which, because it is the path, incorporates the filename. Presumably you get the path using a filesystem...

You have incorporated the VBA provided by @arnelgp in post #7, #9. Why not look at the returned values from the call to the function in your code before inserting it into the SQL? Set up the variables so you can see them in your VBA before using the SQL and reference them in the constructed SQL...

You are passing the string "date" to the function fnFinancialYearStart which is expecting an actual date.

Correction? to: SELECT A,B,C, IIf(Nz(A, '') = '' AND Nz(B, ''), C, IIf(Nz(A, '') <> '', A, IIF(Nz(B, '') <> '', B, C))) AS ABC FROM YourTable;

Something like: SELECT zzzjunctionTbl.ClassID, zzzjunctionTbl.TeamID, zzzjunctionTbl.EmployeeID, IIf((Nz([ClassID],0))=0 And (Nz([TeamID],0))=0,[EmployeeID], IIf((Nz([ClassID],0))>0,[ClassID], IIf((Nz([TeamID],0)>0),[TeamID],[EmployeeID]))) AS Result FROM zzzjunctionTbl; The function NZ is used...

An interesting article about the design of AI that incorporates the use of "rewards' to the LLM (so that it improves) has a consequence. if the objective is to achieve a reward, and the LLM can get there more efficiently by lying/cheating then it can take that course. If a punishment module is...

In addition, I would also like to suggest improvements to the relationships diagramming tool. It is frustrating that you cannot set up separate subject area diagrams showing just those selected tables and relationships needed to focus on with a particular area of work Multiple annotation blocks...

My question Was in relation to the process of scientific enquiry and the papers/claims made by scientists generally. Reporting results and drawing conclusions in such papers are typically restricted to the hypothesis being tested and, where further, more speculative conclusions are stated, are...

Yes - or it is part of the construction of that customer facing identifier - often with a year/ alpha prefix...

I have a different view on the relationships: as stated by Redstick it is not a genealogy database, however associations between members need to be supported to allow recognition of partnerships - meaning generally teams. Family associations between members (may) also need to be recognised...

Speculating it might be a customer-facing transaction ID and not the PK for the table.