473,378 Members | 1,393 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,378 software developers and data experts.

how to let user choose their field from query so that it can be displayed on the repo

132 100+
This should be done in reports or forms as parameter
Aug 23 '10 #1
3 2222
gits
5,390 Expert Mod 4TB
what report, what query, what technology at all do you use? the question is far to vague to get any answer without more information - so please rephrase the question and add some more information so that the use case is clearly understandable.
Aug 23 '10 #2
Mr Key
132 100+
Thanks mr gits, The question is I have a query in Ms Access Database of about 30 columns (Fields), say Field1, Field2,Field3,Field4,Field5,...Field30. I want a user to define which field is interested to view in a report by just enter the Field name as a parameter in a form, let say the first user want to see Field1, Field2,Field3 and Field4 the other user is interested in Field1,Field2,Field3 and Field7 etc, Where the Field1, Field2 and Field3 will be constant for all reports while Field4...Field30 will be available on user request
Aug 23 '10 #3
gits
5,390 Expert Mod 4TB
moved to access-forum ...

regards,
MOD
Aug 24 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Javier | last post by:
I have a field type Date/Time that automatically defaults to Now(). I'm having a problem writing a query that will retrieve all the records for a specific date the user to enters when prompted. I...
2
by: Marius Kaizerman | last post by:
Hi, I have a report that is a based on a query. One of the fields in the query is "time of sale", which is a date field that holds the sales dates (day,month,year). I want to use that field as...
0
by: Jim Connell | last post by:
I've created a user defined field in outlook 2003. I am able to use access to link in my contact folder, but I don't see my user-defined field. Anybody know how to get to my new field? Thanks,...
4
by: bob hicky | last post by:
I have two tables (RadiationOncologists and EvaluationEntry) and forms for each of the two. My problem is that I have a text box in the RadiationOncologists form that is called Number. This field...
1
by: WillieW | last post by:
Hi folks, I have Access 97 and have set up four tables, each with a Primary Key with a file name manually entered. For example, the four tables relate to information stored in a paper file, on...
1
by: Shawn | last post by:
I have to develop my application to support 2 languages. Maybe even more in the future. Everything from the DataGrid header text to the text displayed on my buttons have to be able to change...
4
by: devinsnyman | last post by:
How do you set up a query and report so the user can choose the field/s and the value of the field/s. Thanks
5
by: cptuser | last post by:
Hi, I'm very new to javascript and have very little background knowledge. For some reason I can't get the script to work. It uses IF statements but for some starnge reason, it skips and ignore the...
2
by: NicotineJones | last post by:
Hi, I have database with monthly sales data tables within it. These sales data tables are organised as follows. Item code; Description; Country1; Country2; Country3..etc 1234; Item1; Sales...
45
by: dizzydangler | last post by:
Hi, I'm new to access (2007, running on XP), but I've gotten some great help from this site on my project so far. However, the more I know, the more complex the problems seem to become.... I'm...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...

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.