Hi all, I got table in my database with name "tbldata" and i have two fields in that table with the name "Ticket_No" and "Amount". In "Ticket_No" filed column...

Hi All A database I created for a client some years ago has a macro which contains an append query. This macro repeats itself until a condition is met and...

Hi all, Just created a database to keep track of case management for clients. I have all demographics, types of case management intervention, but I'm having...

There is an DB that was create well before my time at my job and I have very little experience with Access and need some help here. Access 2003, XP SP3. ...

I am needing some assistance in creating a solid table structure in creating a database that stores vehicle permenant waiver items (items that will not be...

I'm new to Access and really don't even know how to ask what I need to know, but I'll give it a shot and maybe you brilliant folks can figure out what I...

I have an Access data base that has acumulated 7 years of HR info. We plan to moving this info to HR Application. The new application has a field called field...

I know this might seem technically wrong and therefore, I haven’t found advice on how to do it on these postings. I have an Access 03 table...

I am working on updates to a couple related databases (not linked by any tables) and have a question about virtues of Make Table vs Append queries. Make...

I am trying to create a validation rule for a table field that will prevent the use of the ampersand character (&). InStr(1,,"&",1)0 does not work. What is...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

I used the table analyzer on imported data. good. Noticed that a SELECT statement on the imported data includes the term as noted in the subject line, as xyz...

I didn't normalize my database as well as I wish I had. I have a table called EmpInfo that's built essentially as...

I have a table named Items, in this table the items are defined by Name, Size, and Format. When first setting up the table I added a few of my items to get...

I'm building a database for my personal training business, and currently I ran into a huge pickle and don't know how to bite it. My problem is this, a client...

I need to do an update to change all blank fields to a 0 (zero). In the criteria, I have tried IsNull and it is not returning any of the blank records. I...

I need to (very quickly) create a program that is user friendly that would be used by a small corner store to track sales/inventory/expenses/employees/etc. ...

I developed a table that includes 245 records (competitors) for an upcoming Taekwondo Tournament. Along with the table I also developed a form, query and...

I have the same problem. All of the underlying Excel spreadsheets are maintained by other people. If one them opens the file for editing, you're locked out. I...

I’m about to finish my first database and am in the planning stages to create another. I want to express my gratitude to all that helped me with this. I...