I do not have a computer running Access at the moment. An idea occurred to
me.
a common task is to convert table data such as:
Key col1 col2 col3 ...... colN

I have a parent table and a child table
one parent has between 1 and 6 children in the child table I wont a
query to have the parent and the child in one "row"
how do I create that?

I have a query where i am trying combine multiple records of a particular
field into a single record.
eg. instead of;
Record 1

I have a table Schedule which has jobs for each staff member. they can have
up to 3 jobs per day. I have a crosstab query that displays the jobs for each
day. in the crosstab there is a IF statement for the count. if there is 1
job, it displays the first job. if there are 2 jobs, ...

I have 3 field in a table and I wish to show all of the records in field only
by using query. Can somebody tell me how to do this ?

I have yes/no fields which are ticked depending on the relevant industry
sector they are associated with.
In a single record for example Health and Education check boxes could be
ticked and i would like a single field to display the combination of the

From Table view, when I filter by form the drop down boxes in each field
returns Null, is not Null rather than my data options. Actually I have no
Null data in my table.
Is there a setting in desighn view or some where else that I need to change

Hi, I need a help with my query. I have a form with 6 combo boxes, and a
query in subform.
Subform query is updated based on the combobox selection, user has to click a
button ( for requery) to get the results after selection. Issue is now its

I've got a query that uses form parameters to display a list of records.
Worked great until the client requested that we reference data on the many
side of a one-to-many join.
Now the query shows multiple records for each record on the many side of the

Is there a function in Access that I can use in my queries to map values to
other values. (Oracle's decode) In other words, if I have a table with
payment frequency that contains 12 (monthly), 4(quarterly), I would like to
translate those values to some factor, like 12 ...

I have a string field with 'numeric' values (abbas) and another string
field (abbas_sign) that contains the indicator for the value's sign.  It
contains
a 'D' if the first field is a positive number or a 'C' if it is negative.

I have created a column in my query  that extracts a number from another
field that is a string.  I need to convert my new field to be a number so I
can sort properly.  Any suggestions??

I have created some vba code that inserts new records into my db. However,
even though a record exists in all tables for the new id and all other
criteria are met for being selected by the query, the new records are not
selected.

I am just getting started with Access and have a simple question. I have a
basic  table with part information in it. I would like to have a small window
open up where I can pick one of several fields in which I can specify a look
up value then hit a key and have that particular ...

Trying to lookup a value in a table which is dependent on 4 fields in a
second table.  Suggestions on how to accomplish?