I am looking to write an expression, but I'm not quite sure how to do this. What I need is: return all records with a "Trnas Date" received within 30, 60,...

I need some help on figuring out how to merge to fields into one in a query. I have a table with an employee number, last name, first name, etc and i'd like...

I would like to do in Access what I know how to do in Excel. My table has a field formatted as Date/Time. In a query I would like to create a new column...

I have a subform linked to an underlying query. Everytime I move the Main form record, it changes the subforms records too. The subform is not Parent/Child...

Is it possible to remove zeros, in the beggining of the letter if it contain example: 00CA258 000VDB 0000CA963 0US456

I have used the following expression to merge two columns, Ineed to hide the time and keep only the date in the expirydate. Expr1: () & '---' & Also I have...

Hi All I'm unsure which approach I should use when designing a FE/BE. In the Access BE I have 2 tables which are related by primary and foreign key with...

The database that I thought would take me 2 weeks has taken me much longer. I have two files that I import from .csv pipe delimeted into Access 2003. Table 1...

Hello I am looking for some help to make query which can append 60 rows in a table with same data. I have a table called tblName, which contains unique names....

I have numbers that are exported from an online system in text format. I need to use the numbers as integers in my Access work. I can find a way to change...

Hola Amigos: Hace unos días recibí un mail donde me invitan a hacerle un regalo de amor de $1 dólar a seis personas y después ponerme en la lista para que...

I have a MS Access 2000 Query. I need to refer to this very regular. I would like to display this query as part of my desktop wall paper. Is this possible...

I have a calendar set up so that users can input individual dates that they are taking off for vacation, sick, etc. My question is, is there a way for a...

All - I have a query that looks at the text values of two different combo boxes (ManagerByStart, ManagedByEnd), which are Text. When the user clicks a...

Hello, I am having some problems with my search panel in Access 03 on XP Pro. I have five fields to allow the user to search for any number (up to )...

I'm trying to find the later of the three date fields below using a nested IIf statement: DOR + 3 months PROC + 1 day (this field may be null in some...

I am working on a client appointment query with Client Id, name in one table, and Appointment date, status, notes, client id for indexing in the Appointment...

What is the sysntax to refer to a subform in the conditions statement of a query I tried the following !!.! but that doesn't work thanks

I used a Union query for many similar spreadsheets for different clients. However, it seems that the Union query has limitations of 50 Union queries. So, I...

i have a table which has po number, po line, invoice number, inv line columns. key field is the purch order + po line. i can't figure out how to set a...