Search results

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

Combo boxes can be built without a separate table, you can look at existing distinct values in the field to choose from.

One big table. A good rule of thumb is that tables (and fields for that matter) should be named so generically that someone without knowledge of the system knows what each table/field is for. Also, you shouldn't use suffixes, prefixes or numbers in names. So that means you would never have a...

It kind of seems like you are just building this by the seat of your pants and seeing where it takes you and hopefully that ending point provides you with something helpful. Not a criticism, just an observation. My advice would be to start building this from the other end--not with what you...