Search results

I'm working with an Update Query using a Switch function such as follows. Switch([field_1]="red", "01", [field_1]="yellow", "02", [field_1]="blue","03]) The problem is that if the condition is false, meaning the value is neither red, yellow or blue, the Switch function will actually delete...

Problem: dealing with Switch formulas that are too long. step 1: The following Switch formula will work in an Update Query. Switch([field]= "red","01", [field]= "yellow","02", [field]= "blue","03", [field]= "orange","04", [field]= "green","05", [field]= "purple","06", [field] Is Null,"x")...

I am working with a form containing about 12 tabs. I tried to move some field boxes from one tab to another in the form by cutting and pasting. Those field boxes subsequently appeared on all tabs, which I didn’t want. Then I cut and paste the boxes again into the same tab and this solved the...

Please see attachments.

OVERVIEW PDF I have created a PDF that gives an updated overview of the issue as well as a summary of the developments in the thread. The overview currently includes all posts up to:　 page 3 post #1 (posted 07-03-2014, 02:45 PM) If this issue interests any reader they can now just read the...

When I made my introduction post I was disappointed that all the line spacing I made between paragraphs disappeared and all the text got smushed together. I am not sure now if you need to leave extra large spacing between paragraphs in order for the spacing to remain after submission or what...

Greetings from Toronto, Canada I am, what I guess is called, a newbie. Several months ago it occurred to me that managing data with Excel has too many limitations and I proceeded to look into alternatives such as File Maker Pro and Access. After joining Lynda.com and watching a video on File...