MS Query returning non-existing record

P

PA

Hi all,
In the same excel file, i have one sheet containing data and one running a
MSQuery to retrive some of the data with a parameter. The problem is that
when only one record should be returned, I have that record and a blank
record. Because I have formulas that are auto-extended, I have two lines of
formula. In MsQuery UI, there's only one record.

I hope this is clear,
Thanks

Pierre-André
 
S

Shane Devenshire

When you say you have auto-extend formulas exactly what do you mean.? what
version of Excel are you using?, how did you make you MS Query connection -
ODBC or regular Excel connection?
 
P

PA

Hi,
By auto-Extend, I mean the option to extend formulas to match the number of
record.

I've created the query in Excel 2003 with the "new query" and MsQuery, so
i'd say a regular excel connection.

I tried the file in excel 2007 and I have the same problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MsQuery returning one record + one empty record 0
DMax on existing record to increment serialized # fails 1
How do I add a new blank record (row) 3
MSQuery not returning new data... 0
2010 Mail Merge either skipping first record or skipping multiple records 1
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Parameter queries in Excel 2007 0
MSQuery - Criteria to remove multiple records based on a single re 0

Top