I am trying to make a combo box that looks up information from an
existing table, using filters such that only those records show that
match the filter.  This is the query I am currently using:
Row Source = SELECT DISTINCTROW tblMembers.*

How do I query currency fields in Access for those with cents in them?

This is an access97 environment if it matters.   I am looking for all rows
that are older then 30 in the [Date Checked In] column.
This is from my where clause:
and datediff( "d" , [Date Checked In] , dateadd( "y", -30, date() )) > 30

I have a query that lists just a job# and a date pulling from a table in
which I put every day that an employee works on that job (Labor Expense
table). Some days there are more than one employee working on the same job,
and some days no one is working on that job.

Hi
I currnelty have the following query
SELECT Employee1.INumber, Employee1.Name, Employee1.WC,
Count(WorkShopEmployee.WorkShopID) AS CountOfWorkShopID, Employee1.WC

Hello, I have a user trying to link to a table (DB2 in this case) which
contains 312 columns. Only the first 255 columns are returned. Is there any
MS Access work-around for this and is this limit of 255 columns/fields
carried through in more current versions of MS Access? I ...

I have an SQL query that I am combining text from multiple fields and then I
am trying to trim the last character but I must be doing something wrong.  
Here is the SQL Query:
SELECT HM.Service_City, IIf([Site_Name]<>"",[Site_Name] & " • ","") &

I am trying to select the first 20 days of a population of data and then
after that only choose one day out of the week and continue this philosphy
once a new population of dates pop up.  Is there a specific query or
conditional statements I can used to create this?

I'm trying to choose the first 30 days when a new entry comes into the table
by using this formula:

and with in the same query, i want to choose weekly dates after i have 30

A couple days ago I needed to sum currency values and count the number of
contributions to the values.  I created an intermediate pair of crosstabs and
created a report with them.  
I am finding now that I can just keep addending Row Headings to a primary

Thanks for taking the time to read my question.
I have 2 sets of data.  I would like to see all the records from both sets,
but line up the records that do match, and include the records from both sets
that do match, without seeing each record for each record.

Is there a function or expression that changes a Julian date (e.g 106094) to
a Gregorian Daten (4/4/2006).  I haven't had any luck locating one.  Thanks.

is there a way to run a query or something that shows me  all the tables in
my database and the fields associated with the tables for example
tables
table1

its been a while since i have posted. I hope y'all doin fine.
I have a query which can be constrained two different ways. it can be
constrained by the join, or it can be constrained by criteria. i was
wondering which one hapens first and which one is prefered.

I have a vehicle database. I made an odometer entr table that has unit, date,
odometer and an autonumber field. When I set up a query to group by the unit
number and give me the last  odometer and date, it returns the correct info
for most units but some of the units it "skips" ...