Search results

I am using a linked table from another database and a "local" table to compare data. The linked table always has the correct information so I am utilizing append and delete queries to ensure my local one stays up to date as well. These tables record upcoming community type events. The linked...

Multi-User & Cannot use Make-Table Query Good Afternoon~ After about a 3 week hiatus, I've decided to dive into my ACCESS project which caused much grief last time I was updating it. I have a database which will contain about 7k records at all times. This database will be used by about 12-20...

Panic Mode=True I've spent the past few weeks developing a database that uses some linked tables, append queries, delete queries and a MakeTable query. It all works splendid when little ol' me is using it, however it's time for it to go "live" and after reading all the benefits of splitting...

Win95 / Access97 Need Network User name ~ SOLVED~ Good afternoon~ After a few searches and copy/paste attempts, it seems I am unable to accomplish my new task: To obtain the network userID of the current user. The codes I used may not work very well with Windows95 and Access 97 (Yes, pity...

Afternoon~ I am using a database to compile a report which will group all dates in a weekly fashion. Unfortunately, my company recognizes Monday as the first day of the week, and not Sunday as ACCESS does. Therefore, when I sum the "weekly" totals, my figure is not correct. I reserached here...

Good afternoon~ I have a table which contains information downloaded from an AS400 system. From this table I've created a query for the information I wish to use in a future report. One of the fields is called Canteen and contains varied entries. There are 3 Types of Canteens, AR SP and CH...

Please forgive me if this question is a no-brainer for all of you. My company still uses the good ol AS400 for storing a lot of information. Currently, we download some of this information into an ACCESS database for our manipulation pleasures. What I would like to do is then link the ACCESS...

I will try to make this as simple as possible. I have a report that runs off a query. The report has 2 grouping levels. For simplicity, the first grouping level is "Car or Truck". The second grouping level is "Chevy, Dodge, Ford etc." I have it all set up to calculate the total of all Cars or...

Greetings~ I wish to create a form that will launch a report based on a user's input for particular fields. One of the fields is from a list box I have created which lists the options available. The other field would be a date range. e.g. I would like to see all the sales of Laura Smith from...

Greetings~ I have created a database to store information regarding number of donations and dates by each patient. I have created a List Box to quickly look up a patient's information in order to update it. I used [LastName], [FirstName], [M], [BloodType] as identifying information based on a...

Greetings~ I have created a database which tracks the amount of pheresis donations of a patient. I have a text box to record the date of the last donation [LastDonation]. I have a text box to record the number of donations [NumberofDonations]. I also have several text boxes to record the dates...

..please bear with me. I have created a database for storing injury and reaction information. The form and queries and reports are functioning just fine. My organization's fiscal year starts on July 01 and ends on Jun 30. Alexandre was wonderful to show me how to change the "Quarter"...

Hello~ I wish to sort information from a query in a report by Quarter. I am aware of how to do this normally, however my problem is my organization's fiscal quarters are not the same as usual yearly quarters. For example, all dates in September for my organization are Q1 as our fiscal year...