This query kinda works for me. Question about this part.
Where ((DateBorrowed) = (Date()-30))
I know Date() is = todays date. What if I wanted it 30 days before the album was archived?
That way i can see every person that touched an archived album?
Hello all,
My english is not so good but this is what I am trying to do.
I lend out records to my friends and I am trying to run a query to see who borrowed what over a 30 day time span.
I have two tables one that holds my data
Friends
* FriendID
* Name
* Location
Records...