Search results for query: *

Is there a way to do an Unmatched Query and use multiple fields for the comparison? What I'm trying to accomplish is to compare a line-by-line billing from a vendor with my own billing spreadsheet and I need to match on address, service date, equipment, and dollar amount to determine any...

I've created a brochure that includes a text box for adddresses. My addresses are created in Access. For some reason, Publisher is not allowing me to get to the open data source (it's grayed out). Any suggestions?

I've created text boxes using Word 2000, but when I email the document to my client and she opens it up, the text boxes are blank. She's using Word 97. Does anyone know of a solution? Thanks in advance for your help!

I've created a PivotTable and below that I've entered formulas for percentages based on the calculations in the PivotTable. Every time I change my selection in the Pivot table, it reduces the column widths so that it's not wide enough for the calculations I've entered in below. Any suggestions...

I've created a table in Access based on a survey that consists of 80 questions and a combo box for responses to the survey questions (yes, no or partial) and which region they belong to (total of 5 regions). Table Example: Question 1 Response Region Now I want to be...

I need to purchase software to create pdf's and was going to buy Adobe Acrobat, but I have the opportunity to purchase PageMaker at a great price. I currently use Microsoft Publisher for making newsletters, brochures, etc., but I'm assuming PageMaker would be a better choice. I guess I really...

I have a column in my table that is in date format example 01/25/2001. I'd like to convert this date to year only to do various queries. Even though I put my format as yyyy in the query, when it does the filtering, it returns numerous instances for the same year becase it still recognizes the...

I have a database set up for all of my customers. One table lists customer names and addresses. Another table lists types of businesses. It has 2 fields, one is the primary key auto number and the second field is the type(insurance, attorney, etc.). I have created a form for my customers and...

I'm going to make 1 last effort to see if there's a way to do this. Thanks to those that have helped so far! I have a table tblTest2 where the BirthDate field is entered as a text field and I want to convert it to a date field. What I've tried so far is creating a query from tblTest2 with the...

I have a table where the birthdate was entered as a number field rather than a date field when designing the table. An example is a birthdate of July 7, 1960 is entered as 07071960. How can I convert this to a date field and maintain the correct numbers? I've tried just changing the field...

I have a form for my customers (created from a table) and I want to pull information from my Invoices table to sum unpaid invoices that are 30 days or older for the specific record (customer) displayed on the screen. My columns in the invoices table are: Invoice, Invoice Date, Amount, Date...

I want to be able to sum all of my outstanding invoices within a form I've created for the specific customer record that is active. My expression is: =DSum("[Amount]","[Invoices]","[CompanyID]=[txtCompanyID] AND [InvoiceDate]='is null'") But this just produces an...