Search results

Have a query from 2 linked tables that have a relationship. I am pulling some records based on some criteria. It returns what I want, but sometimes the same person could have several records, I am getting all of their records. I need to exclude anyone that has a matching address. Does it...

OK, after I select a range, how do I ave the values that I input print on the report somewhere for reference? Todd

How do I have a report select record from a query based on a range? I have a query that has a date field, I want to select records based on that date field from a date to a date (8/20/2003 to 8/25/2003). Thanks.

I do use an append query to append the data from the link file to the database. That is where i use the above code. What does the code look like that you suggest? Thanks.

Got it, thanks.

Would this go in the criteria for that field.

I have a link table to a text file setup that contains a currency value (for example 163588) This dollar amount would actually be $1635.88 When it brings it over and I tell the database that the field is currency, it labels it as $163588.00 I cannot get around this. How can I force it to...

Create a form based on an update query? But how would that give me a select all when I check one box?

I have a list of items all with checkboxes and date fields. I would like to be able to check all of them at once and enter a date that would populate all of their date fields. How would I go about that. Todd

That You very much, got it. Todd

Have a report that has field headers and footers that total up the number of checks that we have out standing: Branch 1 Name 1 Check Amount Name 2 Check Amount Total Checks ## Total Dollars $$ Branch 2... ..... .... What I would like to do and the end of the report, in the Report Footer I...

Have a report that is building from a table taht has check boxes for establiching criteria. When I create a report, I want to exclude the ones that have that box checked. How would I do that?

Getting confirmation of a null entry. I want that notification to be turned off. This macro pulls some data and prints to a report. I want the null entry to show, but I dont want to have to click end everytime. Thanks.

will a report duplex if the design is more than 1 page?

I personally have never came across anything, but that doesnt mean it doesnt exist. Todd

How do I have the database window startup minimized? Todd

Whn defining a union query, how can I make it select based on criteria? For Example: SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [BANK PAHC] UNION SELECT DISTINCT COMPANY_ID, HOURS_WORKED, CHECK_DATE, EMPLOYEE_TYPE FROM [NH PAHC] UNION SELECT DISTINCT COMPANY_ID...

I have figured it out. I used a DSUM function in Excel.

I did list it wrong. I would like to total each department with each company. There will be several entries in each department.

I am exporting some info to Excel. The database looks like this: Company_ID Department_ID Gross_Amount Check_Date 1a 01 1000 07/02/03 1a 02 900 07/11/03...