I currently have a query that concatenates the last first and middle names of a client into one column. My expression is here below: =[Client_Lname] & ", "...
You'll need to do an "iif" statement... FullName: =iif([Client_Mname] is null, [Client_Lname]&", "& [Client_Fname], [Client_Lname]&", "&[Client_Mname]&" "& ...
Never heard back from anyone on this one? Any ideas out there? This works for hourly reports...just want to break it down further. ... From: Dave Moreau ...
Dave, Maybe you could do a group-by/order-by (hour/4) Dick ... This works for hourly reports...just want to break it down further. ... 15 minutes? ... any...
I am searching my ldb file (for an opened database). Does anyone know where is the default place for it ? Usually it seemed to put in the same folder as the...
When i opened my database, no LDB file is created (neither in the same folder nor in another place on the harddisk). How can this happen ? (it is opened in...
Hi there, i have a situation where two different users must open the same MS Access file over a network at the same time without locking the file How can I...
Is it possible to convert a spreadsheet file created in Excel to an Access file does anybody know? Or do I have to start again from scratch :( Thanks Pat...
Dear all, I am trying to have a combo box for auto complete. I have entered following codes combo4_change. But I am not getting the resulst. Can any one help...
You can also use the Excel spreadsheet as virtual Access file. It keeps beeing an Excel file (you can do whatever function you want with Excel on this file),...
Hello If anybody wants to sell his/her book of Organisational Management & Information System P4, then please contact. You are requested to quote the price as...
I was wondering ...... Was my answer that stupid that it even doesn't merit a short reply ? ... -- Eddie [Non-text portions of this message have been removed]...
Thanks very much for this info :) Am going to give it a try this evening. Pat ... beeing an Excel file (you can do whatever function you want with Excel on ...
Hi there, I have create a query for lab analysis result. The 1st column name is the Value Chloramphenicol. This column were use to key in the result get from...
Not at all......I missed your answer as it went to my spam filter...just found it this evening ....thank you! Apologies for missing it....I'll give it a try...
I made the following query: SELECT CONSIGNMENT_CODES.CONSIGNMENT_CODE, sum (INVC_DETAIL.QTY_SHIP*INVC_DETAIL.UNIT_PRICE) FROM INVC_DETAIL, CONSIGNMENT_CODES ...
Mo I don't know if this question was answered. As you can see CONSIGNMENT_CODES.CONSIGNMENT_CODE does not have aggregate function like Sum, Count, First, etc....
Pivot tables are called Crosstab queries in Access. Check under Queries Calculations like Sum, Average, etc are done in queries, forms or reports. It all...
Hi Everyone, Does anybody know were I can get an autodialer that will intergrate with Access? I need to make it a seemless action that can dial from a ...
Will give that a shot as well....seems I can't get it resolved yet but I'll bet it is not suggestions such as yours as much as it is my new coding, or lack...
Hello, Does Access-2000 works fine with Vista (the home version of Vista) ? Thank you Gilbert Clauss [Non-text portions of this message have been removed]...
I have to leave town until April 1st so I am setting the list to unmoderated mode because I won't be able to monitor it. During this time there may be some...
I need to fill all of the records in a field with the same value. I would like to select the value from a list and have it update. I believe I need a combo box...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
