Recent content by plog

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