Queries

Export crosstab query to Excel: Row hight and Decimal
In my crosstab query design, I put number in standard with 0 decimal in the number field. When I export to excel and open it: 1. All the numbers are still 2 decimal 2. Most row hight are 15 except a few rows which is higher How to fix the crosstab so the Excel would be perfect? Thanks. ... 24 Jun 2008 12:19

Input and return multiple values from a query
I have a query where I input claim number(s) and I want returned the claim number, last payment date and a check value of "OK" or "NO". Here is the SQL code: SELECT (SELECT MPT.ClaimNumber FROM MPT WHERE Instr("," & [Enter claim numbers separated by commas with no spaces] & ",", "," & [ClaimNumber] & ",")>0... 24 Jun 2008 11:17

Crosstab Query: Column Headings!
Hi, I had tried to do the following in order to get the column headings in a crosstab query to appear with different names -- other than the default: 1. Go into the DESIGN view of the crosstab query 2. Right click on the field name 3. Select Properties 4. In the COLUMN HEADINGS section, enter e... 24 Jun 2008 11:17

Can I use a drop-down list from a table as source 4 a paramete
Jeff, I appreciate your prompt response. To date I have only used forms for inputting data into tables, but I will experiment and see what I can come up with. Thanks for pointing me in the right direction. One more general question about Access 2003. I have taken the online training courses, and I am tak... 24 Jun 2008 10:15

How to make update a field of a table
I am trying to update the field [dummylink] which is in the table [tblGeneral Contract Information]with strInputtext (this variable is a string) When it runs it does not seem to do anything at all. CurrentDb.Execute "UPDATE [tblGeneral Contract Information] SET [dummylink] = '" & strInputtext & "'" & "WHERE [tb... 24 Jun 2008 11:17

Can I use a drop-down list from a table as source 4 a parameter qu
I am in the process of building a "Equipment Service Request" database. I want to create parameter queries that promptsusers for a value, say, manufacturer, but I want the user to select from a drop-down list whose values are stored in a table instead of typing in the desired value. Can this be done? ... 24 Jun 2008 10:15

whitespace at end of data
Hi Experts I have a table with the following user_names "Bill" "Fred" "Andrew" "Fred " As you can see, there are 2 Freds (one without a space at the end, and one with a space at the end). How do I select one and not the other? ... 24 Jun 2008 08:12

Date and Time Problems
Can anyone please help with the following: I have a database of transations that are time stamped. The time stamp is as follows: 24/05/2008 23:22:47 What do I need to put into my querey box to pick up transactons between two times on every day. If it was just the time or the date it would be easy. Howeve... 24 Jun 2008 11:17

Using wildcards in iif in expression builder
I'm stuck in creating a selection criteria for a query. Based on a value in a Form, I need to select all records which are "Yes", if this text in the form is "SMD" or, if this value is not "SMD", I want all records (both "Yes" and "No"). The first part of the iif statement is no problem and works fine, but how ... 24 Jun 2008 07:10

Update - fill blank fields based on match
I have a table that is imported where two columns contain the same data for a number of rows. Unfortunatley, the second column only has data in the first row and the remaining are blank. I want to run an update query to match the data from the first column and then look at the first rown in the second column... 24 Jun 2008 08:12