Search results

This sounds pretty straightforward. What have you tried? What are your issues? If its subtracting the dates, the function you will need to use is DateDiff(): https://www.techonthenet.com/access/functions/date/datediff.php Give it a shot and if it doesn't work post back your SQL here and give...

Your logic is not complete, you haven't categorized the cases that exactly meet your endpoints. What happens when it is exactly 1 week? Or exactly 1 month? Etc. In each of those ranges you either need to start with >= or end with <=. Further, 'month' is an ill defined unit if time. In days...

Is it enabled? Is it locked? Design View->Properties->Data-> Enabled should be Yes and Locked should be No

Agree with Dbguy, there's no way to do addition on those 2 records to arrive at the answer of 3. Are you summing Yes/No fields? How can you play a negative amount of Jokers? How can you get a negative amount of answers correct?

Neither Count nor Unique are functions available in a report. This is going to take more than one query and a better method for users to supply dates. I would set up a form where user's select dates to use. When you do it via the query as you have done you're gonna get trash input (typos...

How does a record exist in both tables? That is, what fields make it a duplicate? Can any of those fields be NULL? Also, I think its time to move from generalities to specifics. Give us actual table and field names.

This just doesn't seem correct. I don't know if helping you do this is truly helping you. So, can you better explain your setup? Give us a paragraph about what this database does. Why do you need to do this? Why do you need blank records in a table? That seems more like a spreadsheet...

Not too get too profound, but 'No Category' is a category. Of course I still have no insight into how your database works or is structured. I've got a vague notion that you are choosing categories for things, but I still don't understand why you have categories in two separate tables you need...

UNIONs are always a red flag of a improperly set up databases. Add to it this specific use and I'm 99% certain you haven't structured your tables properly. If these are similar choices, why are they in different tables? Can you give us a bigger picture view with some better specifics? What...

Nope. But I do wonder why people wonder that and it scares me.

What's your table look like? Better yet, give us some sample data, provide 2 sets: A. Starting data from your table(s). Include table and field names and enough data to cover all cases. B. Expected results of A. Show us what the correct answer should be for each employee in A. Again...

isladogs answer is the correct one for the main issue. For this one: It is caused by NonMemberID not being a field in the underlying datasource. That pop up is there because when you use NonMemberID in the query it has no idea where to get it from. Either eliminate it from the query or add...

Dim ContactID As Long ... ContactID = Forms!frmContactEmails!ContactList.Column(0, i) You are trying to assign ContactID, which is a Long, another variable's value. That variable is not a Long, nor one that converts to a long. You can find out what type it is by using the VarType function.

Are you sure? They may only work on 1 project at a time, but that doesn't mean they can't work on multiple projects during their employment. Employees can't switch projects? After a project ends, they don't go to a new project? If an employee can really only go to one project then you would...

1. Looks like CodeTo is a text field--is that true? If so you need to make it numeric. "Code='" & CodeFrom & "'")" 2. In the above snippet, as it is typed, Code is referencing a field in tCodes. But no such field exists. 3. In the above snippet, as it is typed, CodeFrom is referencing...

Oh, I found lots of ANSI92 stuff and like your link they all had 0 results when searched for 'ALIKE'

I have an answer, but not one that makes sense. It just made me more frustrated the more I tried to learn. Below is the fix for Access: https://answers.microsoft.com/en-us/msoffice/forum/all/like-in-an-access-query-becomes-alike/35a7c03b-1f83-40ca-88e3-61b8c4f867a6 ALIKE is part of ANSI SQL...

Agree with Pat, not a relationship issue. In general you build an import process, run that and in the end all your data is in the appropriate tables/fields of your actual database. The actual import process is predicated on the details of those 15 files. How often will you be doing this...

This is going to take 2 queries. First though, you need to add an autonumber primary key to Table1. Let's call that T1_ID. Then this is how you build the first query: Make a new query, bring in Table 1 and Table2 and JOIN them on every one of the 6 fields they share. Then bring down T1_ID...

Dang it. Missed it by 4 years.