I have a ACCESS07 table that has a field called Unit, and another field called Members. Each unit can have up to 48 members, and there are many units in the...

I am attempting to use Duane Hookom’s concatenate function without any success. I’ve read many threads, relating to Duane’s function, yet none seem to...

Hi all, probably a very basic question, but I am having a bit of a problem setting up a parameter query. I have access connecting via ODBC to an external...

How can I make a query so that the criteria for the parameters are a drop down list of the values in that field. For example, if the field is "Country of...

Hi, I can't remember how to convert columns into rows (I can do it the other way round). I have the following...

Hello All, Have a SQL DB (MySQL), a table(tblUPL), a column in the table(CompanyName) An Access2003 Frontend (OurWork.mdb). A form (ClntName) a field inside...

I am trying to create a query that will show me all the records in my qryZoneProcess even if there is no match in my EMPInfo table. I have the following...

Hi all, I have 2 queries. I comebined them but some records are missing. The situation is as follow: Query 1: SELECT Distinct PartNumID AS PID, Manu,...

Hi. I am a complete novice in using Access and am trying to figure out how to transpose rows to columns in Access. The data I am trying to transpose are the...

I am building a contact database. I have populated several tables with data for various types of organizations. I am now ready to begin populating a table...

Display last game for a given player: Table1: ID Player Game date time Gender City 1 PL1 G1 d1 t1 M C1 2...

Hi. I'm working on converting a data file into a text file format that my other system reads. The data file of mine contains 5 different numeric fields but...

I have a crosstab query where column headings are dates and rows are names. I want to query the crosstab query to show a specific range of dates, so I set up...

I have a query that I run by date(s) . How can I run a query to find out a total of how many records were entered in that period. Thanks

duplicates based on two fields see table below.. INB/OUT, ORDER#, LITEM# IN, ORDER1, item1 IN, ORDER1, item2 OB, ORDER1, item1 IN, ORDER2, item1 IN, ORDER2,...

I have a simple query which finds the "work date" for a specific acivity from a table. In most cases there is only one work date, however, in some cases...

I have the following two tables: tblVendor (key field vendorID) tblInvoice (key fiend invID) I have a simple query that pulls all the invoices I've ever...

PLEASE HELP! I have a combo box that pulls class data from a query: course ID, course name, and start date, in that order. Currently when the user makes a...

I don't know how to use the function to change the data type in my query. I have two link tables and i want to link them but, the column of both link table...

Hello, I got a query trying to calculate the number of days between two days excluding weekend and holiday. I have a query for qryHolidays. How to put in...