Display The Max Value
Jun 13, 2006How do I display only the largest or smallest value in the query result?
Thanks
ADVERTISEMENT
Display 2 As 02 - Where Does My Zero Go??
Mar 1, 2005I have a form that displays minutes. When the minutes are 9 or less it displays as, e.g. 9 instead of 09.
How do I get that leading zero to display?
I read in previous posts that one way was to format as text or date, but I don't want to do that bc the minutes are added up on form save/close. :confused:
Display If
Oct 5, 2005HELP
I have a point system. What I want it to do is, when the points field reaches 55 I need for the Congrats field to display “Congratulations you are now eligible to advance to the next peer group”
Display Yes/No
Aug 11, 2006I have a Yes/No field in my table - I would like to display the words in a report instead of the checkmark. How would I display this in a query or report?
View 1 Replies View RelatedCombobox Display
Jun 15, 2005Hi I really have a problem in MS access.
I created a combo box which as 2 columns, eg Plant ID and Plant name
I need to have the Plant ID on the left and Plant Name on the right which it is at them moment, however....
When I choose an option inthe combo box, it will display the Plant ID number in the textbox because it is on left (its the 1st column in the drop down box)
.... I want it to show the plant name instead, but still have the plant id colun on the left and plant name onthe right when i click the arrow of the drop down box,
sry if its confusing, i need an anwser ASAP, thanks!
Display Size
Jan 24, 2006Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.
Ta
Display Data
Nov 13, 2006Hi,
I am using a query to print information about customers and products on a report; the query is returning something like this:
Customer---------------------Products
cust1-------------------------------apple
cust1-------------------------------cereal
cust1-------------------------------salad
cust2-------------------------------photos
cust2-------------------------------bananas
However, my client is wanting all the info about each customer displayed in list like this:
Customer----------------------Products
cust1--------------------------------apple------------------cereal-------------------salad
cust2--------------------------------photos-----------------bananas
I can change my tables to reflect product1...productn, but that will break database rules.
Any suggestions please?
Regards,
B
User Display
May 22, 2007Hello All,
I have set up security my users. What I am wanting to do is when the record has been modified or changed it displays the user that is signed in as making the change. I have Time and Date set up this way. How can I have the user displayed as well.
Thanks,:D
Display Dates
Jun 1, 2005I would like to eventually creat a chart report with information I have in a query. My problem is that I cannt get the correct information in my query. I want a user to input three begin and end dates and I want the appropriate information displayed in my query.
View 5 Replies View RelatedDisplay Field Name
Feb 21, 2006Hi,
I have a field in my query that displays the occupation of an employee. I have another field with an "if" expression, which displays the occupation if certain criteria is met. However, it displays the occupation ID and not the name.
The occupation ID is an autonumber, but I just want to see the name.
Is there an easy way to do this
Query Display
Apr 6, 2006Hi I was just wondering whether there was a way to display results of a query in a listbox form or similar.
Thanks
Display All When NULL
Aug 3, 2006I have a query which based on some fields on a form should display a set of records. In case when the user doesn't specify anything in the combobox on the form (value=NULL) I want the query to display all the records (like "*"). For some reason when i put the following in the criteria of the query it returns 0 records instead of displaying all:
IIf(IsNull([Forms]![frmClassReport].[ClassName]),(([tblClassesOffered].[Course]) Like "*"),[Forms]![frmClassReport].[ClassName])
I tried: IIf(IsNull([Forms]![frmClassReport].[ClassName]),"class_name",[Forms]![frmClassReport].[ClassName])
... and that works properly. I tried several scenarios and pretty much narrowed the problem down to the use of "LIKE" which when used as specified in the first SQL statement doesn't return any records. What am I doing wrong?
Display All With DOB Within A Week
Oct 2, 2006Hi, I am doing a project at school and need to run a query that displays everyone that has a date of birth within 7 days using a date in the format 01/01/2001. I really have no idea how to do this and would really appreciate any help.
Thank you very much
Kris
Display Top 50 Records
Dec 10, 2006Dear friends
How could I get top 50 records from a table?
have a nice day
JB
Display Parameter Value
Dec 11, 2006Afternoon All,
Right then.....i have a query which I use to search the database, users click a command button to open up the query and then are prompted to enter the parameter value. The results are then displayed in a form - what I want to do is to display the search term used at the top of the form.
I'm not sure that this is possible and if not, would my best bet be to use a text box on the form and refer to that in the search query?
rgds,
Display As Date
Sep 13, 2007I have just taken over an access database written by someone else. I am being asked to write some customized reports that will be extracted to excel and passed around to the team.
The database is used to track employee assignments and show us who is available and what percentage they are assigned to a task. The current report shows their percentage of assignments by month. The current column headers in the table are Month1, Month2, Month3, etc.
In the report I am creating, I would like to write it so that it pulls data based on criteria I give, but I want the columns to show Month1 as the current month, and Month2 as next month, etc. So instead of Month1, Month2, Month3... I will have September, October, November.
I cant seem to figure out how to calculate the "display as" part. When I put the formula Format(Now(),"mmmm"), the formula appears as the column name, not the expected value.
Your help is most certainly appreciated.
Display Data
Dec 28, 2007I have a table with 2 columns :
ID Code
70010000220002A
70010000220002B
70010000220002C
70010000220019A
70010000220019B
70010000220045AAA
70010000220045BBB
70010000220045CC
70010000220045D
70010000220045E
I need to present this info in this format. Can you help?
ID Code1 Code2 Code3 Code4 Code5
70010000220002ABC
70010000220019AB
70010000220045AAABBBCCDE
Thank you!
Non-display In Sub Form
Jan 24, 2005Hi All
My sub form appears to work fine most of the time.
But the records in the sub form (which is a datasheet) don't display when I apply a "filter by form" on the main form ?
Any clues as to what is wrong ?
I am a beginner - it could be something quite fundamental !
NoVoiceLeft
About Image Display
Feb 3, 2005I am going to show some images
I have stored the links of photo in a table
how can I show the different pictures in a form at the same time?
Search And Display
Feb 11, 2005I am using Microsoft Access 2000, I dont have very much knowledge with the program. I need to Seach By a Combo box, Contact name... Through the database and then Display only the information for that customer in the list box. I have been researching this for weeks now and I need Help. :confused: :confused: :confused: If anyone could help it would be great. Thanks. :)
View 5 Replies View RelatedTemporary Display
Mar 27, 2005Hello eveyone.. I have a slight problem which goes way over my knowledge of the subject!
I have to make a form saying "ISLAND HORSE RACING CLUB" appear for 5 seconds before loading up the main form to add records but I cannot for the life of me figure out how to do it!!
anyone got any pointers? had a look at "timed events" on this forum but dont know how to implement it to help me
Any help would be appreciated
Regards
AaRrGgHh
Form Display
Mar 31, 2005i have a form and it always displays the first record as it opens.
i dont want it to display any records and be just blank.
i have tried the code on Form_load
for i = 1 to col.count
col.item(i)=""
next
i dont know whats wrong with this code.
please help
Display All Queries
Apr 9, 2005Sorry for apearing thick.
Ive only just started using access.
How do I list all queries in my database in a list box??
Many thanks for any help.
Richard
Display Lookup Value
May 11, 2005I found an earlier thread by Wazz that told how do display a lookup value
=DLookup("[surname]", "tblB", "[staffID] =" & Forms![frmA]!staffID)
but it did account for blanks or nulls or if a field (numeric) is zero/no value.. can you add to this? anyone?
Display What Day The Date Is ?
Jul 25, 2005This used to be an easy one. . . but has anyone noticed that long date format no longer shows the day on the end? I have looked through the regional windows settings too and i cant find it anymore. What i would like is to group some results by date on a form with it displaying the day as like a diary style listing. Any help would be greatly appreciated....
View 5 Replies View RelatedDisplay On Form
Aug 10, 2005Hi all
Quite busy these days but never too busy to visit this website.
I have a question.
I am busy create a "Logsheet" database. Where you enter all your trips done with your vehicle.
Trip;Date;Trip_From; Trip_To;Start_Km; End_KM;
I do have a textbox where get the Trip_distance.(End_Km-Start_Km)
Is it possible too display on the current form the previous page End_KM.
Previous Trip End_Km-123456 (Display from previous page)
Trip Start_Km-123456 End_KM-123466 Distance-10
Next Page End_Km-123466 (Display from previous page)
Trip Start_Km-123466 End_KM-123486 Distance-20
I tried to do this but it came out only in a mess..