J
John
I originally posted in comp.databases.ms-access. Apologies if this
post is redundant, but I need help with this problem.
Hi - I am trying to perform a simple append query, with no luck. I
have a table (MktPrices) that has the following fields: BondID,
PriceDate, Price. The objective is to allow the user to input a date
and have the append query create a new record for each BondID, using
the input date and the most recent price - which the user can then
update on a tabular form. I have created a totals query
(qryMostRecentPrice) which selects the most recent price (Max of Date,
group by BondID) for each BondID, but cannot work out the append
query.
I already have a form/subform set up that lists the bond description
information along with a price 'history' subform for each bond.
The new form that I am trying to create (based off of the append
query) will be a simplified tabluar form that will allow the user to
update all prices quickly by having a single row for each security:
BondID and price. I would like the user to be able to click a button,
be prompted for the date, have the append query create the new price
records, and then have the new tabular form open.
Thanks
post is redundant, but I need help with this problem.
Hi - I am trying to perform a simple append query, with no luck. I
have a table (MktPrices) that has the following fields: BondID,
PriceDate, Price. The objective is to allow the user to input a date
and have the append query create a new record for each BondID, using
the input date and the most recent price - which the user can then
update on a tabular form. I have created a totals query
(qryMostRecentPrice) which selects the most recent price (Max of Date,
group by BondID) for each BondID, but cannot work out the append
query.
I already have a form/subform set up that lists the bond description
information along with a price 'history' subform for each bond.
The new form that I am trying to create (based off of the append
query) will be a simplified tabluar form that will allow the user to
update all prices quickly by having a single row for each security:
BondID and price. I would like the user to be able to click a button,
be prompted for the date, have the append query create the new price
records, and then have the new tabular form open.
Thanks