In have the following in my first field. K:IIF(=1,"2",IIF(=2,"1","")) I have the following in my second field. H:IIF(=1,"2",IIF(=2,"1","")) What would i...

I have a query with 10 fields. I need the query to return only the records where one of the 10 fields is NULL. The design window only allow 8 'levels' of...

I have a query and would like to have optional parameters for the users. Because I have more than 10 optional paramters which MS Access gives me query too...

I created an Access database before ID theft was even thought of and would push my clients' info to a handheld device with SSN and birthdates if I ever had...

Hi - I use and as parameters in the criteria area for a column of a query. I also have and columns. For the most part, when the query is invoked, I am...

How is the primary key established when a make table query is used?

I am passing date values from text boxes on forms into query criteria. The field name in the query is: "Critical Date: CDate(DateAdd("d",-, ))". is a date and...

For reasons too obscure to describe, I very much like to segregate my overall database into several .mdb files. The main file contains queries and joins, the...

Hello, In my query results I want to show only 5% of the results. I know about the TopValue which will show only the top percentage of the query...

We have an extensive database with information pertaining to incarcerated individuals. On each form, there are fields with dates and identification numbers....

Hi, How do I do a date restrictor that gives me month to date numbers (June 1 to June 16th) . Also, How do I get a date restrictor for last june month to...

Using Access 2000, have query linked to excel worksheet. When query adds another line of data, info doesn't display in excel. Query is a crosstab with rows of...

I am trying to find the easiest way to make a report or something that resembles an excel spreadsheet. The closest thing I have found is a crosstab query....

hi i have a query where i need formula to numerate records from minDate to maxDate reffering to CUSTOMER_ID to make a valid invoice number. here an...

Dear developers – I have a problem that I can’t find the solutions for. I have a table with products. It is simple to find the max value, but is...

I need to perform calculations between rows within an Access PivotTable and I need some help in figuring out how to do it. I posted the question earlier and...

Boy I'm really rusty here, haven't used Access for a few years. Have one simple (but large) table with 4 fields: date, time, amount, and...

Hi, All, I'm new, confused and apologize for the interruption, but I've got a puzzle and hope someone can help. I have a table that is growing and now has...

I have a table which has 5 primary keys. I am having a problem when I try to run a DELETE statement. 3 of the Primary keys are a Date/Time type. The error...

I need to display on the same A4 page more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it...