Queries

My Access query shows blank in the label merge
When I try to merge the Access query I want into label format, the query shows blank. I can merge the database table with no problem but not my query. What am I doing wrong? ... 8 Mar 2010 18:43

new messenger
Friends and friends around the world. We are presenting the new messenger. He will be in the commissioning by the friends that we indicate to use the system. Access the system by clicking the link below and register free. You get something for using orkut? You get something for using skype? You gain something... 8 Mar 2010 16:26

DateAdd compile error
Using this formula to subtract 5 hours from a date/time value in tblTIMEZONE. DateAdd("m",-5,[tblTIMEZONE]![DST_Begin]) I'm getting a compile error. The DST_Begin value is stored as a date/time value. What am I doing wrong? ... 8 Mar 2010 13:04

military time
The database field is a date-time field. I want to report it in military time but change the format to 0000 not 00:00 ... 8 Mar 2010 11:57

runtime access
I'm doing a freelance job for a company that wants it's dozen employees to have access on their laptops. They're asking me if the runtime version would work, because it's free. What is the difference between purchasing the license and runtime access? See below... --------------------------------------------... 8 Mar 2010 09:42

How to get a query to call the parameter form
I am trying to use a form to get query parameter dates as is detailed in the help article "Make a query ask for input" The query does not open the date range form when the query is used If the form is opened in advance and dates entered then the dates in the form are used what is missing? How is the open form... 9 Mar 2010 13:31

pivot table calculations
I have not done much in pivot tables. But I have designed a pivot table form that does all I need except for the last step - creating a column to show a net amount. That is, I need to subtract……. For beginning leases, I have sums for three types – new, renewal or extension – and a total for all beginning leas... 7 Mar 2010 12:58

mdb file
Over the years I have assembled in ACCENT a database called "Music Archive", to which the latest addition was made in January 2009. Now, when I wish to open the Database, I obtain the following message : "Unrecognised database format Music Library.mdb." When looking at the Help solutions, it says "Error 3343" and ... 7 Mar 2010 10:43

Calculating the days in a month
I have a Control which is a Date field named 'NEWTOPD'. Based on the date entered in the field it calculates the days offor the whole month making amends for Leap-year as well. If I want only the number of days in that month starting from the date entered in 'NEWTOPD' - to be entered in a calculated text fie... 7 Mar 2010 08:31

how to run onhand value report
I get the message enter parameter when entering the zoom feature ... 6 Mar 2010 21:46