I've got a number of nifty queries in Access which I'd like to be able
to view the results of in Excel.
I don't think I can recreate the queries in Excel using MS Query, as
far as I can tell (and please correct me if I'm wrong) you can't do

Access 2000.  I have a db with and "Account" table and an "Account Details"
table.  (For subdatasheet)  Linked by "AcccountID"  I have tried to import
excel files exported from another identical database but with no luck.  I
get the screen stating that Files were imported, but ...

have a text field with a lot of different data in it.
Here is an example:
SERV: PS NJ////SAR #155097//OH #08468////SAR #158097//OH #08469////SAR
#158098//OH #08470////SAR #158099//OH #08471////SAR #158100//OH #08472

I am sure that in the past I used the nz[function] to eliminate errors due
to dividing by zero. For example, when trying to find a percent value of
data in two tables, I subtract the first from the second then divide by the
first. Occassionally, the first number will be zero for ...

Good Day,
I am looking for a solution for where a user could interactively define up
to 50 criteria for returning a count of nonblank fields in a database of
approimately 3.4 million individual records. To put more specifically, there

I'm having loads of problems with our 15 MB database.  Stored on a Server
that all can access, plenty of room on the server.  How many users can be in
a database at one time?  My database is erroring and crashing all the time.  
I could use some help getting through this since I'm ...

I've been searching for awhile now on how to remove duplicates from a
table within an Access db and have found plenty of articles on finding
or deleting duplicates.  All I want to do is remove them from within an
SQL query - leaving one of the records behind of course.

I am trying to create an autolookup query for an input form.  What I am
trying to do is to type an SSN and have the quiery automatically populate the
name, address and other data from another table to prevent creating drop down
boxes.  I have tried everything I can find on the ...

I have acquired a GPS device but have been unable to download waypoits from
my PC to the GPS device. I keep receiving the message " serial port selected
is receiving data from an unknown device". I have been unable to identify
what else is using the serial port. I have tried ...

I'm designing a database that will be used in the office and I want the user
to have the ability to enter criteria from the parameter popup or a
form/table.  It appears every time I try, the information entered is returned
as "text" and the logical functions don't work.

I have been unsuccessfully trying to create the following code from Excel
into VB for an Access report.  Can someone please help?
Thank you,
Liz

Hi,  I hope someone can help me.  I have a simple query in which I''ve set
parameters to search for an individual id, beginning, and end date.  I then
created a crosstab query which pulls a one line listing of values for date
range and  individual.  This works great.  Here's the ...

Currently I use a Dlookup function to give me a field from a table.  How do I
get say, the second record of that field?  When I use the Dlookup in the or:
slot below the field, it still only queries based on the first record.
DLookUp("[NextCount]","[CYQueryTbl]","[NextCount]>0")  ...

I know this is posted previously but I am having an issue. Here is my query:
SELECT t_main.*, *
FROM t_main
WHERE (((t_main.last_name)=Forms![f_search]![tlastname])) OR

I am trying to create a report that will sort my performances and rehearsals
chronologically.
I have two tables; Rehearsals and Performances. Each table has it's own date
field.