Hello everyone
I have an interesting question.How can i convert data in rows to columns as
in time series format
Example

I'm trying to concatenate strings in a calculated query field. Although
Access accepts the formula, the length of the calculated field is limited to
about 254-256 characters (I keep losing count, but it's right in the magical
256 character neighborhood).

I need to create a Query that only shows me the 160th record, 320, 480 etc.  
Can anyone tell me how this can be done?

I have two tables:
Table A
     Key1    Key2
==============

I would like to enter a date and automatically have a query return records
between that day and 5 days out.  I know I can have 2 prompts and have the
user enter a start and end date.....but since the end date is always 5 days
from the start date it would be nice for them to just ...

I am currently creating a query of payables data based on payment term
information.  I would like the Vendor ID count to be distinct.  When I insert
a Count(Distinct zapv.pymt.vendorid) I get a syntax error.
SELECT ZAPV_PYMT.[Payment Terms ID], Count(ZAPV_PYMT.VendorID) AS

So I've looked up and down this site and have tried the examples you gave but
I still can't make my rows concatenate. I've been trying to work off of
Duane's example and have built my database the same way he has. So here it
goes this is what I have.

I'm using Access 2002. Is there a way to call a SQL stored procedure from
Access? If so, how do I do that?
thanks for any ideas

I have a query that pulls all of the Invoice #'s but I dont want it to pull
Invoice # 1, 6651, and 2. How can I exclude these from the query? Thanks.

I have a Database which to save time training management levels how to use i
have created an excel analysis pack which is sent to everyone, i have 3
queries which i just open manually and copy and paste into the excel file
named "review.xls".

HI
I have a project where i need to compare two sets of databases and see where
they match up or not. I one of the databases is using DD-MM-YY data standard
format, while the other is using the YYYYMMDD. I need to convert DD-MM-YY

SELECT feedback.id_user, feedback.risposta1, feedback.feed_value ,
(select count(id)  from feedback where id_user =7  and  feed_value =
feedback.feed_value  and risposta1 = true ) AS Espr1
FROM feedback

I would like to know if there is any way to create a crosstab query with 4
row headings or do I need to create a report instead?
Thanks.

What is the maximum number of records that Access 2007 can handle?
My friend wishes to set up a disco database containing all his tracks
- and he has over 24000, needing 11 fields per record.
Reply via Newsgroup

I am trying to set up a commissions report.  
Here is my commission qualifier:
If the $ value of the items sold  (this is a calculated sum) create a total
sales amount of more than $2000, commission is due.  If it is less, no