I read an old thread that ask for crosstab query into Form, new idea just popup

215 128KB

I have an crosstab query with date as column, and now want to show it as datasheet form, it'll be hell with a lot of code vba to do this (with rowsource = "SQL string" and requery)
and a new idea just pop up in my head.
instead of depend of crosstab update new date (new column).
just create manually 31 column for 31 days in month (31 is maximum day in a month)
and let give it the formula like this in column "day 1"

Expand|Select|Wrap|Line Numbers

sum(iif(day(ABC.datereceipt)=1, ABC.volume, 0))

"day 2"

Expand|Select|Wrap|Line Numbers

sum(iif(day(ABC.datereceipt)=2, ABC.volume, 0))

and so on till day 31.
then we nolonger need crosstab query update new column for us lol

my question is, do you think doing this will be effective ?
I gonna made datasheet with this idea.

Sep 26 '15 #1

Subscribe Post Reply

976

NeoPa

32,556

Expert Mod 16PB

HVSummer:
Do you think doing this will be effective ?

In short, Yes.

I cannot say how well you'll manage the idea but I know it can be done, and has been done before. Much depends on what you're doing with the data but certainly arranging by day in month can work.

Sep 27 '15 #2

hvsummer

215

128KB

okay, I'll use this idea for a lot of form, since report preview in DSform need to classify by day/month/year

Sep 28 '15 #3

by: Donna Sabol | last post by:

First, I should start by saying I am creating a database to be used by some very impatient, non-computer literate people. It needs to be seameless in it's operation from their point of view. I...

Microsoft Access / VBA

Crosstab query reports (unknown fields in reports) What about sorting?

by: Mat N | last post by:

Hi, I've been trying to work out how to create a report based on crosstab query for which the number of fields is variable. For example in a situation where you show customer billing by year in...

Microsoft Access / VBA

Access 2003: crosstab query won't use reference to form

by: DFS | last post by:

I've been working around this for years (I believe), so I figured someone here might know: Why won't a crosstab query accept a value from a form reference? TRANSFORM...

Microsoft Access / VBA

Crosstab and Form questions

by: Sherman H. | last post by:

I have a few questions for crosstab and popup form questions: 1. I created a crosstab as follows: IT Financial Operation John 21 22 ...

Microsoft Access / VBA

Desperately Seeking Help Filtering a Dynamic Crosstab Query Report

by: Richard Hollenbeck | last post by:

I tried to ask this question before on the 14th of January but I never got a reply. I'm still struggling with the problem. I'll try to rephrase the question: I have a crosstab query with rows...

Microsoft Access / VBA

CrossTab Query with Parameter

by: tizmagik | last post by:

I am having a lot of difficulty generating a CrossTab Query based report. I have looked online for several tutorials and whatnot but I have not been able to really find what I'm looking for, nor...

Microsoft Access / VBA

Problem with Crosstab Query in subform

by: russellhq | last post by:

Hi, I'm fairly new to access and have a little trouble with a crosstab query I've setup. I have a main form where the user selects a project name and below in a subform, a crosstab query is...

Microsoft Access / VBA

How to create a form based on a crosstab query? (I don't know howmany columns there will be!)

by: Paul H | last post by:

I want to base a form on a crosstab query. The query shows statistics for a user defined period. The column headings will look something like this: ClientID Month01 Month02 Month03 etc.. ...

Microsoft Access / VBA

Problem with date in CrossTab query

by: Jim Devenish | last post by:

I wish to create a crosstab query as the record source for a report. It needs to count data between selected dates which are entered by the user in a popup window. The following Select query...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

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,...

General

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

AI Job Threat for Devs

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,...

Career Advice

I read an old thread that ask for crosstab query into Form, new idea just popup

Similar topics