Search results

There's no space after VALUES and that opening parenthesis

Can the actual 1st day of the month ever be attributed to the prior month? Or could the actual last day of a month go to the next month? Is there a situation where February 1st's data would go to the January report? Or where January 31st's data could go to February report? If not, why do you...

Its not clear, mostly because you spoke with too much database jargon and not enough about the actual system you are trying to model. What's a playable sim? How does a job type have a career type? How's a job different from a career? I need context of what is represented to understand what...

Debug.Print sSQL That will print what's in sSQL to the immediate window. If you truly want to put it in a table you could make a table with one text field and then run an INSERT query to that table and put what's in sSQL into the table. DoCmd.RunSQL "INSERT INTO DebugTable (DebugField) VALUES...

Why not respond back to the original thread you made for this: https://www.access-programmers.co.uk/forums/threads/variable-for-forms-statement.332720/ People had given advice.

You're logic is too complex for this to be inline, it needs to go into a function. You've got 4 cases that you need to account for, trying to cram all of it into a deeply nested iif statement is just too much for a human to achieve. So, build a function and break out the logic into as many...

Never trust your eyes with a computer. You can't tell the difference between a NULL, an empty string and a tab character. Just because your brain can see a date, doesn't mean it's a date data type to a computer. Two ways to make sure something is an actual date is to use DateValue and...

Every post you've made in this thread contains at least one huge red flag that you've not set up your tables correctly. In a relational database data doesn't get moved hither and yon. It doesn't have calculations done to it in one spot and stored in another. It doesn't get stored in multiple...

That dialog is because you told it a field name that isn't actually a field name. Whatever that dialog is asking for is the culprit. Most likely it's a typo on your part. You told it to find [ZIP] but the actual field name is [ZIPCODE] or you told it to use [CITY] but misspelled it in the...

Complexity has to exist somewhere. You can manually do the complexity by a long intensive process of opening the Excel file, manipulating it such that it is ready for straight import into Access then doing the import within Access. Or you can write some complex code to do all of that for you...

Credits and Debits should not be separate fields. Combine them into an [Amount] field. Then the simplest solution is to use negative numbers for credits and positive for debits. Or if you want to classify your transactions (Deposits, Checks, Card, ATM, Interest, etc.) you could add a...

Your sessions aren't explicitly declared? That's an issue if so. If you could mark which session each tournament belongs to you could do this with just SQL (in a query). Without that you'll need VBA to iterate through all records to determine which each belongs to Also the start date and time...

I hope this guys got his passport in order and has exchanged his money. Yes, post them all.

I hate the Watercooler and avoid it like the plague. I wasn't paying attention and accidentally posted here once when a topic was sort of Access related and regretted it immediately and unsubscribed so I wouldn't have be reminded of its existence. For the same reason I avoid the watercooler I...

1. Who cares about the formatting of data in a field? Tables are for holding data, reports and forms are for displaying data. 2. Why is Percent a text? 3. What quantity can be a decimal? Most inventory can only have whole numbers of items.

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