Recent content by MelodeeLRS

Thank you for your responses! They did help point me in a direction for resolution. Since I don't understand the Vulcan in nesting the referenced statements (an idea of what each actully does would be nice!) and I am short on time (reports have to be ready for monday morning), I exported all...

I have two issues. The first is thst I have limited knowledge of SQL and VBA. The other is that I don't want to have to create a query for each well (there are almost 50)...I need a way to insert the code in the form where the date and reading is entered by the user. This will allow the user...

I have looked all over for a way to calculate the difference between water meeter readings. My brain may be Friday slow, but all I can find is for calculating differences in dates. My water table has 3 fields: ReadDate, Reading, Calc1 ReadDate is the date the water reading occurred Reading...

Fixing the Yes option to -1 fixed the display issue. Thanks again to all!

Thank you both for your insights! I was basing the 1=Yes on the fact that is how it appears in a query...silly me! :D I will try changing the parameters for Yes and see if that fixes error. I was trying to avoid having to redo all the tables in this database to accomodate the Yes-No...

The form must mirror the hard copy form guys take to field to do site checks. They check either Yes or No on the hard copy. The option group works fine, as long as it is only used twice - eg change from default to opposite then back. After that, the selection no longer appears in the form...

The values for a Yes-No field are stored as either 0 (=No) and 1 (=Yes). I thought of this as well, which is why I used the Yes-No field to avoid the numeric-character issue.

I have an Option Group I created (simple Yes-No) in a form that links to a Yes-No field in a table. I have the default set for this field to "Yes" in the form. The option button works when the form is first opened. If I cange the option to "No", that works. Here's the tricky part that is giving...

I hope I can find some answers...this seems like a great place to look.