Recent content by djgolds

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'm having the same problem. I have a table that consists of only 4 fields (Date, Payable To, Category & Amount). Payable To and Category are based on lookups that I have added within the same table. I've created a form for data entry, and I absolutely cannot get these to sort in ascending...

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...

Thank you all for your help on this, but I'm still going to need more (sorry, I'm slow!). John, I'm not sure what you meant by opening it up in dialog mode, and also, from your last email, no, I'm not familiar with using DoCmd.RunSQL. Sorry, but I'm one of those that needs step-by-step...

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...

The BirthDate field actually started out as a number field. The preceding 0's before month and date were entered, but because it was a number field, it didn't leave the 0 in place for the month. I then changed it to a text field hoping to do the conversion from text to date. I tested it out as...

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...

Don't faint - but it worked . . . for at least the first line. In my test2 table I'm only using 6 entries and it converted the first entry, but the rest were blank. If you want to give up on me at this point - I understand!!! In case you don't, I copied and pasted the SQL in the "update...

This is the last time - I promise! If I don't get it on this one, we'll just forget it. I'm a bit confused by the SQL as in one message it included datevalue, and the new message didn't. I should have done this from the start, but my table name is Test2. This table includes a BirthDate field...

You're right - it was eliminating the first 0. I tried 3 times exactly as you had it and I get dialog box that says can't update due to violations. If I go ahead and click yes, it deletes the BirthDate column and my newDOB is blank. Sorry, you must be wanting to beat your head against the...