I've been reading a lot of the current "split" posts however I can't find one that is similar to my problem. My tblProfiles has 2...

Hello, I need to sort a crosstab query by year. I have 2006 data that I don't want to see, but would like to keep. Any help is appreciated. Here is the...

Would anyone point me to a function or SQL that would concatenate all of the records for a single field into a single field while using a group by. What I am...

How can I create a criteria in query or by other means, to retrieve a select record from an AutoNumber field? In other words pull up record by entering one...

Hi - I've been looking over several posts regarding the conversion of an adjacency model structure to a nested set structure, but they don't look like "MS...

I am attempting to build a query based on data in two tables. In the first table (Contracts) I retrieve basic contract data. The second table...

I am having trouble with this line in my sql statement. IIf(IsNull(DSum("OTHours","tblOvertime","EmpID = " & tblEmployee.EmpID)),0)+ AS OTBal It puts...

Please help! I have a Report that is getting it's Data from a Select Query. The Query has five Columns named, Pass/Repair/Reject 1, Pass/Repair/Reject...

Hi All: This works in SQL Server not in Access, I was hoping someone would be able to translate this SQL statement so it will work in Access (if Access...

Do you know of any method of combining three fields into a new field and cutting out the blank spaces with a trim statement? -- Chigger Hill

I'm trying to build a query that looks at records with activity type, "submitted", "reviewed" and "forwarded" for job requisitions. A new activity record is...

I Have built a database that stores general patient data and is connected to another table for the patients' children in a one to many relationship. The...

I am trying to create a switchboard that would provide a forms view only to a query named "Monthly Ranges" that can be accessed from the desktop. Also I...

In my query i will need to remove first number, if it's a first number showing '1', then remove '1', if not then do nothing. for example i have this data in...

I have a pass-through query ( execute pass_through, 1, 2, 3 where 1, 2, 3 are parameters) that works very well when executed directly in our Sybase database....

Is there any way to save SQL formatting with a saved query, Instead of the SQL all being bunched together? It is easier for me to visualize what is going on...

Hello, I have set up a query that runs against a table where I've listed vacation time for each employee. The query contains a new field with the following...

Hi, I have 3 tables: Canada, US, Europen Registration and each table have their own unique column headings but they all share the same heading for part...

I've created the below query that calls another query. The first query (qryPartChanges) produces 1302 records and the below query produces 4032 records. I've...

Scenario: Table1 Stores: StoreNumber, Address, SKUNumber, InventoryLevel Table2 Products: ItemNumber, Description, Size, ect. Table3 Stores_Products:...