Is there any way in Access that I can combine two columns into one

Hi - I am working with Access 2003 and I want to update one field in one
table to yes - how do I do this?
For example, I have a table listing all of people who hold a brokers license
or insurance license and sometimes both. At one time I would like to update

Here is where I am...
Current
Tbl. PO_ITEM_NBR  Result  PO_ITEM  PO_NBR
123344 001                       123344     001

I'm trying to figure out how to get this to work and am having a lot of
problems.  I have a form that users enter a start date and time and an enter
a end date and time.  From those four form values, I'm trying to run a query
against a table where this table has a date column, a ...

running access 2k;
don't know why Xtab queries seem to be SO hard to understand....
BUT...
I have a REALLY simple table:

This case is not working:
Public Sub AssignOwnerDF()
   Dim Db As DAO.Database
   Dim rs As DAO.Recordset

Good Afternoon:
I am attempting to use the Count feature in the Totals row of my
query.  When I do this I only receive "1" for all my records.  Any
reason why this would happen?

Does anyone have any idea why this code only processes 95,039 of my 99,790
records?
Public Sub AssignOwnerDF()
   Dim Db As DAO.Database

I am not able to get the code for this function. Do you have it.
I found a link that is supposed to contain it, however this site keeps
failing.
http://www.pacificdb.com.au/MVP/Code/Diff2Dates.htm

I have a crosstab query with uneven fields across the top.  I need the last
value of each crosstab row.  Is that possible.  The rows have uneven columns,
meaning some have data, but some data goes farther to the right.  I need the
last data on each row

I've got a list of invoices for businesses, some which have multiple invoices
on a given day.  I want to be able to return ONLY the First Day a customer
was invoiced AND the TOTAL for just that day.  Here's what the data looks
like:

i am currently trying to design a query at work.
i need to have critera in 3 boxes to search by, is this possible?
Please let me know if you can help.
Thanks

I have a single table that contains the following two fields : [trap id] and
collection date. Each trap should be collected once per week and I want to
query the last date a trap was collected (in order to identify any missing
trap collections). I would have thought that this ...

Hi, I am trying to create a query which will prompt for a number to be
entered as criteria and then find the closest number going downwards eg if I
entered 0000962 as criteria it would find 0000951.
I am using Windows XP and Access 2000.

I tried searching the forum for help before I posted but I came up with
nothing.  I need some help with a query.  I have a query that shows
custermers in a certain region with account due within 90 days.  In the
criteria of my query I exclude current balance that are less or ...