Search results

Check Zoom under View. It sounds like one of you is set to Page Width and the other to 100%

You could use DateSerial. Something like =DateSerial(Year([StartDate]),Month([StartDate]),Day([StartDate])-12)

Assuming by the area this was posted in, you are using SQL Server. SQL Server has a Mask function that can be used to dynamically mask results as they are pulled. You would need to do a custom mask. You can find more information here.

Ultimately this is what I did. I created a new query with the crosstab and the other table with the institution name in it, with a left join between them. As for the issues with the crosstab query, given the nature of my database and the type of data they are asking me to pull, it is not...

Since the report is based on a crosstab query, that is why I opted to cheat and put the label using dlookup.

I am using dlookup in a report to pull the name of a facility using the cost center that was entered in a form. This is creating some weird consequences. When the report is displayed in report view, it takes about 10 seconds to look up the name of the facility and to then show the other...

Nope no error messages at all. That's part of my frustration.

Thanks for the advice. When I rebuild the db I will implement it... As for the import code. I have been importing the new data into a separate table then running an append query like below for each original table. INSERT INTO Assignments ( [Assignment Name], [Assignment Type], [Assignment...

The new data is formatted just like the original data, but contains new assignments that were made after the db was created. It should not have new departments but may have new student groups, assigners/creators, or courses. It would of course have new dates as well.

I don't think that table 2 is being updated and I am not sure how to go about that when I append the data. When I go to the individual tables, I can see the data there. However when I run a query the new data doesn't show. I did not include most of the queries just the two most basic. However...

Here is an zipped file with the structure and a sample of the data as I get it. I have to strip out a lot of data because of security.... Table names and relationships are all the same.

I have a huge database that tracks my company's employee training. As of mid-July it was 154k records. The data comes to us as a .csv file. After importing and normalizing the data, I end up with 7 tables and a master table with lookups to the others. I can easily append the data to each...