I am trying to create a query from several "preliminary" queries. Each prelim query is finding it's data in a different source table (partscost, laborcost,...

I am still in the process of learning MS Access and am trying to create a query for a newly created database. In one of the tables (CaseLog) the CaseNumber...

Hi, I have three problems, so please help me if you can: a) I have Table/querie with 2 columns. I'd like to create third column with constant text like...

Can someone help me with an expression for a query that will show groups of invoice numbers that are numbered sequentially (25601, 25602, 25603, etc.) for...

Hi, I am having a problem using Distinctrow. My understanding is that distinctrow looks at all query fields and will eliminate a row if the data in all...

I am trying to update a table by adding a sequence number that increments by 1 but resets upon a change in Vendor Number. Here some data: VendorNumber ...

Hi all, I have a database designed to track subscribers to our paper, print lists of subscribers for the carriers, print a pay request for our accountant,...

My toolbar options to align text to left, center, or right are grayed out. All of my columns are aligned to the right, and I want them to the right. I even...

Hi Groupies: I have a parameter query that retrieves appointments based on the school year of September to June. The problem is that we need to be able to...

I am trying to create a query that compares trial balance data from four different companies by account in the below format: Account Description ...

How do I delete spaces in between text? Trim doesnt work. And if it is Replace, what is the exact syntax? Thanks,

I am having a major problem with expressions in a query and saving the results. I have three tables so far in my data base named; tblChurchPmt, tblPmtType,...

I am trying to send a query expression from a form to the underlying query. the field type in the underlying query is date/time. Does anyone have an example...

I have a table where each record includes client ID and a visit date. Each client ID is unique,but there can be multiple records per client ID with different...

the following query is supposed to give me all non-null if "Published", or all null if "Unpublished, or both if anything else. It only works for Published. I...

I need a wildcard to let me look for all the value in a query in a specific field, asking me for something and I may type any character and the use of * or ?...

Through a query ive got a list of customers information and wondered if there was anyway to copy all the data in one field from a lot of records ie email...

HI, Please help. I am working on a project with over 200,000 counts. Someone suggests I use Access but I don’t know much about Access. The data I work on...

I have a main form ("employee") and a sub-form ("department subform") for tables "employee" and "department" respectively. What I need to do is update the...

After 4 days of trying everything I can think of and feeling really stupid, I now will give in and ask for help. I am trying to print an 11 page folded...