I have a small table of data: Start End Appointment...

I am using Mr. Hookums formula he gave me for concatenation in Access 2003 and it works fine. As soon as I copy it into 2007 I get error messages. I have...

The default number of columns on my Access database is 24. Can this be expanded to 40? Thanks

I get an error when I try to create a combo box from the wizard. I am trying to use a database template of the Address book and wanted to look up a person by...

Hello, This is the fourth time i have put this on here, please can someone help me, i am desperate now, this is for my project. everybody i know can not do...

I have three fields in a table, and want to determine the total of the occurrences by a certain time period. The data I have looks like...

Hello, I'm hoping this should be easy - I just can't seem to find the answer. I'm guessing my syntax is wrong but I can not figure it out. I am making a Db for...

I’m floundering about and need someone to point me in the right direction. I have two...

How can I filter for results that contain the charcter "(" ? For example if my fields a A(2001) B(2004) C D(2055) E(2006)

I have Query1 that returns 2 fields: CatID Step1Decision CatID can be 01 thru 29 Step1Decision can be N,X,P,D,R Query1: SELECT qryGrievances.CatID,...

Greetings, I'm going to confess right up front that I'm an Access noob, so there is a great possibility that what I'm asking is basic and that I just don't...

Hello, I have a Module that pulls the username of the person logged into the PC (if you would like to see this code, let me know). I have a table called...

morning all hopefully someone out there can offer some assistance i am building an access application in which i wish to be able to intially look at all the...

I have a table to enter contact information where each contact is assigned a random id no. That said it is possible to also associate a Family id no so you...

I've been having a problem with grouping in my queries and I finally figured out how to do what John Spencer suggested ... SELECT , Sum(IIF(30,CyTotal,0)) as...

I have on my customer master, a field for credit limit. The user can input the credit limit for that particular customer. When the user then goes in to the...

I am a beginer of Access. I have a database that consists of 4 columns/fields of dates. These dates/fields can be filled or can be blank. I call them A,...

I sure hope someone can help me. I've been struggling all day now. There's some data that occassionaly needs to be copied from one record to another and the...

I'm showing Expr 1001 as a field in the field list for one of my forms and I have no idea why. Here is the sql: SELECT ReminderID, ReminderType, Reminder,...

Hello, Within my qry I would like to calculate the average daily production for the month. The data Im working with is: production volume, dates (which is a...