Search results

I'd like to check if a field is a certain value then mark the checkbox but, I'm not sure of the syntax and am new to Acces and VB. Here's what I have so far: IIf([SampleTypeCode]="Grab" Or [SampleTypeCode]="Integrated",[CheckGrab]=1) I'm certain this syntax is incorrect but, unfortunately I...

Looked at another thread and found that solution 1 can be accomplished simply by joining the two field together. So, looks like I have a solution, thanks forum!

Yet another Newbie to Access. I need to create a report to verify data entry accuracy. To do this I think I can either: 1. Retrieve a single field multiple times in a Row, like so: Result1|SigFigs|Result2|SigFigs|...etc. The results are stored in a single field called results. I have created...

The hardest part here is getting the decimals correct. Only way I can think of doing this is by converting to scientific notation like so 9.7 = 9 X 10(0) + 7 X 10(-1) Is there a function which will convert to scientific notation? Also, how do I count the number of characters in the result...

Please help, I need to write some code or function which will compare a numeric result field to a significant figures field and add decimal zeros if needed. I've broken this into a few steps, if anyone can help answer any of these it would be a great help (I'm new to access and VB and am not...

I am creating a report which will return numeric results for materials analyzed. The problem is that significant figures need to be preserved so, each result has a separate entry for the number of significant figures since access chops off trailing zeros in numeric fields (as far as I know)...