Search results

Long does not have decimals. Use Dim XXX as Single.

Is the number always 7 positions?

This one is updateable....

Use a query to select the records with the current date. Something like SELECT * FROM TOC WHERE TocDate = Date()

Sorry, I didn't read your question completely. Nevertheless, I agree with the others that it is not necessary to record the previous value. After all, it is in the previous record and therefore you do not have to record it again. Make sure you have a field in your table that allows you to...

What's the point of having a table with duplicate records? Please tell us more about the background of this question so we can better assist you.

It is a bad idea to store that in your table. You need to run the query every day. Make a query with a calculated field and you can always show the right value at the current date

Eberhards solution (MID) will do.

That depends on whether the prefix is always the same number of positions long. And if that is not the case, then it always ends with a /?

Or WHERE YEAR(YourDateField) = YEAR(Date()) - 1

Every four of the records in table 1 that has matching records in table 2 has two matching records there. Every combination is shown. Add DISTINCT to your query to eliminate duplicates: SELECT DISTINCT Table1.Payer, Table1.ClientName,...............

Why create a separate table at all if there is only going to be one record per record in the main table? Then you might as well add fields to the main table.

I have no idea what you are trying to achieve with the subquery. And especially not because the form has no record source. What is wrong with: CurrentDb.Execute "update Investments01_tbl " & _ "set investigate = 'No' " & _ "where investigate = 'Yes'"

Maybe this should be (part of) your datamodel: Notice I removed redundant fields from SalesT.

I think the problem starts with the query test. When you look at the design of the query, you notice that the relations around the joblist, -subcat and -cat are somewhat "confusing". There are several "roads" from joblist to sales and from jobmcat to sales. Looking at the relationship diagram...

Please complete it yourself. I don't like your tone.

You need to set the rowsource of the list in events. Take a look at my example, BTW, you need to have primary keys in your tables and create relationships.

As said before, there is no need for a vacancy field. You can determine whether a location is already in use from the recorded data. The field is therefore redundant and you run the risk of inconsistent information arising. To make sure only vacant locations are shown in the combobox, set the...

In the query that is the recordsource of the subform you get the title from the table LearnerBookIssue. First of all that field should not be in that table. Remove it and get the title from the booknumber table.

I assume reality is more complicated than you describe here. Students may have to repeat a year, leave in the meantime, or start in a higher grade. So just looking a start year won't give the right results.