Search results for query: *

I did it! this is the original query that worked last year. I can't figure out how to send the report layout, but working on it. SELECT [EMPLOYEE TABLE].EMPID, [Table CHK LOC].[CHK LOC], [EMPLOYEE TABLE].LNAME, [EMPLOYEE TABLE].FNAME, [EMPLOYEE TABLE].MI, [BCBSHLTH TABLE].BENEFIT AS...

i am obviously over my head...sigh... I tried to paste a print-screen of my query layout to this post...didn't work. I am an extreme novice...can you tell me how to it? Can't figure out how to attach it with a URL... also, during the append query I got several error messages in a dialogue...

I created a database last year with 6 tables and a query builty on the tables. I also created a report using the query. The report is an employee "Benefit Statement". The tables are very simple (Example: Employee Table has a unique ID and first and last name). The additonal 5 tables contain...

I have an Excel datasource consisting of names, addresses and an insurance premium amount from 1.00 to 59.00. The number in the cell is formatted as accounting with 2 decimal places (no $ sign). The mail merge main document (after the merge) pulls the correct name and address but displays an...

Thanks to everybody who responded. ANOTHERHIGGINS - after I paste the formula in, and enter, the cell reads $0.00. As if there are no values in the cells that the formula targets. It gets wierder....I just copied the whole spreadsheet to a blank worksheet so I could try out the F9 function...

This must be very simple but I've never had it happen before. I have a fairly simple formula that I copy to new lines inserted in a spreadsheet that works perfectly for all the current rows, but when I just added a row, it won't work. I just tried to copy/ paste special/ formula only/ to a new...

I know this is elementary and I will be embarrassed by the answer, but I can't think what to do. I need a Label Box in a form to hold a word with a superscript number next to it. I tried to paste the word with the superscript from Word, but I wasn't successful. Can anyone help me?

To: dhookom from: binglelmh - I figured it out!!!!!! I left out my brackets around the fieldname. Thank you again and again!!!!! It works!!!!!!!!!!!!!!!!!!!!!!!! Also thanks again to Zonie32 and ZmrAbdullah!!!!!

Thanks, I am definitely working on a backup copy. Well, now you will know just what a newbie I am - Here's what I typed- In Update to: StrConv(Member Fname,3) Remember that "Member Fname" is the name of the field. I ran it and in datasheet view it returned one column, many records long...

I wrote the update query but I don't know the expression used to change names and addresses to what I call "Title Case" - Ex. I need to change "MARY K. MARTIN" to "Mary K. Martin". StrConv(fldName,1) will give me all caps which is what I already have...won't it?

Bingo !!!! Thanks to dhookom!!! It worked perfectly when I changed the name of the field in properties. I'm embarrassed to ask one more question, but here goes... currently the names and addresses are all in caps because I imported the data in its original form from an Excel worksheet and...

I corrected it but I still get an #Error message. I tried it by leaving the two extra text boxes off to the side and also tried it by deleting the two redundent text boxes The text boxes are in a group header section rather than the detail section of the report. Could that be the problem?

Thank you so much!!! When I tried it, I got an Error# message. Is it because I put CanShrink and CanGrow back to "No" for those name and address fields? My field names in the text boxes (on the first line of my name/ address section) are: Member Fname, Member MI, and Member LName. In the...

I created a report in the format of a personal letter to employees of my company. I based it on a query which pulls employee names and addresses (and some other unrelated stuff). The first name, middle initial and last name are in separate fields (as are address, city , state and zip) I need...