I am new to ACCESS and apologize for the naivette of my question. I am trying to set up a query that will show only entries that contain the chearacters "CV"...

I have a table which has various defects that may occur in an area. I want to create a query which views the data by the week in the year (i.e. the first...

I have a table with information pertaining to some doors. The doors each have a size, material and swing. I also have a rooms table that has various doors...

I have imported in MS Access 2003 a SQL Server table that has binary id columns. When I look at the design view for the table, the column type is binary --...

I need to a query to return all records where the serial number in the DATA.SN field appears more than once in the table DATA. Doing a count() on that field...

Here's my situation... I have about 20 pieces of equipment that must be maintained. We do 'weekly checks' on all of them. I have built a database that has...

I'm have 2 tabels. The first table have list of rooms and the second table have list of orders of customers(content RoomId feild and the fields incoming date...

I'd like to create a view that returns numbers 1 through 364. Ex: NUMBER 1 2 3 ..... The only way that I know how to do this is by using UNION: (SELECT 1 AS...

Hi, I am trying to get a query to come up with the salesperson and add up the total sales for the current date. How do i do this. SQL is fine. Thanks...

Greetings and thanks for the help! THis is truly baffling: I have a view in SQL server 2k. The view works fine from Query Analyzer (gives the correct result),...

Newbie,,sorry... I have a query that runs a list of al tasks outstanding by customer, from within that dataview i would like to be able to open the customer...

Is there a way to use an Access crosstab query like an Excel pivot table? That is, is it possible to click on a single crosstab intersection, and see the...

I have developed qryQuickLook that brings up rptQuickLook when cmdQuickLook is clicked, everything works great but I would rather see the results (never more...

Is there any performance benefit to using a SQL view over an Access pass-through query when using SQL server as the backend? -- sam

Is there any way to use a parameter query that allows the user to choose to view the results for either one specific criteria or view them all?

Is there any way to use a parameter query that allows the user to choose to view the results for either one specific criteria or view them all?

i have an access 2003 query SELECT ., .State, DateSerial(Year(),Month(),Day()) AS , TimeSerial(Hour(),Minute(),0) AS TimePeriod, Count(*) AS Total FROM...

I have a table Personnel and a Table EmploymentStatus. I want to write a query that will show all Personnel with most current Employment Status Only. Any...

Is it possible to view memo fields in an easier-to-read format than the datasheet view? I use forms, but this is not handy either. Any other...

HI I made big DB everything is working alright only Viewing last report. I have the report base on Query and in that query i made all the field Total as...