Search results

Are you using ADO? If so, use '%' instead of '*'. Let us know if it works for you. InStr will work as well.

Either of your Test Marks or AvailableMarks has zero value which is evaluting #DIV/0! error. Edit your calculation like below: IIF(NZ([Test Mark],0)=0,0,IIF(NZ([AvailableMarks],0)=0,0,[Test Mark]/[AvailableMarks]*100))

Compact & Repair is required so, we cannot stop doing that but it has to be periodically like once in a month or weak. We can do this in two different ways; one with alter command and another using custom AutoNumber. 1) When you are archiving your data you need to execute ALTER Table command and...

You can use Data Macro to do this type of jobs but you have to have Access 2010 or higher version. Otherwise, you can write VBA like other adivised.

Comapct & Repair is absolutely the reason like Colin said. Uncheck Compact on Close from the File-->Option-->Current Database-->Application options.

Do you have any external criteria in your source wry_mark_grid which is coming direct from a Form? Would be more helpful if you can share that database or both queries.

Your DCount() will work if you just add an AutoNumber column with a little tweak in your criteria. Suppose, you added a column called ID which is an AutoNumber field. So, all you have to do is add another criteria into your DCount function. DCount("printref","[TPrint Data Store]","TprodRef1 = "...