473,287 Members | 1,880 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

cross reference query

Hi guys,
I have built a cross reference query (columns is year).
I would like to change the caption and adjust others things.
The best way would be to wrap the query in a form, but soon
2007 will begin And I will have to maintain the form.
I worry mostly about the caption of the cross query.
How can I change the caption of a cross query without use a form.

Thank you all

Maffonso

Jul 14 '06 #1
3 5659
Hi Maffonso,

To edit the query field caption (I hope that is what you are asking
about) is type something like this for each field that you wnat a custom
caption for - in the "Field" box in query design - say your table has
fields named fld1, fld2, fld3

in the query design you do this to change the caption for each field

customCaption1:fld1 customCaption2:fld2 ustomeCaption3:fld3

you are modifying the text in the field box by adding your customCaption
followed by a semicolon : followed by the field name.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Jul 14 '06 #2
Hi Rich,
I mean caption that caption in the blue bar at the top of the window.
By default the caption in the blue bar is the name of the
query. For example: qryMyQuery:cross reference.
My probem is that if I use a form, each new year I will have to
create a new column. For example: when 2007 comes I will
have to create a 2007 column.

Thank you
Maffonso

Jul 18 '06 #3
>>
I will have to
create a new column. For example: when 2007 comes I will
have to create a 2007 column.
<<

The statement above suggests incorrect usage of an RDBMS - relational
database system. Even though Access is not as sophisticated as Sql
Server - it is still a relational database system, and Jet Sql operates
under the same rules as Transaction Sql (sql server Tsql). That means
that adding a new column to a query that is already in production would
be introducting redundancy into your system. That means that you are
denormalizing your database - which means that you will have the
problems that you are posting about in the first place.

The solution to your original post then, is to use a form because in a
form you can manipulate the caption in a form. But a problem that I see
from this newsgroup is that a lot of people who use Access but are not
looking to become professional programmers are lulled into thinking that
Access can do anything. And this crowd is not aware of the concept of
database normalization - which means no redundant columns - a confusing
and complex topic - which requires programming.

Well, for a desktop database system, Access is a very powerful system
and can do a lot of things that most desktop applications cannot do.
The caveat is that you have to write programming code (VBA) to make
Access do these things. So instead of adding a new column to your query
keep the query you have and programmatically pull the data that you need
by using parameters. If you need to pull data for 2006 for now, you
pass in a parameter for the year 2006. Then when you need to get data
for 2007, you can use the same parameter to retrieve data for 2007.

If you are not familiar with using parameters in queries
programatically, you can ask about it in this newsgroup.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Jul 19 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Klint Gore | last post by:
I've hit a situation where I'm getting an unexpected set of results from a cross join that I've narrowed down to a table alias. If I do (a has 4 rows, b has 1 row) select a.field1, b.* from a...
4
by: David Peach | last post by:
Hello, hope somebody here can help me... I have a query that lists defects recorded in a user defined date range. That query is then used as the source for a Cross Tab query that cross-tabs count...
0
by: jgabbai | last post by:
Hi, I am looking to pick up the relationship between items in a cross-reference table. For example, searching for c OR f (bracketed below to highlight them), I want to list the other right hand...
1
by: Rob Woodworth | last post by:
Hi, I'm having serious problems getting my report to work. I need to generate a timesheet report which will contain info for one employee between certain dates (one week's worth of dates). I...
1
by: Gabriella | last post by:
Hi, I am having lots of cross-resolution (and also cross-browser) problems. I would like to know what is the most recommended solution for this type of issue: * Should I use different CSS for...
10
by: aaronrm | last post by:
I have a real simple cross-tab query that I am trying to sum on as the action but I am getting the "data type mismatch criteria expression" error. About three queries up the food chain from this...
5
by: Cyrax1033 | last post by:
I have yet a new issue that is the only factor stopping me from adding on the last feature to the database; all help is very much appreciated! In my database is are two tables: one for inserting...
1
misscrf
by: misscrf | last post by:
I have a table that acts as a cross reference to related records. No we can't get different data, no we have no control over what we have, we just need to be able to manage what we have been given....
4
by: nospam | last post by:
I have a table that acts as a cross reference to related records. No we can't get different data, no we have no control over what we have, we just need to be able to manage what we have been...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.