I have a name field and it has multiple commas in it: last name, first name, i am trying to split it out into two different columns but the second comma is...

Some people decided to play a cruel joke and pulled two commas into a name field and i need to split the name into a first and last name column. Normally i...

Hello! I tried searching for an answer to this question but didn't come up with anything, so forgive me if this is a repeat. A while ago I asked a question...

Hi guys, I've had this problem before and never fully resolved it so am trying again, this time with a different tact. I have a form containing 6 combo boxes....

Hi I'm wanting to setup a form that displays various combo boxes relating to previous orders. I want the user to be able to select various criteria in each...

Hi I need to create a query based on various combo boxes, the idea being the user selects the criteria for their search by selecting parameters from multiple...

I have a table with 6 columns: ID, Name, Date1, Date2, Date3, Date4 Each of the date fields is a different date, and they are not in chronological order...that...

Thanks in advance for your responses I am creating one report with several columns that pull data from 3 different tables and are based on different date...

Thanks in advance for your responses. I am creating one report with several columns that pull data from 2 different tables and are based on different date...

A couple days ago I needed to sum currency values and count the number of contributions to the values. I created an intermediate pair of crosstabs and...

I have a table of data listing interests of individuals that is a list as below; Person1: Interest1 Person1: Interest2 Person1: Interest3 ...

I have two tables in my database. One is a master containing an Item# Field and a Item Description Field. The other table is a Bill of Materials table. This...

I have a table with multiple columns Lets call them A B C. They may (or may not) contain values Hence the data in a single row might look like ColA, ColB,...

Hi All, I don't know if this is possible to do in crosstab query but needing to know how I can have multiple column values. Here is my table: Payment...

I need to sort on multiple fields within a query. There are 5 fields that are being sorted on, the first 3 being asc. The 4th field has an data entered as...

Hi. I have a table with 15 columns (name, surname etc.) There are blank some fields. Is there a way to design a SINGLE query that counts blank fields and...

In know my share of SQL but im new to Access. I know what crosstabs are and how to make them in Access. However, it seems only one database field can...

I need to take a column (Skills) that contains multiple codes (CO;WE;PS) etc. and turn each code into a row. I tried using Switch, but that only works if the...

Is there a way to write this query in a more effeciently? Can I combine the '(SY=2006 or (SY) Is Null)' clause into a single clause instead of having it in...

I have a table that contains all the classes for 3800 students. Each student times 7 gets you around 23000 classes, each record contains: SSN, LocalID, Name,...