|
by: Justin Koivisto |
last post by:
I am trying to create a report that displays a name of an advertising
source and count of the number of times it was hit between certain date
ranges. The data is split between two different databases: this access
db, and a remote MySQL server. The MySQL tables are linked in the access db.
What I have done so far is created an On Open event for a report that
does the following:
* prompt user for the date range
* get which sources were...
|
by: Sami |
last post by:
I can create queries and reports based on info from one table. How do
I create one using information from multiple tables. What do I need
to make sure the information from one table will be correctly assigned
to specific person from another table?
Thanks.
|
by: Florifulgurator |
last post by:
Hello,
trying to clean up other´s mess...
I´ve replaced some tables (previously linked to another Access DB)
with renamed tables linked to a PostgeSQL DB (removed spaces and
Ümlauts in names, secured referential integrity).
There´s one (probably more) report that doesn´t get the new name:
|
by: Isabel Puigdevall |
last post by:
I'm trying to create a report in a dotnet.asp project. I made the report in
Crystal Reports based on a dataset with two tables linked in a one to many
relationship. The output report shows me duplicated records. For example, if
one person has two medical visits I see four visits, two of these are
completely duplicated.
I don't understand why because the relation between the two tables has been
defined.
Has someone had the same problem?...
|
by: Jer |
last post by:
Using Access 2003 w/Windows XP.
I have a database originally created with the tables internal. I split
the database into a front-end/back-end with linked tables. Now when I
open one of the reports, I get #error in some of the fields. I created
two new databases from scratch and imported the front-end objects into
one database and imported the tables into the other and re-linked them.
I still get the error.
The report is opened from a...
|
|
by: me321701 |
last post by:
I have an Access 2003 MDE with a SQL Server 2000 back-end using ODBC
linked tables. The MDE is shared among approximately 20 users.
This is the environment; I don't have the ability to change it at this
time.
New reporting requirements really need to use an UDF to supply the
result set. Which I believe requires a pass-through query.
After changes are made to the development MDB by the development staff
|
by: Jana |
last post by:
Hi!
I have an Access 97 report based on tables linked to an SQL back end.
The report has 5 subreports in it (unfortunately unavoidable due to the
nature of the report) and performance is quite slow. The query runs
quickly and the report displays the first page in a short amount of
time, but takes quite a while to format each page. This means it takes
a long time to print the report (up to 50 mins to print around 360
pages!) as it...
|
by: peterkennett |
last post by:
I have three tables, all linked.
Table 1 "job" has an autonumber ID field.
Table 2 "tasks" has a field that is linked to
Table 3 "staff" has a field that also links to
The purpose is to track multiple tasks and multiple staff who are working on a single job. There can be a random number of tasks per JOB, and a random number of staff per - so I have separate TASK and STAFF tables but they are linked to . The tasks and the staff are...
|
by: patriciashoe |
last post by:
I have a database that consists of several tables all linked by a school id number.The other tables hold data related to the schools. Another field common to all tables is a date field. I could use some direction on how to structure a query that selects data by school and year. The linked tables hold data for a number of years and I need to query and report on just one year at a time by school. For example, for each school I need all the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|