Recent content by plog

That literally makes no sense. I use 'literally' there to emphasis that it's not what you said is ridiculous, but that I have no idea what you mean. You have a table with 2 fields. One of the values in the field you want to update is 'Revenue & Sales' which you didn't show as having a space...

No need for any function call, just concatenate a space like so: = " " & MListName However, in your example, why doesn't Revenue & Sales get the space as well?

So, the main issue is solved above--reread the posts, the answer is there. But you also made another error in trying to debug the main error: Me![txtRefresherDate].Value = RefresherDate MsgBox "RefresherDate" It should be no surprise that your message box doesn't display a date. You told...

1. City and state are not enough to identify county. Atlanta is in Fulton and Dekalb, Oklahoma City spans 3. 2. Add a county ID to the Counties table, update Locations to the proper CountyID and then remove City/State from the Locations table. You shouldn't store duplicate data in multiple...

There's really no general help for this, it's gonna have to be specific to your instance. That means we need details. Preferably a sample of your database and a mock up of what you expect your dashboard to look like when finished.

Yes. No append query needed,this can all be done via forms. You should build a form with combo boxes that show the user text but store the id. You would have a main form that displays 1 property. It's information would be at the top of the form and at the bottom would be a continuous subform...

Actually two sets of sample data is best: A. Starting data from your tables. Include table/field names and enough data to cover all cases. B. Expected results of A. Show us what data you expect your query to return based on the data you provide in A. Again, 2 sets of data--starting and...

Those are two different things. You absolutely can ask for the maximum value of a field: SELECT MAX(YouriD) AS MaxID FROM Your table Now if you want the rest of that record's data, you would use that query I posted as the basis of another query joined to Your table to get that record's...

The form. When you use a bound form, Access does all that behind the scenes and saves you from a ton of work. You won't find the SQL anywhere, it's just inherent in what a bound form does.

No tool, needed, just a query: SELECT MAX(LEN(FieldName1)) AS FieldName1MaxLength MAX(LEN(FieldName2)) AS FieldName2MaxLength MAX(LEN(FieldName3)) AS FieldName3MaxLength ... FROM YourTableName

Best first post ever

My gut and my experience compels me to first want to know the details of this query chain and your table structure. I've come across complex query systems like this before and have always found inefficiencies. Can you post a sample database with the necessary queries and tables to feed them...

Here's what we need to help you: 1. A simple explanation of what your organization does. Pretend its career day at an elementary school and tell us what you do. Use simple terms and no database jargon . 2. Very high level explanation of what this database does for you. Use very little...

Tables: 2024 Voucher Log 2025 Voucher Log 2026 Voucher Log Just with the table names I can tell you haven't set up your tables properly. You will need to work on your table structure before you move onto forms. Post the screenshot tvanstiphout requested so we can help you with that.

Check the users post history. Been coming here for years with this database and starting threads asking for hacks to issues that exist because of the improper table structure. First couple responses are how to properly structure the tables and correctly use foreign and primary keys. Then...