I have a basic Select Query with a parameter of [Enter Policy Group].  Is
there a way to make that parameter a wildcard search?  Thanks.

Greetings all,
   Is there a way to get a query to look at Days and Months of a Date.
I have a field called Birthdate and another field called startdate
I am trying to make an update query like such:

I am trying to remove leading and trailing zeros (0) from a text string.  As
example, I would like the text 0000012345 to be reduced to just 12345.  I
have tried the trim, LTrim and RTrim function, but this appears that they
only remove blank spaces.

I have a database set up with yes/no data.  The data is displayed as
checked/unchecked boxes.  I want to run queries that will return only those
records that have checked boxes.  What do I insert into the Criteria field to
return those records?  I tried ="Yes" and =1, but both ...

I created a date field with no format. The users have now keyed in long and
short date values. When I query for #11/30/2004# I don’t get the long date
values of 11/30/2004. How can I get those values as well as the short date
values?

I need to round up/down demical,  eg  .57 would be .55  .28 would be .30 any
ideas?

I have a table (MarketHistoryShort) containing a large amount of historical
price and volume information for a number of different stocks with the
following fields:
ID    Ticker    Company Name TradeDate    High    Low    Close    Volume   

I've done a 90 Day aging report. What I need now is everything that has
shipped and is under the 90 Day window. I have a confirmed/not confirmed
collumn. Basically how do you say "If the date equals less than the ship date
plus 3 months then show."

i get an error saying how there isn't enough temporary disk space when i try
to run a make-table query exported to another database.  the funny thing is,
i've run the database before with older data and it worked just fine.  all i
did was import updated data (with the same number ...

Hi to all,
I have a problem understanding something
I need to build a query based on 3 table, this should be simple but I am
unable to update the recordset on my  form based on this query:

I have this battle running with other developers.  Is it better to design and
store queries and then call them by program code? Or Is it Better to create
an SQL statement by Code then executing.  My feeling is a stored named query
is more efficient, since Access optimizes the ...

Hope somebody can help me!!
I am trying to create a query that displays all submissions o
applications for the past month and am finding entering the righ
criteria very difficult indeed!!

Is there a way to run a query hidden?  Like when the DB Opens, and I have a
Form Open as the starting form.  Is there a way to put something in the On
Open event of the form to have it run an update query invisible?  I am
checking for a certain date, and if a record meets the ...

I have split a table's values listing work materials into several smaller
tables because the number of choices are too numerous to fit into one value
list.  I'd like to make a new table that will include the values from ALL the
smaller tables and be choosable from a combo box on ...

All of the objecft on my screen are diminished.  I cannot access the font icon.
Even my screensaver is half it's normal size.  Can you help?