Recent content by bassispunk

how can i exclude entire records from a report? for example, for sending out mailings(ie creating a mailing label report) in which the recipient may have been listed in the report 2 times, how do i remove the 2nd, 3rd, nth instance of their record? I have tried the "exclude duplicates" in the...

what is the syntax needed to run a query that will only return data that has been entered within the past 2 weeks. for example, the query will return all entries into a form where the date field falls between the current date and 2 weeks ago. thanks

I can not seem to figure this out. I have a report of customers grouped by city. Each city has a count for how many customers are from that city(in the city header). What I would like to do is calculate a percentage of how many people are contained in a city compared to the total number of...

ok heres my dilemma. i have to create a form that will be able to handle the following situation. i already have the tables set up, so any help would be much appreciated... a customer is entered in the database when they turn in any 1 of 4 types of passes. i need a form to list the customer...

thanks for your reply. i'll try it out.

I have a report that groups people by city. how do i calculate the percentage of the total people listed from one city to the total people included in the whole report? It seems this should be simple but I'm not figuring it out. Thanks in advance...

I was wondering if it was possible to take email addresses listed on a report and import them directly into an email program(namely MS Outlook). Any suggestions would be greatly appreciated.

whoops yes i posted in the wrong area. thanks for yourr help though.

How do I set up a text box in a form so that when a user inputs information, it knows what has already been entered and uses those as a default value? For example, if the user begins to type the word "Chicago" in a city field, it will recognize the "Ch..." and automatically put "Chicago" in the...

I have a report that groups people by city. how do i calculate the percentage of the total people listed from one city to the total people included in the whole report?