I have a table that contains "Operating_Dates" as a field in data/time
format and each date has a numer value in an adjacent field
The data in the table look as so:
1/5/2007           55

Hopefully someone can help me with this. I'm trying to create an
Access database that will pull a list of people based on the first two
letters of their last name. Since this list will vary, depending on
the user of the database, I want to use dialogue boxes so that a

Good morning,
I have a database whose main table contains close to 600K records.  One of
the daily reports in the db now takes an hour to run, and we are all about to
pull our hair out in frustration.  The report is the culmination of 10 select

I need to sort some records by year, month, day that I imported into a table
from a text file. The date field is in the following format: yyyymmdd
Any help is appreciated
Tim

In my query I have a date field. Under criteria for this field I can enter
'Between #05/01/2007# and #05/31/2007#' and it returns all records between
those dates.
But, when I change the parameter criteria to 'Between [begin date] and [end

I have a table of locations with Items for fields, quantities of item
stored in the record.  So any location could have a number for some, all or
none of the items.
 I also have a table of items including the item number (a field in the

I have set up a query that accepts input from a text box. It appears some of
the data in the criteria field be start with a space and some do not. I tried
to concatenate a space " " & [Forms]![Form1].[Form]![Text1], but of course
that only works if there is a space. What is the ...

I have built a Database and spilitted into FE & BE. in the FE i got 2 forms
that are based on queries and used for searching. I made MDE file and used
startup option to remove admin options so noone can change the DB. Now when i
copy the MDE file on different PCs on network to ...

Hello to everyone
I have a query based on this SQL:
SELECT customerstats.all_customers AS ASB1, customerstats_1.all_customers AS
ASB2, 25000 AS GSB, Int((0.5*([ASB1]+IIf(IsNull([ASB2]),0,[ASB2])))) AS ASB,

I have a list of approx 14,000 names (with name and address fields). How can
I create a query to remove duplicate entries by checking the name and address
fields?
I am very new to access so please be gentle :)

I have a table named tserver of a list of servers (only one field). My query
consults another table named tAllServers that have lot of server and I need
to build a field that check if the server located in tAllServers is in
tServer as well. If ok, this field need to be populated ...

I have a pretty large table (251000 records) and 2 of the fields:
street number
street name
are 2 fields i need to combine into this same table so that it reads:

I am trying to create a chart and datatable showing values grouped by week,
however displaying only the week numbers isn't very easy to read. Is there a
way to show a representative date for the week? I.E. group all data from the
week of 5/21/07-5/25/07 and display it as 5/25/07 ...

That works beautifly - almost.  It will give me the 90 day average for today.
Very nice, thank you.
Is there a way to generate a 90 day average for each day in the database?
PS - when I started writing this "Frankenstein," it was just designed to

I get the following error when running a report: The specified field
'qryBudget.SumOfEstimate' could refer to more than one table in the
FROM clause of your SQL statement.
I have a nested query that pulls data together to make a Budget