Hi - I am not very proficient in Access so please bear with me.
I have a table where very often I will have many identical records in a row
(maybe 24 or 36).
All fields in a given set of records are identical (except for the primary

I have a table with a field that has data that looks like the following:
N0345, H4354, 48574, 48577
How can I create a query that would separate that data into their own fields?
Field one would have N0345 the next would have H4354 etc...

I would like my parameter query to provide all records if left blank or if
the end user only knows the first 3 letters of a name then it should records
with that criteria. Can this be done?

I've come across a query someone created and it has criteria pulling dates.
Could someone explain to me this criteria:  Like Get_Find
Field :  oDate: Format([OccurrendDate],"yyyy-mm-dd"
Criteria:  Like Get_FindOccurrenceDate()

I am creating an append query so I can track all historical data because
once the orders in WIP (orderWIP table) are completed, they will be removed
from the table. My question is what type of validation/ criteria can I put in
the append query so it is not appending multiple ...

I am using Access 2007. In a previous version I created a simple query that
enabled a search on Company Name; Like "*" &[Enter Company Name] & "*", which
was written under criteria for Compnay Name in a query window. I then created
a button on a Form that ran this query via a ...

please note that in order to get the date 6/28/1979 I am using average work
days each month of 21.75
I have tried to Add just the total days to the date but it's not correct
because I need it to be based off the 21.75 days per month not actually days.

I have reports set-up which run from queries- the user is asked to enter the
month which in turn pulls all training records for the month entered.  Is it
possible to have the months appear as a drop down in the dialog bos, rather
than the user having to type these in?

I have created a database using several tables which I incorporated into one
main form that uses subforms to populate all the tables.  My question is how
do I create a query that will query the subform (by supplying input from the
user...I know how to do this part) and return the ...

I have a database for rentals, with an arrival date field and a departure
date field. It is easy to count the days between one and the other.
The question is, if an arrival date is Feb 23 and Departure March 15, from
the 20 days difference, I just want to count the days stayed this ...

Hello;
I'm designing a database to track radio's.. The problem is I want to show
last names from a related table. But when I generate the report or the query
I get all the lastnames that I have stored in my table..

I would like my query to pull out the first 200 records. Would you show me
the criteria or how to make it works?
Thanks
Chi

I am currently using the expression: Between
DateSerial([Forms]![frmClaimDetail]![cboBeginYear],[Forms]![frmClaimDetail]![cboBeginmonth],1)
And
DateSerial([Forms]![frmClaimDetail]![cboEndYear],[Forms]![frmClaimDetail]![cboEndmonth]+1,0)

Help - I am a long time lurker and first time poster.
Here is my issue.  I am attempting to match entries of money being written
off an account to the businesses GL File.  However, when these write offs are
done what is typically a link is broken.  However, by adding the dollar

was wondering if someone could help me with a little problem. I have a
form with a bunch of List boxes that I want to populate through an sql
query through VBA.
My problem is the following: the sql query is as simple as it gets: