what does this mean?

Heya could someone please explain this query to me in depth?



i know its an update query that signs a user in when they have a booking



but i dont really know how i would explain it in depth..



any help would be lovely:)



thank you

Attached Images

bookingqry.png (6.4 KB)

what does this mean?

Compile different database name

I made a copy of my database named Stores and named it as Purchasing.

I did this as they are basically identical except Purchasing has some other tables, forms, etc...



When I click on the Debug/ Compile it says Compile Stores, is there a way to change this so it says Compile Purchasing.



Without having to create a new database and import everything.

Compile different database name

Sum() adding 1 to the overall result?

This is bizzare.



I have a report...with one number at the end of a line, beneath is a sum() of all the numbers above.



To test this report, I have ensured there is just one line to 'sum' ....this particular number happens to be $15.82, yet the field showing the sum of this is displaying $15.83 ...I'm going potty here trying to work out where the extra 1 is being added...it's not a rounding error as there are no further decimals involved, both fields are set to 'fixed' 2 decimal places.



Any ideas?!!!!!

Sum() adding 1 to the overall result?

select query return "text" instead of "boolean value"

Hello,



it's been a long time since i did some SQL queries on MS Access, but i forgot how to do to return a text for each row (as field value) when a table field contains "1" as value ?

for example i have a table named "products" with a field/column called "promotion". Sometime a product is promotional, so in this case, the "promo" column holds "1" as value.



during a select on products table, how can i do to return "in promotion" (e.g.) if the column "promo" holds "1" for a product ?



thx.

select query return "text" instead of "boolean value"

Remote Data to be collated

I have 4 sites one of which is head Office. Each has a Database that records among other stuff the hours an employee works. Roughly 10 per site.



One site is the Head Office where the payroll is processed.



I want to get the Data contained in the table Employee times and send them to HO so that they can be uploaded into the main Database which is essentially the same as the others.



All sites have internet access but they are not connected in any way.



Does anyone have a suggestion on how I should move this data about.

Remote Data to be collated

Capture picture from webcam

Hi,



I am developing a Student Database that shall capture Biometric and Pictures.

I got the fingerprint on an access form. However I cannot get image directly from the webcam to an access form. I have to use the manufacturer's software to capture the image before importing to access using .picture property.



Is there any way of capturing the image directly from the cam to an access form?:banghead::(

Capture picture from webcam

Off2013-Cannot open a database created with a previous version of your application

Hello,



My department is rolling out Office2013 to the workstations in the next few weeks, and I was tasked with testing the various MS Access apps with the new version.



I expected some normal stuff, such as files/references to be weird - normal stuff.



But this is a problem I don't know how to handle. When I fire up this older MS Access app using Office 2013 I get the following message:



"Cannot open a database created with a previous version of your application"



And then the app closes... The app is called by a shortcut that has a /wrkgrp parameter since the app is using an mdw for security. ALso the app is split into a backend that lies on the network, and all the users have local front ends on their machine.



My first thought that this was a problem because the data storage container was perhaps an old version... so I opened the application's parts (the front end, and the backend) individually and did the Save and Publish to "2002 - 2003" format but still get that error.



Am I barking up the wrong tree? How can I find out what version of the db this is? It opens and runs fine in Office 2010. I'm beginning to freak out a little bit...



Is "save and publish" the same as Convert?



Thanks,

-Matt G.

Off2013-Cannot open a database created with a previous version of your application