W
W. Carroll
I am using an Access Template to create a database for time and
billing. The template was lacking a few of the fields I needed, so
after careful construction I have been able to add these fields and
keep the relationships in tact. The problems has arisen, though out
of a formula that is in one of my forms. The original form contained
a formula that referenced back to a select query. I was able to add
additional fields to that query and have gotten one of them to work on
the form. However, I have two more added fields that are not working.
I did the same thing for all of them. Also, I went into the query
and changed the order of the fields and they worked. So, it seems
that the formula is just not pulling information for those last two
columns, (there is data in these columns and I have made sure I have
numbered them correctly in the formula). I am just wondering if
anyone could tell me why I am unable to pull information from these
two columns in my query. Any information would be greatly
appreciated.
billing. The template was lacking a few of the fields I needed, so
after careful construction I have been able to add these fields and
keep the relationships in tact. The problems has arisen, though out
of a formula that is in one of my forms. The original form contained
a formula that referenced back to a select query. I was able to add
additional fields to that query and have gotten one of them to work on
the form. However, I have two more added fields that are not working.
I did the same thing for all of them. Also, I went into the query
and changed the order of the fields and they worked. So, it seems
that the formula is just not pulling information for those last two
columns, (there is data in these columns and I have made sure I have
numbered them correctly in the formula). I am just wondering if
anyone could tell me why I am unable to pull information from these
two columns in my query. Any information would be greatly
appreciated.