Search results

Yes, but 'return' isn't the right verb or concept. Instead it would be more like identifying and using. To help specifically, we would need a better understanding of how your tables are laid out and what the ultimate aim is of identifying the ID. Are you opening a specific report? Are you...

Why are you moving data? In a referential database, you reference data, not move it. If you simply stored the Code value in your Purchase Order Details table you could then just link Purchase Order Details to Products and have all that data available. Why must it be moved?

Equivalent. 100 + (100 * .3) = 100 + 30 = 130 100 * 1.3 =130

Define "can't get it to work"?

First is advice you should learn in general, but not apply in this particular case: Divide, isolate and conquer. You've got 5 datasources in your query any of which could be the offending source with "duplicates". So, narrow it down to find out which one the culprit actually is. Start with...

So you quoted the whole post, then put quote marks around just part of the quoted part you just quoted wholesale, then you made a tangential, near non-sequitur comment?

Aliases have nothing to do with your error. JOIN isn't valid by itself. Add INNER before it (or LEFT if you prefer). As for aliases in the FROM, yes you just space from the name and then use the alias you want: FROM employee e

This presumes the form's button's code uses vba to open that report and that you are using a label on the report to hold that composed text you want to place on it. If not, you need to tell us how the form is opening exactly. After the DoCmd.OpenReport you will need code similar to the below...

The syntax error is having the second, inner set of parenthesis, the logic error you will experience next is because you are treating [Basic Salary] as text. As text "2" is greater than "100" because when text is compared it is done character by character. So the first character of "2" is...

Often 'empty' isn't empty. Or even Null. Sometimes its a tab or a newline or any of the many characters that fool human eyes. I suggest you use the ASC and IsNull functions to determine what character is there: https://www.techonthenet.com/access/functions/string/asc.php...

IIf([Marital Status]="Married", [Basic Salary]<17100,0) IIf([Marital Status]="Married", [Basic Salary]>=17101,12) IIf([Marital Status]="Single", [Basic Salary]<6400,0) IIf([Marital Status]="Single", [Basic Salary]>=6401,12) Everyone else has addressed the syntax. But you're logic isn't...

When, how and what is the context of the test? Do you need to test for this as the user is entering data on a form? Or is this a test you will personally run at some interval (daily, weekly, etc.)? Please explain better what you envision from start to finish: User does a,b,c; User clicks a...

And there you go. See the misspelling?

This is not a datatype issue, it cannot find [days remaining]. Step away from the report. Open the query the report is based on. Does it have a [days remaining] field in it? Is it spelled correctly? The VBA you have must spell it exactly the same way it is in the query. The screenshot you...

1. You don't need quotes around values when comparing numbers. 2. When compiling strings, you concatenate (put together) literal strings and variables with the & sign: So, the criteria should look like this: "[days remaining] <= " & me.dtotext 3. You shouldn't use spaces in names, just...

Lots of questions and notes. 1. How far from tables are we? Building this query this way seems like building on an unstable foundation. You need a new query built on forcast_planning, which itself is built on forcast4, which is probably built on forcast3 which is probably built on etc etc...

I apologize, I thought that form was your Access form. However, I'm not entirely wrong. I think you need a Roles table. All the data in those checkboxes in your Contact table would go there: Roles RoleID, autonumber, primary key ID_Contact, number, foreign key to Contacts RoleType, text...

You need to put away forms for now and work on properly structuring your data. That process is called normalization: https://en.wikipedia.org/wiki/Database_normalization Give that link a read, google a few tutorials, then apply what you have learned to your data. The big thing I see with...

Here's good documentation on IIf: https://www.techonthenet.com/access/functions/advanced/iif.php IIf(test, true result, false result) Your IIf doesn't have a complete test, it's just one field. You need a comparison operator (=, <,>, etc) and what to test [Client Title] against Also, your...

TVs and monitors are slowly merging. I don't use actual monitors any more. Monitor Pros: slightly cheaper, slightly simpler to use TV pros: has a remote control, built in local channel antenna, more functionality, can repurpose as actual TV in another part of the house when you upgrade...