Search results
-
T
Form Detail is cuttoff at top by header
I have a form with a header. On the form detail I have separate tabbed folders for different forms. However, when I open this form the tabs are covered by the header and i cannot access the tabs without going into view, change it to datasheet view then change it back to form view. Any ideas... -
T
Query doing calculations against different records in same table
I have a single table with multiple rows of data for each entity (total of 8 records per entity - 4 for one fiscal year and 4 for the subsequent fiscal year). Here is the table structure: EntityName (Text Field) EntityConcentrator (Text Field) Value (Number Field) FiscalYear (Text Field)... -
T
#deleted showing up in query
I have a query with several tables that when I run it one of the columns returns #deleted whenever there is no data in that field of the underlying table. I have removed the table completely and then I get the #deleted response in another column from a different table. I did a search on... -
T
Changing Sub-Form Based on Data in Main Form
I want to have a different sub-form based on the contents of a combo field (response in combo field is limited to a list) in my parent form. I have 8 possible options for the combo field and depending on the option chosen, I want the sub-form's Source Object to change. The combo field in the... -
T
Calculated Range of Numbers
I have a report that tells me how many prenumbered forms I will be distributing to various entities. The query that generates the report has an expression that calculates data from several fields within the table from which the query is based. This calculation determines the number of forms to... -
T
Creating a Query with Multiple Columns from Single Field
I have three Tables. One table lists events. One Table lists Participants. One table is my join table which makes the participants link to the event table a many to many relationship. Meaning many participants may compete in many events. The data from a participants participation in an event is... -
T
Return Highest Score
I am recording scores for each of several attempts per participant into a Data Table and want a query to yield their best and second best scores from all attempts and then rank the participants based on their best scores. As one participant's best attempt may be their third try and another...