P
Procyan
Hello All,
I have been researching this question going on 4 days. (3 to 4 hours a day
at work) I am designing a database with Access 2003 to track the movement of
personnel. One thing we do for the customer is request a hotel for them. I
have made a standard "Hotel Request Report". Currently how I have it setup,
I have an Append Query run and take the data from the fields in my master
record table and paste it into a table that is the "Hotel Request Report"
record source. When the Append Query runs it takes the correct data, but it
takes the data from every record in the database. I only need it to take the
active record's data so I can print the report and fax it to the hotel. My
solution (which was the only thing I could think of) was to add 2 fields in
the master record table. I added [DateModified] and [TimeModified]. When my
Append Query runs it will still grab all of the record sets but if I could
write a filter expression that would only show the record last modified then
my report would be correct.
I understand that this is not the optimal way of making it work but either
solution would work for me. A filter expression for my report or a way to
tell the Append Query to only take the active record data.
Thanks in advance to everyone that offers advice. I have made some automated
forms using custom user forms in Word and basic programming with VBA, but
only in with word applications.
Michael Mclaughlin
I have been researching this question going on 4 days. (3 to 4 hours a day
at work) I am designing a database with Access 2003 to track the movement of
personnel. One thing we do for the customer is request a hotel for them. I
have made a standard "Hotel Request Report". Currently how I have it setup,
I have an Append Query run and take the data from the fields in my master
record table and paste it into a table that is the "Hotel Request Report"
record source. When the Append Query runs it takes the correct data, but it
takes the data from every record in the database. I only need it to take the
active record's data so I can print the report and fax it to the hotel. My
solution (which was the only thing I could think of) was to add 2 fields in
the master record table. I added [DateModified] and [TimeModified]. When my
Append Query runs it will still grab all of the record sets but if I could
write a filter expression that would only show the record last modified then
my report would be correct.
I understand that this is not the optimal way of making it work but either
solution would work for me. A filter expression for my report or a way to
tell the Append Query to only take the active record data.
Thanks in advance to everyone that offers advice. I have made some automated
forms using custom user forms in Word and basic programming with VBA, but
only in with word applications.
Michael Mclaughlin