Hello, i have the foloowing query in access;
SELECT dbo_AnalogHistory.DateTime, dbo_AnalogHistory.Tagname,
dbo_AnalogHistory.Value
FROM dbo_AnalogHistory

Hello to all
i try to have a view but i am confuse
i have 2 tables (A and B
tb A fields: DateIN_A(date) | Cat(integer) | CatA_ID(text)

I've tried to create a query that identifies the last record entered into a
table. The field I'm using with this totals query is called projectID which
is defined with an autonumber format. Each time I run the query it returns
the record with ProjectID=93 but there are 108 ...

Is their a way I could create a "cut query". What I mean by that is to cut
data from one table and place it in another. Sort of like an update or append
query, but I need the data from the original location removed.
If that is possible can that query be but on a form in a button?

This one shows up on access monster as bein solved but it isn't so I
thought that I would repost
Hello,
I have a question that I was hoping that someone could help me with.  I

I have a table with about 300,000 records. Many are duplicates. I'm trying to
create a make-table query to get only 1 copy of each record while ignoring
the duplicate records.
Does anyone know how I can do this?

I have a question that I was hoping that someone could help me with.  I
need to know if two events are happening at the same time.  For
example:
Joe Smith was working on  project A from 1/1/2006 to 1/31/2006 and was

i have my new data base built but for the love of god can i get the
expression right this.
in my query i need, when prompted it asks for a date, and when i put in
21/11/06, i want it to bring up all records for that week( monday to sunday).

I have several queries wrote where I have set the criteria to input the
[beginning date]and[ending date] and I want to capture all the data in
between.   I also have a lookup field that allows me to select the Pay Period
Ending.  Is there a way to query on the [Pay Period Ending] ...

I have an interesting challenge with a couple of CrossTab Queries.
I have a crosstab that gives Project Resource and then Forecasted Hours by
week.
I have a crosstab that gives Project Resource and the Actual Hours by week.

I have (2) tables that were imported into access from excel.  However, the
data has a  combination of letters, numbers, and dashes in it.  That will
make the data type as Text.  Included in the data are spaces before and after
the text.  I want to remove the spaces so that I can ...

Hi!  I have created a small  form with a combo box which I am using in a
query.  However, when I call the form from the query criteria, it is not
bringing up the actual form that I have built.  It brings up a regular
parameter box that reads exactly what was put into the criteria ...

I'm very new to this so forgive this idiotic question.
I've managed to set up a parameter query. However, I don't know how to apply
Boolean operators so that if, for example, "coffee" is in one field and
"report" in the second or third fields, how do I ensure that I get "coffee

I have an adp application that uses a very large DB (SQL server 2000).
The tables are large and querys might take more than 30 sec to complete.
My problem is that the CurrentProject.Connection.CommandTimeout is read only
and cannot be changed using VB (no idea why).

Good day,
I am trying to create a report that is based on a query. How do I Only
display the top ten items by highest volume?
Any help would be apprceiated.