I have a dbs with the following fields: ProjMgr ProjLead ProjDesg ProjEng ProjQA TeamM1 TeamM2 TeamM3 TeamM4

I have tried several variations of doing this in staged queries or outside of Access in Excel and running import/export through VBA to accomplish the goal,...

I have data like this: Record 1: Doe, Jane Doe, 1 main street Record 2: Doe, John Doe, 1 Main Street What I what to do is the following: Doe, Jane Doe, John...

I need to do a select query based on a date and then add a note to a field in the database. In some cases there is already data in the field so I want to...

I am in the process of testing a database upsized to SQL Express 2005 (originally created through jet/local mdb). The data is comprised a couple dozen...

Could someone please help????? I am wanting to select the month out of date using a query but i am unsure how. The date in the table as it stands is...

Hi, All My query: PARAMETERS DateTime, DateTime; TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks SELECT AS Badge, Sum(Master.AmtVl) AS SumOfAmount,...

Hi, I spend alot of time trying to work this out but failed so please could someone help. Data: (this table the intday varies depending on the...

I am creating a query in Access 2007. One of the fields stores the path to a Word document. This path can be long and may look...

I have 2 tables - Jobs & Projects. One job can have several projects (or none!) Table 1 holds job details (jobid; jobenterdate) Table2 holds project (jobid;...

In the following there can be more than one (uniq_id) for the caseno in dbo.master. I need the max(uniq_id) or last per caseno. I can do it when I am only...

I am trying to total dat based on the quarter. I cannot find any functions for this. Does anyone know if there is or how to do this in a query?

Hello, I appreciate your help, the following is my cross tab query used in the report, however some of the records do not show up, could you help me how can...

I have the following data; Order Code Order Detail 100 AA 101 AA 100 BB 102 ...

In the course of our business process, we have to draft some documents and send them to another department (DJ) for advice. I have a table called "tblDrafts"...

I'm having difficulty in understanding times (although I've used them many times before) and getting the results in a query. Here's what I have. I have a db...

Archive data every year, have make-table qryArchiveData, which makes a table named tblArchivedData. What I would like to do is, ask user for input, "What year...

I want to know how many employees I have working in a given half hour with the state licensure they have. I have a table that has my employees, state...

Dear All, Currently I ask myself if the design of my database is wrong. I have several tables with a lot of fields which use 'Value List' as a row source...

I have a querydef that returns a set of records, sorted by the ID (autonumber) field. All I need is the first record in the set. How can I tell the query to...