Hello Foro Access 3003. In a form I'm trying to design a search where user only enter data in three textboxes. In a query I have the following parameter...

I have an Update Query that asks for 3 fields with parameters. The first parameter is the criteria in the query to identify which record we are updating. ...

Thanks to John Spencer, I resolved one problem in my union query (Thank you, John). But I have another problem. Some of my fields in my union query are...

I have some queries whereby I need to join two tables based on two date fields that are in both queries. Sometimes date 1 or date 2 will have NULL values,...

Hi all, I wonder if you can help. I have 5 tables of data with the same column names. I want to run a query which includes all records from all tables within a...

I have a table that tracks each customers visit to my store. I hold promotions on occaision that bring customers that haven't visited my store in awhile....

Why would a few blank fields show up in a query where I am using 'Is Not Null' in the criteria. The rest of the Nulls are filtered out - but there are 7...

I am looking for a way to query for the following: *T* The problem is the T is surrounded by an * which is a wild card. It pulls all the records with a T...

Hello, I would like to see ALL (0 and -1) records if my check box in my form is not checked (0) and if checked (-1) I would like to see only record with -1...

Problem: Eliminate duplicate values based on one field and still maintain the availablity of otherfields for the retained record. I sort on date to bring the...

Hi all! I am running a query in a subform where I sum a * . Units are imported from a csv file with 3 decimals and operation sign is either -1 or +1: For...

I work with Access 2007. I have a table with 4 columns: Date Mailed, 2nd, C w/o Inv, and C w/Inv. I can get the monthly totals by grouping on Date Mailed...

I am trying to decipher the “status� of records in my table based on two date fields and the name of the agent assigned to each record. The fields are as...

I have 2 queries that I am building another query off of. I have on query with the name of project contacts in it. I have another query with all the...

I have a simple scenario... We have a list of 20 items and I'd like people to identify the top 10 to them. I created a dropdown but was wondering if I can...

grupy wrote: Id like to know how I can query lets say a specific record from a parent-chil table For example, lets say parent table is Products using...

I have a SQL statement that returns an count and average amount paid for a customer in a table. I wish to alter the SQL so I only get the first X rows...

I took both of these if statements from a query in an access database and I am trying to interpret them. New Request: IIf(IsNull(!),0,!) Old Request:...

Hi Guys, Are you able to change the colour of a field dependant on the fields current value in datasheet view. When the output from a query is opened, I...

Hello I've been struggling with this all day, and although I think I'm near a solution (actually I thought that 2 hours ago!) it now involves 4 nested queries...