Recent content by jamphan

Yes, once I wrote it out to you guys I figured it out. Sorry and thanks!

I am trying to create a field that is a YES NO based on 2 other fields. I want to say if Field A =1 OR Field B =1 then YES, otherwise NO. I am having trouble with the OR part. Any help??? Thanks!

I have a large Access database with 140,000+ records. I would like to be able to link this with Excel but have it in a pivot table or something similar so the user can only select a small portion of the database. If I could create a query of some sort in Excel to query the database that would...

Any help?????

Not exactly what I had in mind. I don't want the 2 phone numbers to become one number I just want the 2 numbers to be in the same table field list so I can say # 123 is a fraud number whether it be work or a home number.

I should say I want to combine the data into one field not table.

I am trying to capture merchants who submit multiple/fraudulent phone numbers. I just want to combine the results for my "fraud" phone numbers, work and home together in one table. My question is how can I moved the data from 2 fields into one field.

I have 2 queries that return if the results occur more than once in the table, one for Home Phone and one for Work Phone. These are 2 seperate fields in my table. I would like to combine the results for the phone numbers to make one master field for multiple phone numbers whether its home or...

I have a table that I need to update existing data and append new data. All of the new data is in the same file. Is there a way I can update and append at the same time?

I have a calculated field in my query that takes the difference between to incomes. I want to format this field to currency. How can this be done?

I have a table that has records listed more than one time. Some of these multiple records have in the score field a zero for the score. I would like to remove all records that are in the table more than once that have a zero for the score in the score field. Any help is greatly appreciated!

I have a report that is tied to a table. On my table form I have a button that prints the report. Is there a way to only print the report for the current record showing on my form?

I want the other records to be able to be accessed though. That seems to erase all the other records from the form.

thanks! How about getting it to advance to a new record when it opens?

How can I get a form to open when the database opens?