by: Sridharan |
last post by:
Hello All,
Below is how my data looks like
Branch Item Customer Sales
10 1 C1 300
10 1 C2 400
10 1 C3 200
10 2 C1 500
|
by: David |
last post by:
This might be a report question but I think it is more a query issue
than a report. I am a novice at bothAccess reporting and queries and
have been struggling to build the following. (Note using...
|
by: John |
last post by:
I've read several prior posts in this group about using nz() to
convert null values to zero; however, I'm not sure how/where to
implement this function in my crosstab query.
The crosstab query...
|
by: schan |
last post by:
Hi there,
I was wondering if someone could shed some light on a problem I have no
idea on how to fix.
I created an Excel Add-In that uses an ADO connection to an Access
database on a file...
|
by: manny |
last post by:
I wish I knew what this was called, and I could have made a more sensible
subject. For that matter, I knew what it was called, I could have googled it!
Anyway, let's I have a table with name,...
|
by: wakin |
last post by:
When I place the following in my query
ProductivityHours:
IIf(!=85,actualtimeintounittime(),IIf(.=231,3,Sum(IIf(!=33,!/60,IIf(!=102
Or !=158 Or
!=219,0,IIf(!>12
And...
|
by: Garmt de Vries-Uiterweerd |
last post by:
X-posted to opera.page-authoring, because this is a bit Opera-specific for
the moment. F'up to ciwas.
I am playing around with dedicated styling for the projection media type..
Currently the...
|
by: =?Utf-8?B?QHdpbg==?= |
last post by:
Hi there,
Im trying to get the MIN(dDateTime) of a datatable in a dataset generated
from a XML file.
I have tried the .Select and .Compute methodes without success.
drs =...
|
by: nico3334 |
last post by:
I'm having trouble with a query using "MAX". In my query I'm trying to use 2 date columns as my criteria. Here is the format for each column:
Date1:
01/01/2007
Date2:
200701
For my...
|
by: jllanten |
last post by:
I will appreciate any help you can provide me.
In the company where i work we have a project which creates about 4-5M records daily of stats. We're currently storing this data in a db named...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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,...
|
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...
|