Field names in an append query
I am attempting to append one table with another. I have several fields
whose names are in the form of xxx - yyyy, aaaa - bb, etc. There is a
space on either side of the hyphen. One of the fields, named "name - last"
(no quotes) is not being recognized, for a reason I can not understand.
Therefore the query will not run.
I have tripled checked that the names are in fact exactly duplicated in each
table and that the properties are likewise duplicated.
I am at loss to determine what the problem might be?????
Are you doing this from the QBE grid in design m...Windows Terminal Server 2008 / non-clients need to access internet
I have a terminal server environment. I have access points all over the
school. I would like visitors to be able to access the internet but in
order to get on you have to open a session. How do I get it shared to
rubantin's Profile: http://forums.techarena.in/members/190718.htm
View this thread: http://forums.techarena.in/windows-server-help/1311934.htm
"How do I get it shared to non-client pcs?" Do you mean with ...Need a report or query(?)
I have a table of class information that contains class name, start date,
instructor, start time and days held - the days held (if more than one day)
repeat in separate records.
I need to end up with one record per class that shows class name,
instructor, start date and the days and times held. (Also in the mix is that
times held can be different each day held.)
Where do I start? A query? Two queries?
I started by creating a table and grouping on class name so I have a table
with non-dup class names...now, I am dead in the water!
Thanks in advance!
On Tue, 18 May 2010 0...excel pivot table with sql query and visual basic macros
I have a pivot table that runs off a sql query, it has macros and parameters
built into the report. It worked until the client updated their server and
When debugging this, on the module under the closedb it stops here:
'IF CONNECTION IS OPEN IT NEEDS TO BE CLOSED SO AN ERROR IS NOT THROWN
If rsData.State = 1 Then
Set rsData = Nothing
Set cnData = Nothing
Set Cmd = Nothing
...Top Sales days top z report days report
Does anyone know how to find my top sales dates/ days with highest sales
/highest z reports ?
Does any one know how to find those in RMS?
Is there a custom report for this ?
Do you want to look at your past journals/Z reports and print a new report
in descending order by sales showing dates? Over what period of time: last
month, quarter, year...?
Pacific Computer Systems
Supporting Business Since 1985
Phone: (808)395-8156 or (808)277-8156
> Does anyone know how to find my top sale...Quote reports
I have gone thru 3 months of this newsgroups and i can not
find one definate answer on how or if it is possible to
change the layout of how the form prints out and the
content within the printed report.
I do not see where in crystal it is generated is it
possible to create a custom layout or report?
Any help is REALLY appreciated
you need to load crystal reports 8.5 on a machine other than the crm
servers. You then load up the crystal addon for CRM on top of your crystal
reports install. Once you have this you can get crystal reports to open a
report from the crm server t...Report Header Question
Hi, hope someone can help me with a problem I've run into whilecreating a report.I have a report where I must use three different Headers to obtain theinformation I need (Downtime, ProductNumber, and CustomerLotNumber).The information is in three headers, but in different locations ineach header (which if combined, could be in a straight line). Theclient wants totals for the information pertaining to Downtime,ProductNumber, and CustomerLotNumber, but he doesn't want them bydetail. The only way I could think to accomplish this was to createseparate Headers which would give the informa...Need to build a MS Dynamics GP Test Server
Hi, I need to build a MS Dynamics GP Test Server. The plan was to install SQL
Server 2005 and Dynamics GP 10 on a server, then copy and attach two
production databases. I've done that, but the users IDs are invalid. The user
ID can't be deleted because GP says the IDs are not in the Database. I found
an alternative in the article "How to transfer an existing Microsoft Dynamics
GP, Microsoft Small Business Financials, or Microsoft Small Business Manager
installation to a new server that is running Microsoft SQL Server" but a
crucial script is unavailable. If anyone has ...Modifying and creating custom reports
I just started working on custom reports for CRM. I followed a useful
post here and set up Visual Studio to view the CRM original reports. I
am a little lost on how to start so if anyone could answer me these
questions, it would help:
- Am I supposed to use Visual Studio to edit reports and create new
ones? Or maybe Crystal?
- Can I customize the filter? How about those Include/Exclude drop-
down boxes--can I default them?
- Where should I setup the connection? Do I use Windows or MS SQL
Any starter help or link would be appreciated. Thank you.
Visua...Using a dll to generate report data
I am assessing whether we should move to reporting services to make
available various company reports via the web.
While most reports have a stored procedure origin for their data, there are
a few of our reports that require some programatic massaging.
These reports typically involve some specialised data pivoting and/or
My question is, can reporting services utilise a custom dll as the source of
data for a report? As an example, reporting services can generate a report
from a stored procedure via a select statement. Can reporting services build
a rep..."Spending by category report"
I am using Money 2004 Small Business and when I goto "Personal Reports |
Income & Expenses | Spending By Category" and I try to "Customize..." the
report there is 1 "Asset" account missing from the list! I have a loan
account setup and I have the interest set to "Business | Interest Income"...
unfortunately this income doesn't show in this list. Even when I pick the
"Interest Income" category! It appears the problem is that the account in
question is my list of "Accounts".
I can't for the life of m...Run SSRS stored procedure report from a CRM 2011 for a current record
we need to run a SSRS report created via stored procedure for the
current record in a custom CRM entity .
we completed creating stored procedure , but pre-filtering is not
working . when we tried to preview in visual studio it is picking up
the lastest record values only .
Could any one give some suggestion to resolve this issue ?
...Varying page Excel report
I have an Excel template in which I import data that is of varying records.
Sometimes there are 3 records, sometimes there are 50 or 200 records. I do
not know how to make a varying page Excel report.
(For example, my clients sometimes want to see data on top 3 occupations,
sometimes on top 50 occupations.)
(The template is formatted, has headers, footers, a few links, works fine.)
Using Excel 2002.
Perhaps I'm missing something, but there should not be any need for
adjustment. The number of pages will be based on the number of records being
printed as long as you have ...I need elegance.....
I'm stumped and asking for elegance here....
I have a table that doesn't scale in a linear fashion
(it is for use with computing the langolier pool water index)
when I check the water I get a test result to compare to my table,
and I then take the result from the other side for further computation
what I want is for a test result like 35- I'd like to get a formula
response that is .06
so I'd like a formula that finds
which two table numbers it...Query Q
Im tring to categorise some records based on a rule which says;
we have a 2 hour grace period, then every thing is categorised different.
we have a bunch of duration values, ie 2hr, .25hr, 1 hr, whatever.
If the event is over 2 hours- then it is category 2.
if we have 1.5hr first, then we have .5hr left of grace- anything longer
will be cat2.
ie, this is what i want the query to return....
..5hr -grace period (first .5hr grace used)
3hrs - cat2
1hr -grace period (now total grace is 1.5hrs)
1hr - cat2 (because now we have only .5hr grace left)
..5hr -grace (now all 2hrs grace is ...Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.
Operating System: Mac OS X 10.5 (Leopard)
Hi, <br><br>I am using a MacBook Pro with OS X version 10.5.8, and Excel 2008 version 12.2.4. <br><br>A colleague emailed me an excel file (.xlsx) from a PC, and when I try to open it, excel crashes and the following dialogue box opens "Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience." <br><br>Below is the error log. I hope you can help. <br><br>Thank you for your time. <br><br>Microsoft Err...List box (and queries) not sorting dates or showing correct headers
I have inherited a system with a search function screen that is acting
weird. There are actually two search screens, both constructed in a
similar fashion, but the first does what it is supposed to do and the
second is misbehaving.
The form has a bunch of unbound controls allowing the user to enter
search criteria. The only mandatory criteria is the sort order, which
is set from a combo box. The data source for the combo box is a table,
sys_GAPSSortBy, which contains a list of query names and a user-
friendly label for use by the combo box. When the user clicks the
"Searc...Formula help needed #4
I am very new with excel. If I have several fields, each of which records
the number of a particular item - Say Field A (item 1), Field B (item 2),
Field C (item 3). When I create a report, I can see how to get the total of
items in each individual field. However, I cannot work out how to add
together the totals of Field A, Field B, and Field C to get a total of all
items. I imagine that this involves inserting a formula somewhere, but I
cannot work out how to do this. Can anyone help?
if you're very new with excel.. PLEASE i beg of you-- run away while
you still can
Excel is...Creating a Report from Landed Cost
Hello Great Plains Gurus!
I am attempting to create a custom report in RS2005 to show estimated
landed cost VS actual landed costs as well as if the landed costs for
each shipment, and I am having a hard time understanding the data
structure in order to join the receipt tables together. Basically all
I need to get started is a query/or generally how to relate actual
Receipt Numbers for landed cost invoices to the Receipt Number of the
IE I have RCT00216 that is the actual shipment receipt and RCT00220
that is a Landed cost that I am applying to the shipment receipt. I
wo...need help using a checkbox to determine if a cell gets summed
need help using a checkbox to determine if a cell gets summed. i have
designed a worksheet with items in one column, and how much the item is in
another column. what i want to do is to check a box next to an item and have
the cost of that item added to the other items that are checked. if the item
is unchecked, then resum the items that are checked. i would also like to
add an additional check box that will automatically check or uncheck all of
the other checkboxes. any help will be appreciated.
I put my items in B2:B20 and the costs in c2:c20.
Then I ran this macro to add the che...data in queries
From a dataset I retrieve customer names and the products they have
client name product name
client 1 product a
client 1 product b
client 1 product c
client 2 product b
client 2 product d
client 3 product a
client 3 product e
No problem. But how can I avoid the repetitions in the ClientName column:
client name product name
client 1 product a
client 2 product b
client 3 product a
In Query View. I think in a Report this is done through Group By?
Thanks ...Budget report #2
I have income that is retirement income. The category assigned is recognized
by the monthly reports and they correctly show this as income. My problem is
the budget report. It will not identify and show this category as income
despite a lot of trying. How do I get this to pick up on the budget report?
The frustrating thing is that it shows in the monthly reports. I have
checked and I show this category in my budget definition. Ideas or help?
...Report With Tax Sales ...
Can anyone help me to make a report with like ammount of non-taxable sales ,
and taxable sales, so I can make my accountant happy ?:)
Try the detailed sales report.
"Ashot" <Ashot@discussions.microsoft.com> wrote in message
> Can anyone help me to make a report with like ammount of non-taxable sales
> and taxable sales, so I can make my accountant happy ?:)
> Thanks ...
Use ths "Sales Tax Anylasis" Report this will give you both Taxable and
non-taxable ...log of printed reports
I have a set of reports that I print on a regular basis. I need to be able to
keep a track of the date and time at which each report was printed in a table
of query so if it goes missing, i have a record of whether and when it was
printed. I have been unable to come up with a way in which i could generate
this automatically. I would be thankful if i could be helped with this.
Create a table with columns ReportName and PrintedDate. Let's assume you
name the table ReportLog
In the Close event of each report, put code like:
Dim strSQL As String
If MsgBox("Did...Report/Subreport Help please
I have a main report and subreport. Within subreport there are 5 subreports.
When I printview my main report the main report is addressed to one doc and
subreport lists pts. Pts can be one or more than one with different reasons.
The subreport report is a report that has in the subreports different
references for the reasons. I only need to have this part of the report just
be listed once even though there are several pts with the type of reason.
How do I get the sub report to only only once the reason type. Thank you