query question

  • Thread starter Thread starter martyn
  • Start date Start date
M

martyn

I have a query that searches for a product from my
database and displays to a datasheet. How can i then get
that product to 'log' to a report so that i can then
export only the items that i have searched for during the
day, E.g. if i have 100 entries in my database, and search
for 20 during the day, i need just the information on the
20 so i can exctract to excel
Many thanks
 
do you make changes to the records you search on, but not
to the ones you don't?

if so, you could add a control for *last updated* which
could automatically update to the date the changes are
made.

you could then create another query, based on the value of
*last updated* which could be the basis of the report?

does that make sense? is that the kind of thing you're
after?

Iain
 
What i have is a linked table to an excel spreadsheet
which gets changed daily with a list of products that come
in to be fixed. Then i wanted to use a scanner at the end
of the day and 'log' a time to the record before it gets
posted back. I then need to send the details of the fixed
products back to the supplier. Before i read your reply i
was going to drop the time field as its not a must have
and i was running into problems with my email template.
Would there be a way to do it if i havent changed any of
the files??
Many thanks
 
i've used instances in the past where i have a date field,
with a button next to it which automatically pops in the
current date to the field. you could try something like
that?

put your date field in the form, then put a button next to
it, and set its *On Click* property to :

Private Sub Command694_Click()
[DATE FIELD] = Now
End Sub

That would eliminate the need for the record to be reliant
on having changes made (other than clicking the button to
fill in the date)

You could then just have a report based on that date field.

Hope this helps,
Iain
 
Back
Top